Skip to content

Instantly share code, notes, and snippets.

@atopal
Created July 4, 2013 13:58
Show Gist options
  • Select an option

  • Save atopal/5928005 to your computer and use it in GitHub Desktop.

Select an option

Save atopal/5928005 to your computer and use it in GitHub Desktop.
Articles that had to wait more than 30 days for a review
SELECT `wiki_revision`.`summary`, DATEDIFF(`wiki_revision`.`reviewed`,`wiki_revision`.`created`)
FROM `wiki_revision`
JOIN `wiki_document` ON `wiki_document`.`id`=`wiki_revision`.`document_id`
WHERE `wiki_document`.`locale` LIKE 'en-US'
AND `wiki_revision`.`created` >= '2013-01-01'
AND DATEDIFF(`wiki_revision`.`reviewed`,`wiki_revision`.`created`) >=30;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment