select lt_title as "template", count(tl_from) as "count"

from templatelinks

inner join linktarget on lt_target_id = lt_id

where tl_namespace = 10

and not lt_title like "%/%"

and exists

(select * from page

 where page_namespace = 10

 and page_title = lt_title

 and not exists

 (select * from page_props

  where pp_page = page_id

  and pp_propname = "templatedata"))

group by lt_title

order by count(tl_from) desc

limit 100

​