Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Krinkle
.
Toggle Highlighting
SQL
( SELECT COUNT(rev_id) AS _count, rev_comment_id FROM revision -- first 5M edits (<2006) WHERE rev_id < 5000000 GROUP BY rev_comment_id ORDER BY _count DESC LIMIT 10 ) UNION ( SELECT '---' AS _count, '---' AS rev_comment_id FROM revision WHERE 1=1 LIMIT 1 ) UNION ( SELECT COUNT(rev_id) AS _count, rev_comment_id FROM revision -- last 1M edits from 64M to 65M (2023) WHERE rev_id >= 64000000 AND rev_id < 65000000 GROUP BY rev_comment_id ORDER BY _count 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...