postgresql7.1 select t.task_id, t.transition_key, t.state, t.case_id, tr.transition_name, to_char(t.enabled_date, :date_format) as enabled_date_pretty, to_char(t.started_date, :date_format) as started_date_pretty, to_char(t.canceled_date, :date_format) as canceled_date_pretty, to_char(t.overridden_date, :date_format) as overridden_date_pretty, to_char(t.finished_date, :date_format) as finished_date_pretty, to_char(coalesce(t.finished_date, coalesce(t.canceled_date, t.overridden_date)), :date_format) as done_date_pretty, p.party_id as done_by_party_id, '' as done_by_url, acs_object__name(p.party_id) as done_by_name, p.email as done_by_email from wf_transitions tr, wf_tasks t LEFT OUTER JOIN parties p ON (t.holding_user = p.party_id) where t.case_id = :case_id and t.state not in ('enabled', 'started') and tr.workflow_key = t.workflow_key and tr.transition_key = t.transition_key order by t.enabled_date desc