Pages with many strike tags

SQL

select page_namespace, page_title, count(*) as page_count
from linter
join page p1 on page_id = linter_page
where linter_cat = 2 -- obsolete tags
and page_namespace not in (0) -- filter by namespace
and exists (select 1 -- select strike tag errors
                from linter
                join page p3 on page_id = linter_page
                where p1.page_id = p3.page_id
                and linter_params like '%"strike"%')
group by page_id -- filter duplicate pages with multiple errors
-- having count(*) > 19 -- filter by error count
order by count(*) desc, page_namespace asc, page_title asc -- arrange by most number of errors, namespace and title in ascending order
limit 1000;
SQL

Checking query status...
