Old 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
WHERE
  tl.tl_from = p.page_id
  AND tl.tl_from_namespace = p.page_namespace
  AND tl.tl_target_id = lt.lt_id
  AND p2.page_namespace = 1
  AND p2.page_title IS NULL
  AND p.page_namespace = 0
  AND p.page_is_redirect = 0
  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',
        'Given name',
        'Surname',
        'Geodis',
        'Sia'
      )
  )
  AND r.rev_timestamp < 20190000000000
LIMIT
  200
SQL

Checking query status...
