Skip to content

Instantly share code, notes, and snippets.

@atopal

atopal/guides.sql

Last active May 22, 2017 11:52
Show Gist options
  • Save atopal/945e798cfbd5d645de3dfc08937906b7 to your computer and use it in GitHub Desktop.
Save atopal/945e798cfbd5d645de3dfc08937906b7 to your computer and use it in GitHub Desktop.
Download ZIP
Number of all properly tagged English Web reference and guide pages on MDN
Raw
guides.sql
SELECT `wiki_document`.`slug`
FROM `wiki_document`
JOIN `wiki_taggeddocument` ON `wiki_taggeddocument`.`content_object_id` = `wiki_document`.`id`
WHERE `wiki_taggeddocument`.`tag_id`=6633 -- Guide
AND `wiki_document`.`locale` = "en-US"
AND `wiki_document`.`is_redirect`= 0
AND `wiki_document`.`is_template`= 0
AND `wiki_document`.`deleted`= 0
AND `wiki_document`.`slug` LIKE "Web/%"
Raw
references.sql
SELECT `wiki_document`.`slug`
FROM `wiki_document`
JOIN `wiki_taggeddocument` ON `wiki_taggeddocument`.`content_object_id` = `wiki_document`.`id`
WHERE `wiki_taggeddocument`.`tag_id`=42 -- Reference
AND `wiki_document`.`locale` = "en-US"
AND `wiki_document`.`is_redirect`= 0
AND `wiki_document`.`is_template`= 0
AND `wiki_document`.`deleted`= 0
AND `wiki_document`.`slug` LIKE "Web/%"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment