Untitled query #25219

SQL

#USE stop;
USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(page_title, '_', ' '), ']]')
FROM page #JOIN templatelinks ON tl_from = page_id AND tl_from_namespace = 14 and tl_namespace = 10 AND tl_title = 'Category_redirect'
WHERE page_namespace = 14
AND page_is_redirect = 0
AND ((page_title LIKE '%–%') OR (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...
