Fork of
Most Active IP Editors
by Milimetric (WMF)
This query is marked as a draft
This query has been published
by Quiddity (WMF).
SQL
x
use enwiki_p;
select rev_user_text, count(*) edits
from revision
where rev_user = 0
and rev_timestamp > '20170409000000'
group by rev_user_text
order by edits desc
limit 50
;
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.