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 p.page_title = "Verseilles"

  
  AND r.rev_timestamp < 20190000000000
LIMIT 100

SQL

Checking query status...