[[x]]->[[x.]] redir mismatches

Mainspace pages whose title ends in a period, where the same title without the ending period or periods currently exists and is not a redirect to the first title.

For [[WP:VPT#Redirects for article titles ending in periods]] circa 8 July 2023.

SQL

SELECT art.page_title,
       REGEXP_REPLACE(art.page_title, '\\.+$', '') AS 'proposed redir',
       CASE
         WHEN (redir.page_is_redirect != 1 OR rd_namespace IS NULL) THEN 'exists, not a redir'
         WHEN rd_namespace = 0 THEN CONCAT('exists, redir to ', rd_title)
         ELSE CONCAT('exists, redir to {{ns:', rd_namespace, '}}:', rd_title)
       END AS 'current status'
FROM page AS art
JOIN page AS redir
  ON redir.page_namespace = 0
  AND redir.page_title = REGEXP_REPLACE(art.page_title, '\\.+$', '')
LEFT JOIN redirect
  ON rd_from = redir.page_id
WHERE art.page_namespace = 0
  AND art.page_title LIKE '%.'
  AND art.page_is_redirect = 0
  AND (redir.page_is_redirect != 1
       OR rd_namespace != 0
       OR rd_title != art.page_title);

SQL

Checking query status...