Special:LinterErrors in Japanese Wikipedia

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

use jawiki_p;
select
	case linter_cat
		when 1 then "Fostered content"
		when 2 then "廃止されたHTMLタグ"
		when 3 then "Bogus file options"
		when 4 then "終了タグの不足"
		when 5 then "Stripped tags"
		when 6 then "自己終了タグ"
		when 7 then "削除する必要があるTableタグ"
		when 8 then "Misnested tags"
		when 9 then "Paragraph wrapping bug workaround"
		when 10 then "Tidy whitespace bug"
		when 11 then "複数コロンのウィキ間リンク"
		when 12 then "HTML5とHTML4のレンダリング差異によって誤った入れ子構造となっているタグ"
		when 13 then "Tidy bug affecting font tags wrapping links"
		when 14 then "複数の閉じられていない書式設定タグ"
		when 15 then "閉じられていない見出しの引用符"
		when 16 then "Multiline table in list"
		when 17 then "Miscellaneous Tidy replacement issues"
	end as "エラー名",
    case linter_cat
		when 1 then "medium"
		when 2 then "low"
		when 3 then "medium"
		when 4 then "low"
		when 5 then "low"
		when 8 then "medium"
		when 11 then "medium"
		else "high"
	end as "優先度",
    count(*)
from linter
group by linter_cat
order by
	case linter_cat
		when 1 then 12
		when 2 then 16
		when 3 then 11
		when 4 then 15
		when 5 then 17
		when 6 then 7
		when 7 then 1
		when 8 then 13
		when 9 then 6
		when 10 then 9
		when 11 then 14
		when 12 then 2
		when 13 then 8
		when 14 then 5
		when 15 then 10
		when 16 then 4
		when 17 then 3
    end;

select
	case linter_cat
		when 1 then "Fostered content"
		when 2 then "廃止されたHTMLタグ"
		when 3 then "Bogus file options"
		when 4 then "終了タグの不足"
		when 5 then "Stripped tags"
		when 6 then "自己終了タグ"
		when 7 then "削除する必要があるTableタグ"
		when 8 then "Misnested tags"
		when 9 then "Paragraph wrapping bug workaround"
		when 10 then "Tidy whitespace bug"
		when 11 then "複数コロンのウィキ間リンク"
		when 12 then "HTML5とHTML4のレンダリング差異によって誤った入れ子構造となっているタグ"
		when 13 then "Tidy bug affecting font tags wrapping links"
		when 14 then "複数の閉じられていない書式設定タグ"
		when 15 then "閉じられていない見出しの引用符"
		when 16 then "Multiline table in list"
		when 17 then "Miscellaneous Tidy replacement issues"
	end as "エラー名",
    case linter_cat
		when 1 then "medium"
		when 2 then "low"
		when 3 then "medium"
		when 4 then "low"
		when 5 then "low"
		when 8 then "medium"
		when 11 then "medium"
		else "high"
	end as "優先度",
    count(*)
from linter
inner join page on linter_page = page_id and page_namespace = 0
group by linter_cat
order by
	case linter_cat
		when 1 then 12
		when 2 then 16
		when 3 then 11
		when 4 then 15
		when 5 then 17
		when 6 then 7
		when 7 then 1
		when 8 then 13
		when 9 then 6
		when 10 then 9
		when 11 then 14
		when 12 then 2
		when 13 then 8
		when 14 then 5
		when 15 then 10
		when 16 then 4
		when 17 then 3
    end;

select current_timestamp;
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...
