Article creators by volume since June 1

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.

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;

AخA
 
SELECT COUNT(*), actor_nameFROM recentchangesJOIN actor_recentchanges ON actor_id = rc_actorJOIN page ON page_namespace = rc_namespace AND page_title = rc_titleWHERE rc_new = 1  AND rc_namespace = 0  AND page_is_redirect = 0GROUP BY actor_nameHAVING COUNT(*) >= 3ORDER BY COUNT(*) DESC;

SQL

Checking query status...