SQL
x
USE wikidatawiki_p;
SELECT revision.rev_user_text as Username,
COUNT(revision.rev_user_text) AS cnt
FROM page
JOIN revision ON page.page_id=revision.rev_page
JOIN USER ON revision.rev_user=user.user_id
WHERE page.page_namespace=146
AND revision.rev_parent_id=0
GROUP BY revision.rev_user
ORDER BY cnt DESC
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.