Untitled query #67999

SQL

select a.page_title,b.page_title from page a 
join page b on a.page_namespace=0 and b.page_namespace=0 and b.page_title=REGEXP_REPLACE(a.page_title, "(.*?\\([^_\\W]+).*\\)", "\\1)")
LEFT JOIN categorylinks ON cl_from=a.page_id AND cl_type="page" AND cl_to IN ("All_disambiguation_pages", "All_set_index_articles")
LEFT JOIN linktarget on lt_namespace=0 and lt_title=a.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 a.page_title LIKE "%(%)" AND a.page_is_redirect=0 AND b.page_is_redirect=0 AND cl_from IS NULL AND pl_from IS NULL
SQL

Checking query status...
