Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct tp.* from kat_task_property tp inner join kat_task_to_workstream ttw on ttw.ttw_frn_task_id = tp.tp_frn_task_id and ttw.ttw_frn_workstream_id= :workStreamId and ttw.ttw_ended_by is null and tp.tp_ended_by is null and tp.tp_is_active=true and ttw.ttw_is_active=true left join kat_user_to_task_order kto on ttw.ttw_id = kto.uto_frn_task_to_workstream_id and kto.uto_frn_user_id = :userId order by tp.tp_completed_at ,kto.uto_order limit :index, :size
- tp_id tp_completed_at
- 1 2017-02-27 06:47:52
- 2 null
- 3 null
- 4 2017-03-14 12:59:24
- 5 null
- 6 null
- 7 null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement