interfaceadmin in userspace edits for pl.ws & mul.ws

SQL

use plwikisource_p;
select user, css, js, css+js 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 = 2 and page_title rlike '^.*\.(css|js|json)$' and page_title not rlike CONCAT('^',REPLACE(rev_user_text,' ','_')) group by user, ext) edits group by user) edits2 where css + js > 0 order by css + js desc;
use sourceswiki_p;
select user, css, js, css+js 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 = 2 and page_title rlike '^.*\.(css|js|json)$' and page_title not rlike CONCAT('^',REPLACE(rev_user_text,' ','_')) group by user, ext) edits group by user) edits2 where css + js > 0 order by css + js desc;
select user, css, js, css+js 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 > 0 order by css + js desc;
SQL

Checking query status...
