IP subpage un/deletions

All logged deletions and restorations of userspace subpages of IPs.

For [[WT:CSD#Clarification on U2 for IP subpages]] circa 15 October 2022.

SQL

SELECT CAST(log_timestamp AS DATETIME) AS time_stamp,
       log_action,
       actor_name,
       CONCAT('User:', REPLACE(log_title, '_', ' ')) AS page_name,
       comment_text
FROM logging_logindex
JOIN actor_logging ON actor_id = log_actor
JOIN comment_logging ON comment_id = log_comment_id
WHERE log_namespace = 2
  AND log_title LIKE '%/%'
  AND (IS_IPV4(SUBSTRING_INDEX(log_title,'/',1))
       OR IS_IPV6(SUBSTRING_INDEX(log_title,'/',1)))
  AND log_type = 'delete'
  AND log_action IN ('delete', 'restore')
ORDER BY log_timestamp DESC;

SQL

Checking query status...