Untitled query #12425

SQL

USE arwiki_p;
select DISTINCT concat("قالب:",page_title) as pagename, count(*)  as tot
from page 
join templatelinks on page_title = tl_title and tl_namespace = 10 

where page_namespace = 10          -- count templates
AND page_title not like "%/شرح"  -- no subtemplates
AND page_is_redirect = 0         -- no redirects
and exists (select * from categorylinks where  cl_from=page_id and cl_to = "قوالب_معلومات_جغرافية")
and page_id not in (select tl_from from templatelinks  where tl_title = 'معلومات_مدينة')
#and exists (select tl_from from templatelinks  where  tl_from=page_id and tl_title = 'معلومات_مدينة')

group by page_id

order by tot  desc, page_title
limit 50;
SQL

Checking query status...
