mp7.2 Pages with title like "A (B)" where page "A" does not exist (ignoring ZWNJ, space and non-space)

SQL

USE fawiki_p;
SELECT concat('# [[',page_title,']]'),COUNT(MID(page_title,1,LOCATE('(',page_title)-2))#,concat('# [[',MID(page_title,1,LOCATE('(',page_title)-2),']]')
FROM page AS p1
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title LIKE "%(%"
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
)
ORDER BY page_title;

SQL

Checking query status...