Articles with trailing special characters generating conflicting redirects

SQL

SELECT
  MIN(p1.page_title) AS title1,
  MAX(p1.page_title) AS title2,
  COUNT(*) AS n
  REGEXP_REPLACE( CONVERT(p1.page_title USING utf8), IF(p1.page_title LIKE '%(%', '[_,;.:!?]+$', '[_,;.:!?)]+$' ), '' ) AS target
FROM
  page as p1
  LEFT JOIN page AS p2 ON ( p1.page_namespace = p2.page_namespace AND REGEXP_REPLACE( CONVERT(p1.page_title USING utf8), IF(p1.page_title LIKE '%(%', '[_,;.:!?]+$', '[_,;.:!?)]+$' ), '' ) = p2.page_title )
WHERE
  (
    p1.page_title LIKE '%,'
    OR p1.page_title LIKE '%;'
    OR p1.page_title LIKE '%.'
    OR p1.page_title LIKE '%:'
    OR p1.page_title LIKE '%!'
    OR p1.page_title LIKE '%?'
    OR p1.page_title LIKE '%)' AND p1.page_title NOT LIKE '%(%'
  )
  AND p1.page_namespace=0
  AND REGEXP_REPLACE( CONVERT(p1.page_title USING utf8), '[_,;.:!?)]+$', '') != ''
  AND p2.page_id IS NULL
  AND p1.page_is_redir = 0
  GROUP BY target
  HAVING COUNT(*)>1

SQL

Checking query status...