Untitled query #49611

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
# AND "All_disambiguation_pages" NOT IN (SELECT cl_to FROM categorylinks WHERE cl_from = mainpage.page_id)
SQL

Checking query status...
