Skip to content

Instantly share code, notes, and snippets.

@atopal
Last active August 29, 2015 14:27
Show Gist options
  • Save atopal/6958a4d1b72193751eb6 to your computer and use it in GitHub Desktop.
Save atopal/6958a4d1b72193751eb6 to your computer and use it in GitHub Desktop.
Number of reviewed edits ready for L10n for a certain time frame
SELECT *
FROM `wiki_document`
#JOIN `wiki_document_products` ON `wiki_document`.`id` = `wiki_document_products`.`document_id`
JOIN `wiki_revision` ON `wiki_document`.`id`= `wiki_revision`.`document_id`
WHERE `wiki_document`.`locale`="en-US"
#AND `wiki_document_products`.`product_id` = 1
AND `wiki_document`.`is_archived` = 0
AND `wiki_document`.`current_revision_id` IS NOT NULL
AND `wiki_document`.`html` NOT LIKE '%REDIRECT%'
AND `wiki_revision`.`reviewed`IS NOT NULL
AND `wiki_revision`.`readied_for_localization` IS NOT NULL
AND `wiki_revision`.`created` BETWEEN '2015-06-30' AND '2015-08-12'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment