Replicas browser and optimizer
Admins with CSS/JS edits in zhwiki
This query is marked as a draft
This query has been published
use zhwiki_p; select user_name, cnt from user join user_groups on ug_group = 'sysop' and ug_user = user_id left join (select rev_user_text user, count(*) cnt from page straight_join revision on rev_page = page_id where page_namespace = 8 and page_title rlike '^.*\.(css|js)$' and rev_timestamp >= 20170101000000 group by rev_user_text) edits on user = user_name order by cnt 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