Untitled query #75988

SQL

SELECT page_title
FROM page
WHERE page_id NOT IN (
  SELECT article.page_id
  FROM page AS article
  LEFT JOIN page AS talk ON article.page_title = talk.page_title
  JOIN pagelinks AS articlelinks ON article.page_id = articlelinks.pl_from 
  JOIN pagelinks AS talklinks ON article.page_id = talklinks.pl_from
  WHERE article.page_is_redirect = 1
  AND talk.page_is_redirect = 1
  AND article.page_namespace = 0 
  AND talk.page_namespace = 1
  AND articlelinks.pl_namespace = 0
  AND talklinks.pl_namespace = 1
  AND articlelinks.pl_title = talklinks.pl_title
  AND talk.page_title IS NOT NULL)
AND page_is_redirect = 1
AND page_namespace = 0
SQL

Checking query status...
