Test query - Quarry

SQL

use commonswiki_p;
select count(cl_from) as Counter, cl_sortkey_prefix as ID, concat("File:", page_title) as Name, Category
from categorylinks
join page
on page_id = cl_from
join (select page_title as Category
 from categorylinks
 where cl_to = "Cultural_heritage_monuments_in_Iran_with_known_IDs"
 and cl_type = "subcat"
 group by cl_sortkey_prefix
 order by cl_sortkey_prefix asc
 join page
 on page_id = cl_from
) as CATER
on page_id = cl_from
where cl_to = "Cultural_heritage_monuments_in_Iran_with_known_IDs"
and cl_type = "file"
group by cl_sortkey_prefix
order by cl_sortkey_prefix asc
limit 100;
SQL

Checking query status...
