Advertisement
Guest User

Untitled

a guest
Nov 14th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM (
  2.             SELECT t.*, array_to_json(array_agg(row_to_json(tu2))) as userss
  3.             FROM tasks t
  4.             INNER JOIN (
  5.                         SELECT tu.task_id, tu.role_id, u.name, u.email
  6.                         FROM task_users tu
  7.                         INNER JOIN core."user" u ON u.id = tu.user_id
  8.                         WHERE EXISTS (
  9.                                     SELECT *
  10.                                     FROM task_users tuA
  11.                                     INNER JOIN core."user" uA ON uA.id = tuA.user_id
  12.                                     WHERE tuA.task_id = tu.task_id
  13.                                     AND tuA.user_id = 27 AND tuA.role_id = '4'
  14.                         )  AND
  15.                         EXISTS (
  16.                                     SELECT *
  17.                                     FROM task_users tuA
  18.                                     INNER JOIN core."user" uA ON uA.id = tuA.user_id
  19.                                     WHERE tuA.task_id = tu.task_id
  20.                                     AND tuA.user_id = 11 AND tuA.role_id = '3'
  21.                         )
  22.             ) tu2 ON tu2.task_id = t."id"
  23.             GROUP BY t.id
  24. ) as test1
  25. INNER JOIN task_states ON test1.state_id = task_states.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement