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

SQL

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

SQL

Checking query status...