Template counter

SQL

SELECT page_title, COUNT(*) AS inclusion_count
FROM linktarget
  LEFT JOIN templatelinks ON lt_id = tl_target_id
  LEFT JOIN page ON tl_from = page_id
WHERE lt_namespace = 10 -- Template:
  AND lt_title IN ('Az+en','Az+en+ru','Az+en+ru+fr','Az+ru','Ca+en','Ca+en+es','Ca+es','Ca+eu+en+es+gl','Ca+fr','De+fr','El+en','El+fr','En+ar','En+cs','En+da','En+de','En+es','En+fa','En+fi','En+grc','En+hu','En+id','En+it','En+ja','En+ka','En+ko','En+nl','En+no','En+pl','En+pt','En+ro','En+ru','En+sl','En+sr','En+tr','En+zh','En+zh+ja','Fr+ar','Fr+de','Fr+en','Fr+en+de','Fr+en+es','Fr+en+es+de','Fr+en+es+ja','Fr+en+it','Fr+en+nl','Fr+en+no','Fr+es','Fr+grc','Fr+he','Fr+nl','Fr+nl+de','Fr+nl+en','Fr+nl+en+de','Grc+en','He+en','Hu+en','Hu+fr','Hy+en','Hy+ru+en','La+en','La+fr','Lb+fr+de','Lb+fr+de+en','Nl+en','Nl+fr','Nl+fr+de','Nl+fr+en','Nl+fr+en+de','Ro+en+fr','Tr+en')
  AND tl_from_namespace = 0
GROUP BY page_title;
SQL

Checking query status...
