select t.sort_order, t.transition_key, t.transition_name, t.trigger_type, '' as trigger_type_pretty, t.role_key, r.role_name, '' as delete_url, '' as edit_url, '' as role_edit_url from wf_transitions t left outer join wf_roles r on (r.workflow_key = t.workflow_key and r.role_key = t.role_key) where t.workflow_key = :workflow_key order by t.sort_order