select role || '' || CASE WHEN public_role_p THEN ' (public role)' ELSE '' END, role_id from events_organizer_roles where role_id not in (select role_id from events_org_role_activity_map where activity_id = :activity_id) select role || '' || CASE WHEN public_role_p = 't' THEN ' (public role)' ELSE '' END, role_id from events_organizer_roles where role_id not in (select role_id from events_org_role_event_map where event_id = :event_id)