use enwiki_p;

SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt

#FROM page AS wp

from templatelinks tl# ON tl.tl_from = wp.page_id and tl_namespace=10

#select tl.tl_from from templatelinks tl

#                       where tl.tl_title="Ezera_infokaste" and tl_namespace=10 and tl.tl_from_namespace=0

#JOIN templatelinks tl ON tl.tl_from = wp.page_id and tl_namespace=10

LEFT JOIN page_props AS pp

  ON pp.pp_page = tl.tl_from AND pp.pp_propname = 'wikibase_item'

WHERE tl_title like "Infobox%" and tl_namespace=10 and tl.tl_from_namespace=0

AND   pp_value IS NULL

GROUP BY tl_title

#HAVING COUNT(tl_title)>10

ORDER BY COUNT(tl_title) DESC

limit 2000;