Skip to content

Instantly share code, notes, and snippets.

@atopal
Last active August 29, 2015 14:27
Show Gist options
  • Save atopal/c19d5a4eedb162788eec to your computer and use it in GitHub Desktop.
Save atopal/c19d5a4eedb162788eec to your computer and use it in GitHub Desktop.
Number of characters in English KB
SELECT SUM(LENGTH(`wiki_revision`.`content`))
FROM `wiki_document`
JOIN `wiki_document_products` ON `wiki_document`.`id` = `wiki_document_products`.`document_id`
JOIN `wiki_revision` ON `wiki_document`.`current_revision_id` = `wiki_revision`.`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_document`.`html` LIKE '%data-for%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment