SELECT CAST(log_timestamp AS DATETIME) AS time_stamp, log_action, actor_name, CONCAT('User:', 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;

​