Articles by lint errors except for Obsolete HTML tags

SQL

select page_title
, count(*) as page_count
, sum(case when linter_params = '{"name":"center"}' then 1 end) as tag_center
, sum(case when linter_params = '{"name":"small"}' then 1 end) as tag_small
, sum(case when linter_params = '{"name":"span"}' then 1 end) as tag_span
, sum(case when linter_params = '{"name":"b"}' then 1 end) as tag_b
, sum(case when linter_params = '{"name":"i"}' then 1 end) as tag_i
from linter
join page on page.page_id = linter.linter_page
where page.page_namespace=0 and linter_cat != 2
group by page.page_id
order by count(*) desc, page_title asc
limit 100;

SQL

Checking query status...