USE fawiki_p;

SELECT concat('# [[',REPLACE(Source.page_title,'_',' '),']]')

FROM page AS Source JOIN redirect ON page_id = rd_from

WHERE Source.page_title NOT LIKE "%(%"

#AND (Source.page_title LIKE "معتمد"

#OR Source.page_title LIKE "دلم_برات_تنگ_شده")

AND Source.page_namespace = 0

AND Source.page_is_redirect = 1

AND Source.page_title IN (

  SELECT MID(Target.page_title,1,LOCATE('(',Target.page_title)-2)

  FROM page AS Target

  WHERE rd_title = Target.page_title

  AND Target.page_id NOT IN (

    SELECT pp_page

    FROM page_props

    WHERE pp_propname = 'disambiguation'

    )

  AND Source.page_title NOT IN (

    SELECT MID(Second.page_title,1,LOCATE('(',Second.page_title)-2)

    FROM page AS Second

    WHERE Second.page_namespace = 0

    AND Second.page_is_redirect = 0

    AND Target.page_title <> Second.page_title

    )

  )

;