organisation_project_role.status = 1 AND organisation_project_role.startDate <= NOW() AND (organisation_project_role.endDate IS NULL OR organisation_project_role.endDate >= NOW())

AND

organisation_project_role.user_id IN (SELECT user_id FROM admin_user_role WHERE role_id = 10)