SELECT t.process_task_id as pti, t.one_line, t.description, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, d.dependency_type, t.ordering FROM pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id WHERE t.process_task_id in ([join $process_task_id ", "]) ORDER BY t.ordering, t.process_task_id SELECT a.party_id, a.role_id FROM pm_process_task_assignment a WHERE a.process_task_id = :process_task_id_tmp ORDER BY a.role_id