SELECT p.item_id, p.project_id, p.parent_id as folder_id, p.object_type as content_type, p.title as project_name, p.project_code, to_char(p.planned_start_date, 'YYYY-MM-DD HH24:MI:SS') as planned_start_date, to_char(p.planned_end_date, 'YYYY-MM-DD HH24:MI:SS') as planned_end_date, p.ongoing_p, p.actual_hours_completed, p.estimated_hours_total FROM pm_projectsx p, cr_items i WHERE p.project_id = i.live_revision and p.parent_id = :project_item_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = :project_item_id and ppm.privilege = 'read' and ppm.party_id = :user_id) ORDER BY p.title