Untitled query #67999

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"
WHERE page_namespace=0 AND page_title LIKE "%(%)" AND page_is_redirect=0 AND cl_from IS NULL
GROUP BY Partial
HAVING SUM(page_title = Partial)=1 AND COUNT(*)>1
ORDER BY Partial
SQL

Checking query status...
