Test query - Quarry

SQL

use commonswiki_p;
select count(cl_from) as Counter, concat("{{/Template|",cl_sortkey_prefix, "}}") as ID, concat("[[:File:", page_title, "]]") as Name,
(select distinct cl_sortkey_prefix
 from categorylinks
 join page
 on page_id = cl_from
 where cl_to = "Cultural_heritage_monuments_in_Iran_with_known_IDs"
 and cl_type = "subcat"
) as BLA
from categorylinks
join page
on page_id = cl_from
where cl_to = "Cultural_heritage_monuments_in_Iran_with_known_IDs"
and cl_type = "file"
and cl_sortkey_prefix not in (select distinct cl_sortkey_prefix
 from categorylinks
 join page
 on page_id = cl_from
 where cl_to = "Cultural_heritage_monuments_in_Iran_with_known_IDs"
 and cl_type = "subcat"
)
group by cl_sortkey_prefix
order by Counter desc
limit 100;
SQL

Checking query status...
