Untitled query #25219

SQL

#cat page names containing n-dash '–' or M-dash '—'
USE commonswiki_p;
(SELECT CONCAT('# [[:Category:', REPLACE(page_title, '_', ' '), ']]') FROM page
WHERE page_namespace = 14
AND page_is_redirect = 0
AND page_title LIKE '%–%'
AND page_title NOT LIKE '%/%'
AND page_title NOT REGEXP '[0-9] *– *[0-9]'
AND NOT EXISTS (SELECT 1 FROM templatelinks WHERE tl_from = page_id AND tl_from_namespace = 14 and tl_namespace = 10 AND tl_title = 'Category_redirect')
) UNION
(SELECT CONCAT('# [[:Category:', REPLACE(page_title, '_', ' '), ']]') FROM page
WHERE page_namespace = 14
AND page_is_redirect = 0
AND page_title LIKE '%—%'
AND page_title NOT LIKE '%/%'
AND page_title NOT REGEXP '[0-9] *— *[0-9]'
AND NOT EXISTS (SELECT 1 FROM templatelinks WHERE tl_from = page_id AND tl_from_namespace = 14 and tl_namespace = 10 AND tl_title = 'Category_redirect')
)
LIMIT 5000;
SQL

Checking query status...
