select title as one_line, description, item_id FROM pm_tasks_revisionsx t WHERE revision_id in ([join $revisions ","]) ORDER BY item_id select title FROM pm_projects p, cr_revisions r, cr_items i WHERE r.item_id = :project_item_id and i.item_id = r.item_id and p.project_id = i.live_revision and p.project_id = r.revision_id select t.title as one_line, t.description, t.item_id, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, to_char(t.earliest_start, 'YYYY-MM-DD HH24:MI:SS') as earliest_start_ansi, to_char(t.earliest_finish, 'YYYY-MM-DD HH24:MI:SS') as earliest_finish_ansi, to_char(t.latest_start, 'YYYY-MM-DD HH24:MI:SS') as latest_start_ansi, to_char(t.latest_finish, 'YYYY-MM-DD HH24:MI:SS') as latest_finish_ansi, proj_rev.title as project_name FROM pm_tasks_revisionsx t, cr_items proj, cr_revisions proj_rev WHERE t.revision_id in ([join $revisions ","]) and t.parent_id = proj.item_id and proj.live_revision = proj_rev.revision_id ORDER BY item_id select p.first_names || ' ' || p.last_name as who, p.person_id FROM persons p, acs_rels r, membership_rels mr WHERE r.object_id_one = :user_group_id and mr.rel_id = r.rel_id and p.person_id = r.object_id_two and member_state = 'approved' ORDER BY p.first_names, p.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