select t.process_task_id as task_id, t.one_line as task_title, t.description, d.parent_task_id 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 $use_dependency_list ", "]) ORDER BY t.ordering, t.process_task_id select short_name, description FROM pm_task_dependency_types ORDER BY short_name select process_task_id as task_id, one_line as task_title FROM pm_process_task WHERE process_id = :process_id ORDER BY ordering