enwiki: Redirect-class pages that aren't redirects

SQL

SELECT 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 innercat.cl_to LIKE "Redirect-Class%"
and talkpage.page_namespace = 1
AND mainpage.page_namespace = 0
AND mainpage.page_is_redirect = 0

SQL

Checking query status...