Untitled query #70731

This query is marked as a draft This query has been published by SBailey (WMF).

Query to report the number linter errors associated with a template - number of pages referencing it with an error and total errors associated with the template

SQL

SELECT subject.linter_page, subject.linter_template, COUNT( subject.count ) AS pages_using_template
FROM (
  SELECT linter_page, linter_template, COUNT( linter_page ) AS count
  FROM linter
  WHERE linter_template != ''
  	AND linter_template != 'multi-part-template-block'
  GROUP BY linter_template, linter_page
) subject
GROUP BY subject.linter_template
ORDER BY pages_using_template DESC
LIMIT 50
;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...