Untitled query #78999

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

SQL

SELECT
	page_namespace as namespace,
	page_title AS title, 
    COUNT(*) AS n 
FROM templatelinks
	INNER JOIN linktarget
    	ON tl_target_id = lt_id
    LEFT JOIN page
    	ON lt_title = page_title
        AND lt_namespace = page_namespace
	LEFT JOIN page_restrictions
    	ON page_id = pr_page
        AND pr_expiry IS NULL
WHERE
	pr_id IS NULL
GROUP BY
	page_title
HAVING
	n >= 100000
ORDER BY
	n DESC

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.

SQL

Checking query status...