Unprotected Templates with more than 500k uses

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

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

SQL

#USE commonswiki_p;
SELECT concat("*[[Template:",page_title, "]]: "), num_transclusions 
FROM (
  SELECT page_namespace, page_title, (
      SELECT COUNT(*)  FROM linktarget
      WHERE lt_namespace = page_namespace AND lt_title = page_title
    ) AS num_transclusions
  FROM page
  WHERE page_namespace = 10
  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 > 500000  
) AS innerquery
ORDER BY num_transclusions DESC
LIMIT 10

SQL

Checking query status...