Query sandbox - Quarry

SQL

-- SELECT page_title, log_timestamp, comment_text, actor_name
SELECT *
FROM page
LEFT JOIN page page2 ON page.page_title = page2.page_title AND page.log_timestamp < page2.log_timestamp
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
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...
