Mainspace page titles containing non-ASCII hyphen (U+2010)

SQL

select ROW_NUMBER() OVER(order by page_title) num, -- get row number
       CONCAT('[[', replace(page_title, '_', ' '), ']]') as 'Page title', -- Format as wikilink, replace _ with space
       case when page_is_redirect then 'Yes' else 'No' end as 'Is redirect?' -- Is the page is a redirect or not
from page
where page_namespace = 0 -- mainspace
and page_title regexp '.*‐.*' -- Page title contains U+2010 hyphen
order by page_title asc; -- Arrange in ascending order

AخA
 
select ROW_NUMBER() OVER(order by page_title) num, -- get row number       CONCAT('[[', replace(page_title, '_', ' '), ']]') as 'Page title', -- Format as wikilink, replace _ with space       case when page_is_redirect then 'Yes' else 'No' end as 'Is redirect?' -- Is the page is a redirect or notfrom pagewhere page_namespace = 0 -- mainspaceand page_title regexp '.*‐.*' -- Page title contains U+2010 hyphenorder by page_title asc; -- Arrange in ascending order

SQL

Checking query status...