Most common templates for Commons file pages linked from a page

SQL

use commonswiki_p;

SELECT COUNT(DISTINCT(pl.pl_title)) AS $count, tl.tl_title  

FROM page AS p0
JOIN pagelinks AS pl ON pl.pl_from=p0.page_id AND pl.pl_from_namespace=p0.page_namespace AND pl.pl_namespace=6
               # links to file description pages
JOIN page AS fp ON fp.page_namespace = pl.pl_namespace AND fp.page_title = pl.pl_title
JOIN templatelinks AS tl ON tl.tl_from = fp.page_id
               # categories for file description pages

WHERE p0.page_title='British_Library/MC_maps_batch_01_(GB_counties)' AND p0.page_namespace=4
GROUP BY tl.tl_title
ORDER BY $count DESC

SQL

Checking query status...