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

SQL

USE fawiki_p;
SELECT DISTINCT REPLACE(concat('# [[',page_title,']]'),'_',' '),MID(page_title,1,LOCATE('(',page_title)-2)
FROM page
WHERE page_namespace=0
AND page_is_redirect=0
AND page_title LIKE "%(%"
AND page_title NOT LIKE "(%"
AND page_title NOT LIKE "%(ابهام‌زدایی)"
AND page_title NOT LIKE "%I%"
AND page_title NOT LIKE "%V%"
AND page_title NOT LIKE "زمین‌لرزه%"
AND page_title NOT LIKE "انتخابات%"
AND MID(page_title,1,LOCATE('(',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 EXISTS (
  SELECT null
  FROM categorylinks
  WHERE cl_from=page_id
  AND cl_to LIKE "کشتی‌های%"
)
#AND page_title NOT LIKE "زیردریایی%"

ORDER BY page_title
#LIMIT 100
;

SQL

Checking query status...