Trailing special characters

Fork of Trailing special characters by BilledMammal

This query is marked as a draft This query has been published by Anomie.

SQL

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 NOT LIKE "%(%" AND 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)

SQL

Checking query status...