template usage

SQL

USE arwiki_p;
select DISTINCT concat("قالب:",page_title) as pagename, count(*) > 100 as tot
from page 
join templatelinks on page_title = tl_title and tl_namespace = 10 
#where page_title not like "%/%"  -- no subtemplates

where page_namespace = 10          -- count templates
AND page_is_redirect = 0         -- no redirects
and exists ( -- file not already in "Media_missing_infobox_template" or subcategories
    select * 
    from categorylinks
    where 
      cl_from=page_id and 
      cl_to = "قوالب_معلومات_جغرافية"
   #and   cl_to = "قوالب_تنسيق_ويكيبيديا"
    limit 1 
  )
group by page_id

order by tot  desc, page_title
limit 500
SQL

Checking query status...
