Replicas browser and optimizer
This query is marked as a draft
This query has been published
André Costa (WMSE)
rev_user_text is used to capture those discussions that involve many anons.
select page_id, page_title, count(rev_page) as edits, count(distinct rev_user_text) as users from svwiki_p.revision r join svwiki_p.page p on p.page_id = r.rev_page where p.page_namespace = 1 group by page_id order by edits desc limit 10
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