mp7.1 Pages with title like "A" redirecting to page "A (B)" (JOIN), and no other A(C) exists (EXISTS)

SQL

USE fawiki_p;
SELECT concat('# [[',REPLACE(Source.page_title,'_',' '),']]')
FROM page AS Source JOIN redirect ON page_id = rd_from
WHERE Source.page_title NOT LIKE "%(%"
AND Source.page_namespace = 0
AND Source.page_is_redirect = 1
AND Source.page_title IN (
  SELECT MID(Target.page_title,1,LOCATE('(',Target.page_title)-2)
  FROM page AS Target
  WHERE rd_title = Target.page_title
  AND Target.page_id NOT IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation'
    )
  AND Source.page_title IN (
    SELECT MID(Target.page_title,1,LOCATE('(',Target.page_title)-2)
    FROM page AS Second
    WHERE Target.page_title <> Second.page_title
    )
  )
  
;

SQL

Checking query status...