Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewiki_p; select user_name, count(page_title) from user join revision_userindex join page on user_id = rev_user and rev_page = page_id where page_namespace = 0 and not page_is_redirect and rev_parent_id = 0 and rev_deleted = 0 and page_len > 100000 group by user_name having count(page_title) >= 1 order by count(page_title) desc
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in