Likely partially disambiguated titles (1)

SQL

SELECT REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") AS PT,
 GROUP_CONCAT(CASE WHEN page_title=REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") THEN NULL ELSE REPLACE(page_title,"_"," ") END ORDER BY page_title SEPARATOR']] | [[') 
FROM page
LEFT JOIN categorylinks ON cl_from=page_id AND cl_type="page" AND cl_to="All_disambiguation_pages"
LEFT JOIN pagelinks ON pl_from=40722977 /* Wikipedia:Partially disambiguated page names */ AND pl_namespace=0 AND pl_title=page_title
WHERE page_namespace=0 AND page_title LIKE "A%(%)" AND page_is_redirect=0 AND cl_from IS NULL AND pl_from IS NULL
GROUP BY PT
HAVING SUM(page_title = PT)=1 AND COUNT(*)>1

​x
 
SELECT REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") AS PT, GROUP_CONCAT(CASE WHEN page_title=REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") THEN NULL ELSE REPLACE(page_title,"_"," ") END ORDER BY page_title SEPARATOR']] | [[') FROM pageLEFT JOIN categorylinks ON cl_from=page_id AND cl_type="page" AND cl_to="All_disambiguation_pages"LEFT JOIN pagelinks ON pl_from=40722977 /* Wikipedia:Partially disambiguated page names */ AND pl_namespace=0 AND pl_title=page_titleWHERE page_namespace=0 AND page_title LIKE "A%(%)" AND page_is_redirect=0 AND cl_from IS NULL AND pl_from IS NULLGROUP BY PTHAVING SUM(page_title = PT)=1 AND COUNT(*)>1​

SQL

Checking query status...