USE nlwiki_p;

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

WHERE `tl_namespace` = 10

AND `tl_title` LIKE "Infobox%"

AND `tl_title` NOT LIKE "%/%"

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