Skip to content

Instantly share code, notes, and snippets.

@atopal

atopal/gist:b333524d7fc659bfc15c

Created May 9, 2014 16:03
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save atopal/b333524d7fc659bfc15c to your computer and use it in GitHub Desktop.
Download ZIP
All contributors to Firefox OS articles
Raw
gistfile1.txt
SELECT DISTINCT `auth_user`.`username`
FROM (SELECT * FROM `wiki_document_products` WHERE `wiki_document_products`.`product_id` = 4) FirefoxOSdocs
JOIN `wiki_document_contributors` ON `wiki_document_contributors`.`document_id` = FirefoxOSdocs.`document_id`
LEFT JOIN `auth_user` ON `auth_user`.`id` = `wiki_document_contributors`.`user_id`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment