Non-protected templates over 200 transclusions

Fork of Non-protected templates between 200 and 500 transclusions by SQL

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

SQL

SELECT Concat("[[template:", tl_title, "]]"), 
       Count(*),  
       Concat("[https://en.wikipedia.org/w/index.php?title=template:", tl_title, 
       "&action=unprotect Change!]") 
FROM   page 
       JOIN templatelinks 
         ON page_title = tl_title 
            AND page_namespace = tl_namespace 
       LEFT JOIN page_restrictions 
              ON pr_page = page_id 
                 AND ( pr_level = 'sysop' 
                        OR pr_level = 'templateeditor' 
                        OR pr_level = 'extendedconfirmed' 
                        OR pr_level = 'autoconfirmed' ) 
                 AND pr_type = 'edit' 
WHERE  tl_namespace = 10 
       AND pr_page IS NULL 
GROUP  BY tl_title 
HAVING Count(*) > 200 
       AND Count(*) < 500 
ORDER  BY Count(*) DESC;

SQL

Checking query status...