Old articles that probably need talk pages (with left outer joins)

SQL

SELECT DISTINCT 
  CONCAT("[[", p.page_title, "]]") AS page_title,
  CONCAT("[[Talk:", p.page_title, "]]") AS talk_title,
   r.rev_timestamp AS time
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
    AND p.page_namespace = 0
  left outer join page_props on pp_page = p.page_id and pp_propname = "disambiguation"
  left outer join categorylinks as c1 on c1.cl_type = "page" and c1.cl_from = p.page_id and c1.cl_to = "All_set_index_articles"
  left outer join categorylinks as c2 on c2.cl_type = "page" and c2.cl_from = p.page_id and c2.cl_to = "Redirects_to_Wiktionary"
where 
  c1.cl_from is null 
  c2.cl_from is null 
  AND pp_page is null
  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_namespace = 0
  AND p.page_is_redirect = 0
  AND p2.page_title IS NULL
  AND r.rev_id = p.page_latest
  AND r.rev_timestamp < 20190000000000
  -- ORDER BY   r.rev_timestamp
  LIMIT
  200
SQL

Checking query status...
