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 '%–%') OR (page_title LIKE '%—%'))
AND page_title NOT LIKE '%/%' #exclude subpages
AND page_title NOT REGEXP '[0-9]{4}\ *[–—]\ *[0-9]{4}' #exclude years
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...
