Pages with obsolete font tags and other types of Lint errors

SQL

select CONCAT('[[', case when page_namespace = 5 then 'Wikipedia talk:'
						 when page_namespace = 4 then 'Wikipedia:'
                         when page_namespace = 3 then 'User talk:'
                         when page_namespace = 2 then ':User:'
						 when page_namespace = 1 then 'Talk:'
              	    end,
                 replace(page_title, '_', ' '), ']]') as 'Page title' -- Format as wikilink, replace _ with space
from page
join revision on rev_page = page_id -- link with revision table to filter specific user
join `comment` on comment_id = rev_comment_id -- link with comment table to filter edit summary. Escape comment keyword with `
join linter on linter_page = page_id -- link with linter table
where page_namespace in (1, 2, 3, 4, 5) -- Filter namespaces
and rev_timestamp >= '20230201' -- Edit was after 1 February 2023
and comment_text like '%Linter%' -- Edit summary has the word Linter
and rev_actor = (select actor_id
                 from actor
                 where actor_name = 'Jonesey95')
and linter_cat = 2 -- filter pages with obsolete html tag errors
and linter_params like '%"font"%' -- filter pages with font tag errors
group by page_id -- filter duplicate pages with multiple font tag errors
order by page_namespace asc, page_title asc; -- arrange by namespace and title in asceding order
SQL

Checking query status...
