select item_id FROM pm_tasks_revisionsx t WHERE revision_id in ([join $revisions ","]) select title as one_line, description, item_id FROM pm_tasks_revisionsx t WHERE revision_id in ([join $revisions ","]) ORDER BY item_id select first_names || ' ' || last_name || ' (' || email || ')' as who, person_id FROM cc_users ORDER BY first_names, last_name select one_line, role_id FROM pm_roles ORDER BY sort_order delete from pm_task_assignment where task_id in ([join $task_id ","]) insert into pm_task_assignment (task_id, role_id, party_id) values (:t_id, :r_id, :p_id) select party_id FROM pm_task_assignment WHERE task_id = :tiid select role_id FROM pm_task_assignment a WHERE task_id = :tiid select role_id as rid, party_id as pid FROM pm_process_task_assignment a WHERE process_task_id = :ptid