中国語版は意外と頑張ってます

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
SQL

Checking query status...
