enwiki: Redirect-class pages that aren't redirects

SQL

use enwiki_p;

SELECT DISTINCT mainpage.page_title, innercat.cl_to
FROM categorylinks outercat
INNER JOIN page outerpage ON outerpage.page_id = outercat.cl_from
INNER JOIN categorylinks innercat ON outerpage.page_title = innercat.cl_to
INNER JOIN page talkpage ON talkpage.page_id = innercat.cl_from
INNER JOIN page mainpage ON mainpage.page_title = talkpage.page_title
WHERE outercat.cl_to = "Redirect-Class_articles"
AND talkpage.page_namespace = 1
AND mainpage.page_namespace = 0
AND mainpage.page_is_redirect = 0
AND mainpage.page_id NOT IN (
  SELECT innersoftcat.cl_from
  FROM categorylinks outersoftcat
  INNER JOIN page softcatpage ON softcatpage.page_id = outersoftcat.cl_from
  INNER JOIN categorylinks innersoftcat ON innersoftcat.cl_to = softcatpage.page_title
  WHERE outersoftcat.cl_to = "Wikipedia_interwiki_soft_redirects"
  AND softcatpage.page_namespace = 14
)
# AND "All_disambiguation_pages" NOT IN (SELECT cl_to FROM categorylinks WHERE cl_from = mainpage.page_id)
SQL

Checking query status...
