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

SQL

USE fawiki_p;
SELECT concat('# [[',p1.page_title,']]'),concat('# [[',p2.page_title,']]')
FROM page AS p1
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
#AND page_title NOT LIKE "(%"
AND p1.page_title NOT LIKE "%(%"
AND EXISTS (
  SELECT null
  FROM page AS p2
  WHERE p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  AND p2.page_title=MID(page_title,1,LOCATE('(',p1.page_title)-2)
)
#AND MID(page_title,1,LOCATE('(',page_title)-2) NOT IN (
#  SELECT page_title
#  FROM page
#)
ORDER BY p1.page_title
LIMIT 10;

SQL

Checking query status...