USE nlwiki_p;

SELECT `tl_title` AS "Sjabloon", `count(tl_from)` AS "Aantal" FROM `templatelinks`

WHERE `tl_namespace` = 10

AND `tl_from_namespace` = 1

AND `tl_title` LIKE "Infobox%"

AND exists

(SELECT * FROM `page`

 WHERE `page_namespace` = 10

 AND `page_title` = `tl_title`

 AND not exists

 (SELECT * FROM `page_props`

  WHERE pp_page = page_id

  AND pp_propname = "templatedata"))

GROUP BY tl_title

ORDER BY count(tl_from) desc

LIMIT 500