Replicas browser and optimizer
This query is marked as a draft
This query has been published
use cswiki_p; select user_name from user where user_id in (select ug_user from user_groups where ug_group="autopatrolled") and user_id in (select rev_user from revision join page on page_id=rev_page where page_namespace%2=1 and rev_timestamp like "2018%" group by rev_user having count(*)>50) and user_editcount>500 and user_id not in (select ug_user from user_groups where ug_group="arbcom");
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