صفحة_توثيق_فرعية

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 
#         -- no redirects
#where page_title not like "%/%"  -- no subtemplates
where page_namespace = 10 
AND page_is_redirect = 0 #page_title like "بيانات_بلد%"
#and page_title like "%/ملعب"
and page_title like "%/شرح"
#and page_title not like "%تصنيف%"
AND not exists (
    SELECT *    FROM templatelinks
    WHERE tl_from=page_id     AND tl_namespace = 10
    AND tl_title ="صفحة_توثيق_فرعية" 	limit 1 
    #AND tl_title ="تبصرة_ملعب_قالب" 	limit 1 
)
group by page_id
#order by count(*)# > 1000
#order by tot desc, page_title
#limit 50
SQL

Checking query status...
