Admins with CSS/JS edits in zh-classical

SQL

use zh_classicalwiki_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)$' group 
by rev_user_text) edits on user = user_name order by cnt desc;

select user, css, js, json, css/(css+js) css_ratio from (select user, sum(case when ext = 'css' then cnt else 0 end) css, sum(case when ext = 'js' then cnt else 0 end) js, sum(case when ext = 'json' then cnt else 0 end) json from (select substr(regexp_substr(page_title, '\.(css|js|json)$'), 2) ext, 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|json)$' group by user, ext) edits group by user) edits2 where css + js > 20 order by css + js desc;
SQL

Checking query status...
