Untitled query #54382

SQL

SELECT log_namespace, log_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
WHERE log_id IN (SELECT MAX(log_id)
                 FROM page
                 JOIN page_restrictions ON pr_id = page_id
                 JOIN logging ON log_title = page_title
                 AND log_namespace = page_namespace
                 WHERE pr_type = 'move'
                   AND pr_level = 'sysop'
                   AND log_type = 'protect'
                   AND log_action != 'unprotect'
                 GROUP BY log_namespace, log_title);
SQL

Checking query status...
