مقالاتی که عنوانشان شامل وپ:گاهشماری

SQL

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;

SQL

Checking query status...