SELECT log_namespace,

       log_title,

       pr1.pr_expiry AS 'Move expiry',

       pr2.pr_level AS 'Edit protection',

       page_is_redirect,

       log_timestamp,

       log_action,

       actor_name,

       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_restrictions AS pr1 ON pr1.pr_page = log_page AND pr1.pr_type = 'move'

LEFT JOIN page_restrictions AS pr2 ON pr2.pr_page = log_page AND pr2.pr_type = 'edit'

LEFT JOIN page ON page_id = log_page

WHERE log_id IN (SELECT MAX(log_id)

                 FROM page

                 JOIN page_restrictions AS pr3 ON pr3.pr_page = page_id

                 JOIN logging_logindex ON log_page = page_id AND log_type = 'protect' AND log_action != 'unprotect'

                 WHERE pr3.pr_type = 'move'

                   AND pr3.pr_level = 'sysop'

                 GROUP BY log_page)

  AND pr1.pr_level = 'sysop';

​