USE elwiki_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_title NOT LIKE "(%"

#AND Target.page_title NOT LIKE "Episodi%"

AND Target.page_id NOT IN (

  SELECT pp_page

  FROM page_props

  WHERE pp_propname = 'αποσαφήνιση'

  )

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

  SELECT Source.page_title

  FROM page AS Source

  WHERE Source.page_namespace = 0

  )

ORDER BY Target.page_title

LIMIT 2999;