Unprotected templates with 5000+ backlinks - Quarry

This query is marked as a draft This query has been published by WhitePhosphorus.

SQL

USE zhwiki_p;
SELECT page_title, COUNT(*) AS c FROM page
JOIN templatelinks ON tl_title = page_title
/*LEFT JOIN page_restrictions ON pr_page = page_id AND pr_type = 'edit'*/
WHERE page_namespace = 10# AND pr_level IS NULL
GROUP BY page_title
ORDER BY c DESC
LIMIT 500

AخA
 
USE zhwiki_p;SELECT page_title, COUNT(*) AS c FROM pageJOIN templatelinks ON tl_title = page_title/*LEFT JOIN page_restrictions ON pr_page = page_id AND pr_type = 'edit'*/WHERE page_namespace = 10# AND pr_level IS NULLGROUP BY page_titleORDER BY c DESCLIMIT 500

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...