Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM (
- SELECT t.*, array_to_json(array_agg(row_to_json(tu2))) as userss
- FROM tasks t
- INNER JOIN (
- SELECT tu.task_id, tu.role_id, u.name, u.email
- FROM task_users tu
- INNER JOIN core."user" u ON u.id = tu.user_id
- WHERE EXISTS (
- SELECT *
- FROM task_users tuA
- INNER JOIN core."user" uA ON uA.id = tuA.user_id
- WHERE tuA.task_id = tu.task_id
- AND tuA.user_id = 27 AND tuA.role_id = '4'
- ) AND
- EXISTS (
- SELECT *
- FROM task_users tuA
- INNER JOIN core."user" uA ON uA.id = tuA.user_id
- WHERE tuA.task_id = tu.task_id
- AND tuA.user_id = 11 AND tuA.role_id = '3'
- )
- ) tu2 ON tu2.task_id = t."id"
- GROUP BY t.id
- ) as test1
- INNER JOIN task_states ON test1.state_id = task_states.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement