USE fawiki_p;

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

FROM page

WHERE page_namespace=0

AND page_is_redirect=0

AND page_title LIKE "%(%"

AND page_title NOT LIKE "(%"

AND page_title LIKE "%)"

AND page_title NOT LIKE "%(ابهام•زدایی)"

AND page_title NOT LIKE "%I%"

AND page_title NOT LIKE "%V%"

AND page_title NOT LIKE "زمین•لرزه%"

AND page_title NOT LIKE "انتخابات%"

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

  SELECT page_title

  FROM page

  WHERE page_namespace = 0

  AND page_title NOT LIKE "%(%"

#  AND page_is_redirect = 0

  )

AND NOT EXISTS (

  SELECT null

  FROM categorylinks

  WHERE cl_from=page_id

  AND cl_to LIKE "مقاله•های_خرد_کشتی_یا_قایق"

  )

ORDER BY page_title;