Required DAB pages

SQL

USE fawiki_p;
SELECT CONCAT ('# [[',page_title,']]')
FROM page AS p1
WHERE p1.page_namespace=0
AND p1.page_is_redirect=0
AND p1.page_title NOT LIKE "(%"
AND p1.page_title LIKE "%(%"
AND p1.page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)
AND NOT (MID(p1.page_title,1,LOCATE('(',p1.page_title)-2) IN (
  SELECT page_title
  FROM page
  WHERE page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation'
  )
)
         OR CONCAT(MID(p1.page_title,1,LOCATE('(',p1.page_title)-2),'_(ابهام‌زدایی)') IN (
           SELECT page_title
           FROM page
           WHERE page_id IN (
             SELECT pp_page
             FROM page_props
             WHERE pp_propname = 'disambiguation'
           )
           )
         )
AND EXISTS (
  SELECT null
  FROM page AS p2
  WHERE p2.page_title LIKE concat(mid(p1.page_title, 1, locate('_(', p1.page_title)),'(%')
  AND p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  HAVING COUNT(*) > 1
)
ORDER BY p1.page_title
LIMIT 100;
SQL

Checking query status...
