postgresql7.1 select item_id, content_type from cr_items where parent_id = :project_item_id select sum(p.actual_hours_completed) as projects_total_hours_worked from pm_projectsx p, cr_items i where p.item_id in ([join $project_list ", "]) and i.live_revision = p.revision_id select sum(t.actual_hours_worked) as tasks_total_hours_worked from pm_tasks_revisionsx t, cr_items i where t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id update pm_projects set actual_hours_completed = :total_hours_worked where project_id = (select live_revision from cr_items where item_id = :project_item_id) select parent_id from cr_items where item_id = :my_item_id select pm_project__get_root_folder (:package_id, 'f')