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;