SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,

       CONCAT(CASE log_namespace WHEN 108 THEN 'Book:' ELSE 'Book talk:' END, log_title) AS pagename,

       actor_name,

       comment_text

FROM logging_logindex

LEFT JOIN actor_logging ON actor_id = log_actor

LEFT JOIN comment_logging ON comment_id = log_comment_id

WHERE log_type = 'delete'

  AND log_action = 'restore'

  AND log_namespace IN (108, 109)

ORDER BY log_timestamp DESC;