قوالب معطيات

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 
AND page_is_redirect = 1         -- no redirects
#where page_title not like "%/%"  -- no subtemplates
where page_namespace = 10 #page_title like "بيانات_بلد%"
and page_title like "معطيات%"

#or page_title  like "معطيات%"
#and page_title not like "%تصنيف%"

group by page_id
order by count(*)# > 1000
#order by tot desc, page_title
#limit 500
SQL

Checking query status...
