Skip to content

Instantly share code, notes, and snippets.

@glennpratt

glennpratt/user_og.sql

Created September 23, 2011 12:55
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save glennpratt/1237265 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save glennpratt/1237265 to your computer and use it in GitHub Desktop.
Download ZIP
make this distinct
Raw
user_og.sql
SELECT DISTINCT(users.uid) AS uid
, og_uid.created AS og_uid_created
FROM users users LEFT JOIN og_uid og_uid ON users.uid = og_uid.uid
WHERE og_uid.nid IN (127998, 128028, 196548, 196558, 196538, 196528, 196568, 128018, 128098, 128068, 128088, 128078, 128058, 128038);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment