Finding articles in need of talk pages (enwiki)

SQL

SELECT p.page_title, concat(" [[", 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',
'soft_redirect','Soft_redirect',
'wiktionary redirect','Wiktionary redirect',                                                                             
'wi','Wi',
'wt','Wt',
) 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 "%index" 
)
LIMIT 100
SQL

Checking query status...
