use hewiki_p;

select tl_title as "template", count(tl_from) as "count" from templatelinks

where tl_namespace = 10

and not tl_title 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 100

​