Fully-protected templates by number of transclusions

SQL

WITH tt AS (SELECT page_title AS Template, COUNT(*) AS Transclusions
FROM page_restrictions
JOIN page ON page_id = pr_page AND page_namespace = 10 AND page_is_redirect = 0
JOIN linktarget ON lt_namespace = 10 AND lt_title = page_title
JOIN templatelinks ON tl_target_id = linktarget.lt_id
WHERE pr_type = 'edit' AND pr_level = 'sysop' /* AND pr_expiry = 'infinity' */
GROUP BY Template)

SELECT "1 Least" AS Type, Template, Transclusions FROM tt WHERE Transclusions = (SELECT MIN(Transclusions) FROM tt)
UNION SELECT "2 Most", Template, Transclusions FROM tt WHERE Transclusions = (SELECT MAX(Transclusions) FROM tt)
UNION SELECT "3 Median", "", MEDIAN(Transclusions) OVER () FROM tt
UNION SELECT "4 Average", "", SUM(Transclusions)/COUNT(*) FROM tt
UNION SELECT "5 All", Template, Transclusions FROM tt
ORDER BY Type, Template
SQL

Checking query status...
