Outdated AnomieBOT EnDashRedirectCreator redirects

SQL

SELECT
  CONCAT(CASE p2.page_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN 'Wikipedia' WHEN 6 THEN 'File' WHEN 8 THEN 'MediaWiki' WHEN 10 THEN 'Template' WHEN 12 THEN 'Help' WHEN 100 THEN 'Portal' WHEN 108 THEN 'Book' WHEN 710 THEN 'TimedText' ELSE '???' END, CASE WHEN p2.page_namespace=0 THEN '' WHEN p2.page_namespace=1 THEN 'Talk:' WHEN p2.page_namespace & 1 THEN ' talk:' ELSE ':' END, REPLACE(p2.page_title,'_',' ')) AS page,
  CONCAT(CASE r2.rd_namespace & ~1 WHEN 0 THEN '' WHEN 4 THEN 'Wikipedia' WHEN 6 THEN 'File' WHEN 8 THEN 'MediaWiki' WHEN 10 THEN 'Template' WHEN 12 THEN 'Help' WHEN 100 THEN 'Portal' WHEN 108 THEN 'Book' WHEN 710 THEN 'TimedText' ELSE '???' END, CASE WHEN r2.rd_namespace=0 THEN '' WHEN r2.rd_namespace=1 THEN 'Talk:' WHEN r2.rd_namespace & 1 THEN ' talk:' ELSE ':' END, REPLACE(r2.rd_title,'_',' '), IF(r2.rd_fragment!='',CONCAT('#', r2.rd_fragment), '')) AS curTarget,
  CONCAT(CASE COALESCE(r1.rd_namespace,p1.page_namespace) & ~1 WHEN 0 THEN '' WHEN 4 THEN 'Wikipedia' WHEN 6 THEN 'File' WHEN 8 THEN 'MediaWiki' WHEN 10 THEN 'Template' WHEN 12 THEN 'Help' WHEN 100 THEN 'Portal' WHEN 108 THEN 'Book' WHEN 710 THEN 'TimedText' ELSE '???' END, CASE WHEN COALESCE(r1.rd_namespace,p1.page_namespace)=0 THEN '' WHEN COALESCE(r1.rd_namespace,p1.page_namespace)=1 THEN 'Talk:' WHEN COALESCE(r1.rd_namespace,p1.page_namespace) & 1 THEN ' talk:' ELSE ':' END, REPLACE(COALESCE(r1.rd_title, p1.page_title),'_',' '), IF(r1.rd_fragment!='',CONCAT('#', r1.rd_fragment), '')) AS newTarget
 FROM page as p1
  JOIN page AS p2 ON ( p1.page_namespace = p2.page_namespace AND REGEXP_REPLACE( CONVERT(p1.page_title USING utf8), '[–]', '-' ) = p2.page_title )
  LEFT JOIN redirect AS r1 ON(r1.rd_from=p1.page_id)
  JOIN redirect AS r2 ON(r2.rd_from=p2.page_id)
 WHERE p1.page_title LIKE '%–%'
  AND p1.page_namespace NOT IN (2,3,14,15,118,119,446,447,828,829,2300,2301,2302,2303,2600,2601)
  AND (
    r2.rd_namespace != COALESCE(r1.rd_namespace,p1.page_namespace)
    OR r2.rd_title != COALESCE(r1.rd_title,p1.page_title)
    OR r2.rd_fragment != r1.rd_fragment
  )
  AND EXISTS(SELECT 1 FROM revision WHERE rev_page=p2.page_id AND rev_actor=184 AND rev_parent_id=0)
 ORDER BY p1.page_namespace, p1.page_title
 LIMIT 5000;
SQL

Checking query status...
