SELECT page_namespace, page_title, log_timestamp, actor_name, log_action, comment_text

FROM logging

LEFT JOIN actor_logging ON actor_id = log_actor

LEFT JOIN comment_logging ON comment_id = log_comment_id

LEFT JOIN page ON page_id = log_page

WHERE log_id IN (SELECT MAX(log_id)

                 FROM logging

                 JOIN page_restrictions ON pr_id = log_page

                 WHERE pr_type = 'move'

                   AND pr_level = 'sysop'

                   AND log_type = 'protect'

                   AND log_action != 'unprotect'

                 GROUP BY log_page);