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 ", "]) 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 upper(one_line) DELETE FROM pm_process_task_dependency WHERE process_task_id = :tsk_id INSERT INTO pm_process_task_dependency (dependency_id, process_task_id, parent_task_id, dependency_type) VALUES (:dependency_id, :tsk_id, :parent_tsk_id, :type_id)