Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT "user"."id" AS "id", "user"."username" AS "username",
  2. (SELECT string_agg(region_name, ',') AS region_name
  3. FROM (SELECT DISTINCT region_name
  4. FROM auth.entity
  5. INNER JOIN auth.user_entity on entity.id = user_entity.entity_id
  6. AND "user".id = auth.user_entity.user_id) users) AS "regionName"
  7. FROM auth.[user] "user"
  8. WHERE "user".id = 12
  9. )
  10. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement