use nlwiki_p;

select tl_title as "Sjabloon", count(tl_from) as "Aantal" from templatelinks

where tl_namespace = 10

and  tl_title like "C%" 

and not tl_title like "Country_data%"

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 200