Untitled query #70821

SQL

USE svwiki_p;
SELECT lt_title, COUNT(page_title) AS antal FROM page INNER JOIN templatelinks ON page_id=tl_from 
INNER JOIN linktarget ON tl_target_id = lt_id WHERE
page_namespace = 0 AND
lt_title IN (SELECT page_title FROM categorylinks INNER JOIN page on cl_from=page_id WHERE cl_to='Mallar_som_använder_data_från_Wikidata')
GROUP BY lt_title;

USE fiwiki_p;
SELECT lt_title, COUNT(page_title) AS antal FROM page INNER JOIN templatelinks ON page_id=tl_from 
INNER JOIN linktarget ON tl_target_id = lt_id WHERE
page_namespace = 0 AND
lt_title IN (SELECT page_title FROM categorylinks INNER JOIN page on cl_from=page_id WHERE cl_to='Wikidataa_hyödyntävät_mallineet')
GROUP BY lt_title;
SQL

Checking query status...
