/// - Quarry

SQL

USE fawiki_p;
SELECT concat('# [[',p1.page_title,']]'),MID(p1.page_title,1,LOCATE('(',p1.page_title)-2)
FROM page AS p1
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND p1.page_title LIKE "%(%"
AND p1.page_title NOT LIKE "%(ابهام‌زدایی)%"
HAVING COUNT(p1.page_title) > 1
AND EXISTS (
  SELECT null
  FROM page AS p2
  WHERE p2.page_title NOT LIKE "%(%"
  AND p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  AND MID(p1.page_title,1,LOCATE('(',p1.page_title)-2) LIKE p2.page_title
)
#LIMIT 10
;
SQL

Checking query status...
