Untitled query #78999

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

SQL

SELECT 
	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
	LEFT JOIN page_restrictions
    	ON page_id = pr_page
WHERE
	pr_id IS NULL
    AND pr_expiry IS NULL
GROUP BY
	tl_target_id
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...