SQL
AخA
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.
All SQL code is licensed under CC0 License.