Likely partially disambiguated titles (1)

SQL

SELECT   SUBSTRING_INDEX(page_title, '(', 1) AS basename, REGEXP_REPLACE(page_title, ".*?\\((\\w+).*", "\\1") AS qualifier,
CONCAT(basename, "(", qualifier, ")") AS PT, MIN(page_title) AS title1, MAX(page_title) AS title2, COUNT(*) AS N

FROM page
WHERE page_namespace=0 AND page_title LIKE "Ab%" AND page_title LIKE "Ab%(%)" AND page_is_redirect=0
GROUP BY basename, qualifier
HAVING SUM(page_title = PT)=1 AND N>1

​x
 
SELECT   SUBSTRING_INDEX(page_title, '(', 1) AS basename, REGEXP_REPLACE(page_title, ".*?\\((\\w+).*", "\\1") AS qualifier,CONCAT(basename, "(", qualifier, ")") AS PT, MIN(page_title) AS title1, MAX(page_title) AS title2, COUNT(*) AS N​FROM pageWHERE page_namespace=0 AND page_title LIKE "Ab%" AND page_title LIKE "Ab%(%)" AND page_is_redirect=0GROUP BY basename, qualifierHAVING SUM(page_title = PT)=1 AND N>1​

SQL

Checking query status...