Untitled query #5920

SQL

use enwiki_p;

select utc_timestamp(6) ts_before;

select
	cat_id,
    cat_pages, cat_pages_new,
    cat_subcats, cat_subcats_new,
    cat_files, cat_files_new
from (select
      	coalesce(sum(pages), 0) cat_pages_new,
      	coalesce(sum(case when cl_type = 'subcat' then pages else 0 end), 0) cat_subcats_new,
      	coalesce(sum(case when cl_type = 'file' then pages else 0 end), 0) cat_files_new
      from (select cl_type, COUNT(*) pages
            from categorylinks
            where cl_to = 'All_stub_articles'
            group by cl_type
           ) clInnerQuery
     ) clOuterQuery
left join category on cat_title = 'All_stub_articles';

select utc_timestamp(6) ts_after;
SQL

Checking query status...
