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
and page_title not like '%/%'
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
                where tl_from_namespace = 1) -- filter Talk namespace
limit 1;

SQL

Checking query status...