Untitled query #33370

SQL

use itwiki_p;

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...
