Most common categories (+qids) for file pages with BHL template

SQL

use commonswiki_p;

SELECT COUNT(DISTINCT(tl.tl_from)) AS $count, cpp.pp_value, cl.cl_to

FROM templatelinks AS tl 
JOIN categorylinks AS cl ON cl.cl_from = tl.tl_from
               # categories for file description pages
JOIN page AS cp ON cp.page_namespace = 14 AND cp.page_title = cl.cl_to
LEFT JOIN page_props AS cpp ON cpp.pp_page = cp.page_id AND cpp.pp_propname = 'wikibase_item'


WHERE tl.tl_title='BHL' AND tl.tl_namespace=10  AND tl.tl_from_namespace = 6
GROUP BY cl.cl_to, cpp.pp_value
ORDER BY $count DESC

SQL

Checking query status...