select CONCAT('# [[', case when page_namespace = 2303 then 'Gadget definition talk:'

                           when page_namespace = 2302 then 'Gadget definition:'

                           when page_namespace = 2301 then 'Gadget talk:'

                           when page_namespace = 2300 then 'Gadget:'

                           when page_namespace = 829 then 'Module talk:'

                           when page_namespace = 828 then 'Module:'

                           when page_namespace = 710 then 'TimedText:'

                           when page_namespace = 711 then 'TimedText talk:'

                           when page_namespace = 119 then 'Draft talk:'

                           when page_namespace = 118 then 'Draft:'

                           when page_namespace = 101 then 'Portal talk:'

                           when page_namespace = 100 then 'Portal:'

                           when page_namespace = 15 then 'Category talk:'

                           when page_namespace = 14 then 'Category:'

                           when page_namespace = 13 then 'Help talk:'

                           when page_namespace = 12 then 'Help:'

                           when page_namespace = 11 then 'Template talk:'

                           when page_namespace = 10 then 'Template:'

                           when page_namespace = 9 then 'MediaWiki talk:'

                           when page_namespace = 8 then 'MediaWiki:'

                           when page_namespace = 7 then 'File talk:'

                           when page_namespace = 6 then 'File:'

                           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:'

                           when page_namespace = 0 then ''

                      end,

       replace(page_title, '_', ' '), ']]') as title -- Format as wikilink, replace _ with space

from linter

join page on page_id = linter_page

-- where page_namespace=3 -- filter by namespace

and linter_cat=2 -- filter obsolete html tag errors

and linter_params like '%"font"%' -- filter font tag errors

group by page_id -- filter duplicate pages with multiple font tag errors

having count(*) = 1 -- filter by font tag error count

order by title asc; -- arrange in ascending order