Fork of
Most used templates on bnwiki
by MdsShakil
This query is marked as a draft
This query has been published
by UOzurumba (WMF).
SQL
AخA
SELECT DISTINCT CONCAT("{{S|",page_title,"}}") AS template, COUNT(DISTINCT tl_from) AS counting, pr_type, pr_level
FROM page
JOIN templatelinks ON page_title = tl_title AND tl_namespace = 10 AND tl_from_namespace = 0
LEFT JOIN page_restrictions ON pr_page = page_id
WHERE page_namespace = 10 AND page_is_redirect = 0 /*AND pr_type != 'edit' AND pr_type != 'move' AND page_title NOT LIKE '%dane%'*/
GROUP BY page_title
HAVING counting < 50000
ORDER BY counting DESC, page_title;
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.