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 lt_title  in (
                                   'Disambiguation'
                                )
                        )
       
  
  AND r.rev_timestamp < 20190000000000
LIMIT 100
SQL

Checking query status...
