enwiki: Disambig-Class pages that aren't disambiguations

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 = "Disambig-Class_articles"
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)
AND "Set_index_article" NOT IN (SELECT tl_title FROM templatelinks WHERE templatelinks.cl_from = mainpage.page_id)

SQL

Checking query status...