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;

​