USE fawiki_p;

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

FROM pagelinks INNER JOIN page ON pl_from = page_id

WHERE pl_namespace = 0

AND page_namespace = 0

AND pl_title LIKE 'فهرست_روستاهای%'

AND NOT EXISTS ( # red links

#AND EXISTS ( # blue links

    SELECT NULL

    FROM page

    WHERE page_namespace = 0

    AND page_title = pl_title

)

AND page_id IN (

  SELECT cl_from

  FROM categorylinks

  WHERE cl_to LIKE "روستاهای_%"

  )

ORDER BY (page_title);