Query sandbox - Quarry

SQL

SELECT page_title, logging.log_timestamp, comment_text, actor_name
FROM page
JOIN page_restrictions ON page_id = pr_page AND pr_level = 'sysop' AND pr_type = 'edit' AND pr_expiry = 'infinity'
JOIN logging ON page_id = log_page AND log_type = 'protect'
JOIN comment ON log_comment_id = comment_id
LEFT JOIN logging logging2 ON logging.log_page = logging2.log_page AND logging.log_timestamp < logging2.log_timestamp
JOIN actor ON logging.log_actor = actor_id
WHERE logging2.log_timestamp IS NULL
AND page_namespace = 0 
AND page_is_redirect = 1
SQL

Checking query status...
