SELECT a.party_id, r.role_id FROM pm_project_assignment a, pm_roles r WHERE a.role_id = r.role_id and a.project_id = :project_item_id ORDER BY r.role_id select first_names ||' '|| last_name as fullname from persons where person_id = :search_user_id select group_name from groups where group_id = :search_user_id