Finding articles in need of talk pages (enwiki)

SQL

SELECT p.page_title, concat(" [[", p.page_title, "]] "), concat(" [[Talk:", p.page_title, "]] ") FROM page AS p
WHERE 
      p.page_namespace = 0 AND
      p.page_is_redirect = 0 AND
      p.page_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 1) AND
      NOT p.page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title in ('dab', 'Dab', 
                                                                             'Disamb', 'disamb',
									     'Geodis', 'geodis',
									     'Geodab', 'geodab',
'hndis','Hndis',
'surname','Surname',
'wi','Wi',
'wt','Wt',
'Rfd-NPF',
'given_name', 'given-name-stub'
) OR
	tl_title like "Db-%" OR
	tl_title like "%isambig%" OR
    tl_title like "%common_name" OR    
    tl_title like "%given_name"  OR  
    tl_title like "%index_article"  OR  
    tl_title like "%_redirect"  OR  
    tl_title like "%index" 
)
LIMIT 100
SQL

Checking query status...
