SELECT a.project_id, r.one_line as role_name, p.first_names || ' ' || p.last_name as user_name, r.is_lead_p FROM pm_project_assignment a, pm_roles r, persons p WHERE a.role_id = r.role_id and a.party_id = p.person_id and project_id = :project_item_id ORDER BY r.role_id, p.first_names, p.last_name