Query sandbox - Quarry

SQL

SELECT page_title, logging.log_timestamp, comment_text, actor_name
FROM page
JOIN page_restrictions ON page_id = pr_page
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 log_actor = actor_id
WHERE pr_type = 'edit'
AND pr_level = 'sysop'
AND page.page_namespace = 0 
AND page.page_is_redirect = 1
AND pr_expiry = 'infinity'
SQL

Checking query status...
