Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. dc03268la6dgb1=> select u.account_id, u.first_name, u.last_name, u.email, u.enabled, u.last_activity_at, g.name as group_name, o.name as org_name from users as u left outer join group_memberships as gm on gm.user_id = u.id left outer join groups as g on gm.group_id = g.id left outer join organizations as o on g.organization_id = o.id \g /home/alanp/users.txt
  2. Time: 713.752 ms
  3. dc03268la6dgb1=> select u.account_id, u.first_name, u.last_name, u.email, u.enabled, u.last_activity_at, g.name as group_name, o.name as org_name from users as u join group_memberships as gm on gm.user_id = u.id join groups as g on gm.gro
  4. up_id = g.id join organizations as o on g.organization_id = o.id \g /home/alanp/org-users.txt
  5. Time: 19.499 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement