articles name - Quarry

SQL

SELECT CONCAT ('* [[',REPLACE(page_title,'_',' '),']]')
FROM page
WHERE page_namespace=0
AND page_is_redirect=0
AND page_title LIKE "%،%" # hyphen 22412 pages
#AND page_title LIKE "%–%" # n dash 1655 pages
#AND page_title LIKE "%—%" # m dash 2 pages
/*AND (
  page_title LIKE "مجله\_%"
  OR page_title LIKE "نشریه\_%"
  OR page_title LIKE "روزنامه\_%"
  OR page_title LIKE "هفته‌نامه\_%"
  OR page_title LIKE "ماهنامه\_%"
  OR page_title LIKE "فصلنامه\_%"
  OR page_title LIKE "سالنامه\_%"
  
  OR page_title LIKE "دوماهنامه\_%"
  OR page_title LIKE "دوهفته‌نامه\_%"
)

*/
ORDER BY page_title
Limit 1000;
SQL

Checking query status...
