Untitled query #75988

SQL

SELECT article.page_title
FROM page AS article
JOIN page AS talk ON article.page_title = talk.page_title
WHERE article.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 article.page_is_redirect = 1
AND article.page_namespace = 0
AND talk.page_namespace = 0
SQL

Checking query status...
