SELECT log_id, actor_name AS Deleter, DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS Timestamp, CONCAT('File:', log_title) AS Filename, comment_text AS Reason

FROM logging

JOIN comment_logging ON comment_id = log_comment_id

JOIN actor_logging ON actor_id = log_actor

WHERE log_type = 'delete'

  AND log_action = 'delete'

  AND log_namespace = 6

  AND comment_text LIKE 'Deleted old revision%'

ORDER BY log_id DESC

LIMIT 1000