select t.process_task_id as task_id, t.one_line as task_title, t.description FROM pm_process_task t WHERE t.process_task_id in ([join $process_task_id ", "]) select short_name, description FROM pm_task_dependency_types ORDER BY short_name select r.item_id, r.title as task_title FROM pm_process_tasks WHERE process_id = :process_id ORDER BY upper(one_line) INSERT INTO pm_process_task_dependency (dependency_id, task_id, parent_task_id, dependency_type) VALUES (:dependency_id, :tsk_id, :parent_tsk_id, :type_id)