Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; set @lastmonth = '20160727000000'; -- YYYYMMDD000000 select rev_user_text, count(rev_id) rev_count from ( select rev_id, rev_user_text from revision where rev_timestamp > @lastmonth and rev_user <> 0 -- exclude IPs ) lm group by rev_user_text having rev_count > 40 order by rev_count 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