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 recentchanges JOIN actor_recentchanges ON actor_id = rc_actor JOIN page ON page_namespace = rc_namespace AND page_title = rc_title WHERE rc_new = 1 AND rc_namespace = 0 AND page_is_redirect = 0 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...