WITH period_articles AS (

  SELECT *

  FROM page

  WHERE (page_title LIKE "%."

         OR page_title LIKE "%;"

         OR page_title LIKE "%,"

         OR page_title LIKE "%:"

         OR page_title LIKE "%!"

         OR page_title LIKE "%?"

         OR page_title LIKE "%)")

  AND page_namespace = 0

  AND page_is_redirect = 0

)

​

SELECT SUBSTRING(page_title, 1, LENGTH(page_title) - 1) as redirect, page_title as target

FROM period_articles

WHERE SUBSTRING(page_title, 1, LENGTH(page_title) - 1) NOT IN (SELECT page_title FROM page WHERE page_namespace = 0)