Untitled query #67999

SQL

SELECT REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") AS Partial,
CONCAT('[[',GROUP_CONCAT(CASE WHEN page_title=REGEXP_REPLACE(page_title, "(.*?\\().*?([^_\\W]+\\))", "\\1\\2") THEN NULL ELSE REPLACE(page_title,"_"," ") END ORDER BY page_title SEPARATOR ']]<br />[['),']]') AS Full
FROM page
where not exists (select 1 from categorylinks where cl_from=page_id AND cl_type="page" AND cl_to IN ("All_disambiguation_pages", "All_set_index_articles"))
and not exists (select 1 from pagelinks join linktarget on lt_id=pl_target_id where lt_namespace=0 and lt_title=page_title and 
                (pl_from=40722977 /* Wikipedia:Partially disambiguated page names */ or pl_from=76232465 /* False positives */) 
)
and page_namespace=0 AND page_title LIKE "%(%)" AND page_is_redirect=0
GROUP BY Partial
HAVING SUM(page_title = Partial)=1 AND COUNT(*)>1
ORDER BY Partial
SQL

Checking query status...
