SELECT t.item_id, t.title as task_title, t.description, to_char(t.start_date,'MM/DD/YYYY') as start_date, to_char(t.end_date,'MM/DD/YYYY') as end_date, t.percent_complete FROM pm_tasks_revisionsx t, cr_items i WHERE t.item_id = :task_id and t.revision_id = i.live_revision