number of revisions created by users

gistfile1.sql

SELECT `auth_user`.`username`, count(*) as edits
FROM `wiki_revision`
JOIN `wiki_document` on `wiki_revision`.`document_id`=`wiki_document`.`id`
JOIN `auth_user`on `wiki_revision`.`creator_id`=`auth_user`.`id`
WHERE `wiki_revision`.`created` >= '2013-01-01'
AND `wiki_document`.`locale` LIKE 'en-US'
GROUP BY `wiki_revision`.`creator_id` ORDER BY edits DESC;