Articles that probably need talk pages

SQL

SELECT  CONCAT("[[", p.page_title, "]]") AS page_title,   CONCAT("[[", lt.lt_title, "]]") AS template 
FROM revision AS r, templatelinks AS tl, linktarget AS lt, page AS p
LEFT OUTER JOIN page AS p2
  ON p2.page_title = p.page_title AND p2.page_namespace = 1
WHERE
  p2.page_title IS NULL
  AND p.page_namespace = 0
  AND p.page_is_redirect = 0
  
  AND tl.tl_from = p.page_id
  AND tl.tl_from_namespace = p.page_namespace
  AND tl.tl_target_id = lt.lt_id
  AND NOT p.page_id IN ( SELECT tl_from FROM templatelinks, linktarget
                                WHERE templatelinks.tl_target_id = linktarget.lt_id 
                                  AND templatelinks.tl_from_namespace = 0
                                  AND linktarget.lt_namespace = 10
                                  AND linktarget.lt_title  in (
                                   'disambiguation', 'Disambiguation', 
                                   'given name', 'Given name', 
                                   'surname', 'Surname',
                                   'geodis', 'Geodis', 
                                   'sia', 'Sia'
                                  )
                        )
  
  AND r.rev_timestamp < 20190000000000
LIMIT 100
SQL

Checking query status...
