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 page_namespace, page_title, count(*) as num_transclusions
#    (
#      SELECT COUNT(*)  FROM linktarget
#      WHERE lt_namespace = page_namespace AND lt_title = page_title
#    ) AS num_transclusions
FROM page
join linktarget WHERE lt_namespace = page_namespace AND lt_title = page_title
WHERE page_namespace in (10, 828)
#AND NOT EXISTS ( 
#    SELECT *  FROM page_restrictions  
#    WHERE page_id = pr_page AND pr_type = 'edit' AND pr_level = 'sysop' AND pr_expiry = 'infinity'
#  )
#HAVING num_transclusions > 1000  
group by page_id
ORDER BY num_transclusions DESC
LIMIT 10

SQL

Checking query status...