Unprotected Templates with most transclusions

Fork of Unprotected Templates with more than 500k uses by Jarekt

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

SQL

SELECT lt_namespace, lt_title, num_transclusions
FROM (
	SELECT lt_namespace, lt_title, COUNT(*) as num_transclusions
	FROM templatelinks 
	JOIN linktarget ON tl_target_id = lt_id
	WHERE lt_namespace  in (10, 828)
	GROUP BY tl_target_id
	HAVING num_transclusions > 1000000
) sub

join page on lt_namespace = page_namespace AND lt_title = page_title
where NOT EXISTS ( 
    SELECT *  FROM page_restrictions  
    WHERE page_id = pr_page AND pr_type = 'edit' AND pr_level = 'sysop' AND pr_expiry = 'infinity'
 )

ORDER BY num_transclusions DESC
LIMIT 100

SQL

Checking query status...