Pages with any Lint errors except font tags

This query is marked as a draft This query has been published by ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ.

SQL

select CONCAT('[[Talk:', page_title, ']]') as 'Talk page' -- format as wikilink so that it can be read by AWB 
from page
join templatelinks on page_id = tl_from -- link with templatelinks table
join linktarget on tl_target_id = lt_id -- link with linktarget table
where page_title not like '%/%'
and tl_from_namespace = 1 -- filter Talk namespace
-- and page_is_redirect = 0 -- filter out redirects
and not exists (select 1
  				where lt_title regexp '.*WikiProject [A-Za-z]+' -- name of the template being transcluded
                and lt_namespace = 10) -- filter template namespace
limit 100;

SQL

Checking query status...