قوالب معطيات

SQL

USE arwiki_p;
select DISTINCT concat("[[template:",page_title,']]') as pagename, count(*) as tot
from page 
join templatelinks on page_title = tl_title and tl_namespace = 10 
where page_title not like "%/%"  -- no subtemplates
/*and page_title not like "%معطيات%"  
and page_title not like "%بيانات%"
and page_title not like "%ويكي%"
and page_title not like "%مرجع%"
and page_title not like "%خريطة%"*/
#and page_title not like "%تصنيف%"
and (page_title like "Infobox%"
or page_title like "ص.م%"  
or page_title like "صندوق_معلومات_%"  
or page_title like "%معلومات%"  )
#where page_title  like "%ص.م%"  -- no subtemplates
AND page_namespace = 10          -- count templates
AND page_is_redirect = 0         -- no redirects
/*AND not exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from=page_id 
    AND tl_namespace = 10
    AND tl_title ="بذرة" -- find files that do not transclude a [[template:TemplateBox]]
	limit 1 
)*/
/*and exists ( -- file not already in "Media_missing_infobox_template" or subcategories
    select * 
    from categorylinks
    where 
      cl_from=page_id and 
      cl_to = "قوالب_معلومات_أشخاص"
     # cl_to = "قوالب_معلومات_مباني"
   #and   cl_to = "قوالب_تنسيق_ويكيبيديا"
    limit 1 
  )*/
GROUP BY page_id 
#HAVING COUNT(tot) > 20000
order by tot desc
#order by tot desc, page_title
limit 500
SQL

Checking query status...
