Untitled query #87637

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 linktarget on lt_namespace=0 and lt_title=page_title
LEFT JOIN pagelinks ON (pl_from=40722977 /* Wikipedia:Partially disambiguated page names */ or pl_from=76232465 /* False positives */) AND pl_target_id=lt_id
WHERE page_namespace=0 AND page_title LIKE "%(%)" 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
SQL

Checking query status...
