Likely partially disambiguated titles (1)

SQL

SELECT REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") AS Partial,
CONCAT('[[',GROUP_CONCAT(CASE WHEN page_title=REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") THEN NULL ELSE REPLACE(page_title,"_"," ") END ORDER BY page_title SEPARATOR ']]<br />[['),']]') AS Full
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 Partial
HAVING SUM(page_title = Partial)=1 AND COUNT(*)>1
ORDER BY Partial

AخA
 
SELECT REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") AS Partial,CONCAT('[[',GROUP_CONCAT(CASE WHEN page_title=REGEXP_REPLACE(page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)") THEN NULL ELSE REPLACE(page_title,"_"," ") END ORDER BY page_title SEPARATOR ']]<br />[['),']]') AS FullFROM 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 PartialHAVING SUM(page_title = Partial)=1 AND COUNT(*)>1ORDER BY Partial

SQL

Checking query status...