Untitled query #63531

SQL

SELECT
 p2.page_title
 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)
  LEFT 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 (
    COALESCE(r2.rd_namespace,p2.page_namespace) != COALESCE(r1.rd_namespace,p1.page_namespace)
    OR COALESCE(r2.rd_title,p2.page_title) != COALESCE(r1.rd_title,p1.page_title)
  )
 and p1.page_namespace=0 and p1.page_is_redirect=0 and p2.page_is_redirect=1
 ORDER BY p1.page_namespace, p1.page_title
 LIMIT 10000;
SQL

Checking query status...
