Required DAB pages

SQL

USE fawiki_p;
SELECT CONCAT ('* [[',p.page_title,']]>'),REPLACE(REPLACE(MID(page_title,1,LOCATE('(',p.page_title)-2),'‌',''),'_','')
FROM page AS p
WHERE p.page_namespace=0
AND p.page_is_redirect=0
AND p.page_title NOT LIKE "(%"
AND p.page_title LIKE "%(%"
AND p.page_title  LIKE "%)"
AND p.page_title NOT LIKE "زمین‌لرزه%"
AND p.page_title NOT LIKE "فهرست_سیارک‌ها%"
AND p.page_title NOT LIKE "انتخابات%"
AND NOT p.page_title REGEXP '[A-Za-z]'
AND p.page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)
AND NOT (REPLACE(REPLACE(MID(p.page_title,1,LOCATE('(',p.page_title)-2),'‌',''),'_','') IN (
  SELECT REPLACE(REPLACE(page_title,'‌',''),'_','')
  FROM page
  WHERE page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation'
  )
)
         OR REPLACE(REPLACE(CONCAT(MID(p.page_title,1,LOCATE('(',p.page_title)-2),'_(ابهام‌زدایی)'),'‌',''),'_','') IN (
           SELECT REPLACE(REPLACE(page_title,'‌',''),'_','')
           FROM page
           WHERE page_id IN (
             SELECT pp_page
             FROM page_props
             WHERE pp_propname = 'disambiguation'
           )
           )
         )
/*AND concat(mid(p.page_title,1,locate('_(',p.page_title)),'(') IN (
  SELECT concat(mid(p2.page_title,1,locate('_(',p2.page_title)),'(')
  FROM page p2
  WHERE p2.page_namespace = 0
  AND p2.page_is_redirect = 0
  GROUP BY p2.page_title
  HAVING COUNT(mid(p2.page_title, 1, locate('_(', p2.page_title) - 1)) > 1
) */
ORDER BY p.page_title;
SQL

Checking query status...
