USE fawiki_p;

SELECT CONCAT ('# [[',page_title,']]')

FROM page

WHERE page_namespace = 0

AND page_is_redirect = 0

AND (page_title LIKE "%میلادی)" or page_title LIKE "%شمسی)" or page_title LIKE "%قمری)" or page_title LIKE "%خورشیدی)" or page_title LIKE "%هجری)" )

AND (page_title NOT LIKE "%(میلادی)" and page_title NOT LIKE "%(شمسی)" and page_title NOT LIKE "%(قمری)" and page_title NOT LIKE "%(خورشیدی)" and page_title NOT LIKE "%(هجری)" )

​

ORDER BY page_title;