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
Cryptic
.
Most prolific article creators in the last ~30 days. Counts only non-redirect pages currently in the main namespace, with their first edit June 1 2022 or later. In particular, it doesn't count redirects or drafts created earlier that became mainspace articles since June 1, nor articles that have since been deleted, redirected, or moved out of mainspace. Only users with at least three articles are listed. For [[Wikipedia talk:Arbitration/Requests/Case/Conduct in deletion-related editing/Evidence#BEFORE / Burden of proof]] circa 1 July 2022.
Toggle Highlighting
SQL
SELECT COUNT(*), actor_name FROM revision JOIN actor_revision ON actor_id = rev_actor JOIN page ON page_id = rev_page WHERE rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 0 AND rev_timestamp >= '20220601' GROUP BY actor_name HAVING COUNT(*) >= 3 ORDER BY COUNT(*) DESC;
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...