SQL
AخA
use arwiki_p;
SELECT
tl.tl_title,
COUNT(*) usages
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 10 -- Optional namespace check.
AND cl.cl_from = p.page_id
AND cl.cl_to = "قوالب_Cite_doi" -- Insert your category here.
JOIN templatelinks tl
ON tl.tl_from = p.page_id
WHERE tl.tl_namespace = 10
GROUP BY tl.tl_title
ORDER BY usages DESC
LIMIT 100;
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.