Advertisement
Guest User

Untitled

a guest
Jul 6th, 2015
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. SELECT requests.id, "type", "from", u1.username AS "fromName", "to", u2.username AS "toName",
  2. extra1, ARRAY(SELECT items.name FROM items JOIN requests AS r1 ON items.id = ANY(r1.extra1) WHERE r1.id = requests.id) AS items1,
  3. extra2, ARRAY(SELECT items.name FROM items JOIN requests AS r1 ON items.id = ANY(r1.extra2) WHERE r1.id = requests.id) AS items2,
  4. "extraInt", u3.username AS "mmName", extrastring
  5. FROM requests
  6. JOIN users AS u1 ON requests.from = u1.userid
  7. JOIN users AS u2 ON requests.to = u2.userid
  8. LEFT JOIN users AS u3 ON requests."extraInt" = u3.userid;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement