mp7.2 Pages with title like "A (B)" where page "A" does not exist

SQL

USE fawiki_p;
SELECT concat('# [[',p1.page_title,']]')#,concat('# [[',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 page_title NOT LIKE "(%"
AND p1.page_title NOT LIKE "%(ابهام‌زدایی)%"
AND MID(p1.page_title,1,LOCATE('(',p1.page_title)-2) NOT IN (
  SELECT page_title
  FROM page
#  WHERE page_title NOT LIKE "%(%"
  AND page_namespace = 0
#  AND page_is_redirect = 0
)
AND MID(p1.page_title,1,LOCATE('(',p1.page_title)-2) NOT IN (
  SELECT MID(p2.page_title,1,LOCATE('(',p2.page_title)-2)
  FROM page AS p2
#  WHERE p2.page_title LIKE "%(%"
  AND p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  AND p2.page_title NOT LIKE p1.page_title
)
LIMIT 200;

SQL

Checking query status...