USE fawiki_p;

SELECT CONCAT ('# [[',REPLACE(MID(Target.page_title,1,LOCATE('(',Target.page_title)-2),'_',' '),']] [[',REPLACE(Target.page_title,'_',' '),']]')

FROM page AS Target

WHERE Target.page_namespace = 0

AND Target.page_is_redirect = 0

AND Target.page_title LIKE "%(سرده)%"

AND Target.page_id NOT IN (

  SELECT pp_page

  FROM page_props

  WHERE pp_propname = 'disambiguation'

  )

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

  SELECT Source.page_title

  FROM page AS Source

  WHERE Source.page_namespace = 0

  AND Source.page_is_redirect = 1

  AND Source.page_id IN (

    SELECT rd_from

    FROM redirect

    WHERE rd_title=Target.page_title

    )

  )

ORDER BY Target.page_title;