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 linter_template, COUNT( * ) AS pages_using_template, SUM( linter_errors ) AS total_errors, (SUM(linter_errors)/COUNT(*) * 100) AS pct_errors
FROM (
  SELECT linter_template, COUNT( linter_page ) AS linter_errors
  FROM linter
  WHERE linter_template != ''
  	AND linter_template != 'multi-part-template-block'
  GROUP BY linter_template, linter_page
) subset
GROUP BY linter_template
ORDER BY total_errors 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...