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

SQL

SELECT SUBSTRING_INDEX(Pa.page_title, "_(", 1) AS basename, COUNT(*) pages, MIN(Pa.page_title) example1, MAX(Pa.page_title) example2
FROM page Pa
WHERE Pa.page_namespace=0 AND Pa.page_title LIKE "A%_(%"
AND (page_is_redirect = 0 OR page_title NOT LIKE "%_(%" OR page_title LIKE "%_(disambiguation)")
GROUP BY basename
HAVING COUNT(*) > 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...