SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.