Qualified titles with shared base name lacking a (disambiguation) page

SQL

SELECT SUBSTRING_INDEX(page_title, "_(", 1) AS basename,
 SUM(1 - page_is_redirect) pages, GROUP_CONCAT(page_title ORDER BY page_title SEPARATOR'|') AS titles
FROM page Pq
WHERE page_namespace = 0 AND page_title LIKE "Ca%" AND page_title NOT REGEXP "_\((season|series|\d{4}\))"
AND (NOT EXISTS (SELECT 1 FROM page Pb
                 JOIN pagelinks ON pl_from = Pb.page_id AND pl_namespace = 0 AND pl_title = Pq.page_title
                 WHERE Pb.page_namespace = 0 AND Pb.page_title = SUBSTRING_INDEX(Pq.page_title, "_(", 1) AND Pb.page_title != Pq.page_title)
 AND NOT EXISTS (SELECT 1 FROM page Pb
                 JOIN pagelinks ON pl_from = Pb.page_id AND pl_namespace = 0
                 JOIN page Pr ON Pr.page_namespace = 0 AND Pr.page_title = pl_title
                 JOIN redirect ON rd_from = Pr.page_id  AND rd_namespace = 0 AND rd_title = Pq.page_title
                 WHERE Pb.page_namespace = 0 AND Pb.page_title = SUBSTRING_INDEX(Pq.page_title, "_(", 1) AND Pb.page_title != Pq.page_title)
 OR page_title LIKE "%_(disambiguation)")
GROUP BY basename
HAVING pages >= 5
AND MAX(CASE WHEN page_title LIKE "%_(disambiguation)" THEN 1 ELSE 0 END) = 0
AND MAX(CASE WHEN page_title = basename AND page_is_redirect = 1 THEN 1 ELSE 0 END) = 0
ORDER BY basename
SQL

Checking query status...
