Skip to content

Instantly share code, notes, and snippets.

@atopal

atopal/gist:769f19f01676a97483cf

Last active August 29, 2015 14:21
Show Gist options
  • Save atopal/769f19f01676a97483cf to your computer and use it in GitHub Desktop.
Save atopal/769f19f01676a97483cf to your computer and use it in GitHub Desktop.
Download ZIP
All English user facing active articles across all products
Raw
gistfile1.sql
SELECT `wiki_document`.`id`, `wiki_document`.`title`
FROM `wiki_document`
WHERE `wiki_document`.`locale` = "en-US"
AND `wiki_document`.`is_template` = 0
AND `wiki_document`.`is_archived` = 0
AND (`wiki_document`.`category` = 10 OR `wiki_document`.`category` = 20)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment