اكثر القوالب استخداماً في تصنيف قوالب_Cite_doi

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_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 = "قوالب_Cite_doi"
  #   cl_to = "قوالب_تنسيق_ويكيبيديا"
    limit 1 
  )
  #and tot > 1
group by page_id
order by tot desc, page_title
limit 50;

SQL

Checking query status...