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 "C%" AND page_title NOT LIKE "%(season_%" AND page_title NOT LIKE "%(series_%"
AND NOT EXISTS (SELECT 1 FROM page Pb, pagelinks WHERE Pb.page_namespace = 0 AND Pb.page_title = SUBSTRING_INDEX(page_title, "_(", 1)
                AND pl_from = Pb.page_id AND pl_namespace = 0 AND pl_title = Pq.page_title)
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...