Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT requests.id, "type", "from", u1.username AS "fromName", "to", u2.username AS "toName",
- extra1, ARRAY(SELECT items.name FROM items JOIN requests AS r1 ON items.id = ANY(r1.extra1) WHERE r1.id = requests.id) AS items1,
- extra2, ARRAY(SELECT items.name FROM items JOIN requests AS r1 ON items.id = ANY(r1.extra2) WHERE r1.id = requests.id) AS items2,
- "extraInt", u3.username AS "mmName", extrastring
- FROM requests
- JOIN users AS u1 ON requests.from = u1.userid
- JOIN users AS u2 ON requests.to = u2.userid
- LEFT JOIN users AS u3 ON requests."extraInt" = u3.userid;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement