Query sandbox - Quarry

SQL

WITH redr as (
  SELECT page_id, page_title, 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
  JOIN actor ON logging.log_actor = actor_id
  WHERE page_namespace = 0 
  AND page_is_redirect = 1
) 
SELECT redr.page_title, redr.log_timestamp, redr.comment_text, redr.actor_name FROM redr
LEFT JOIN redr redr2 ON redr.page_id = redr2.page_id AND redr.log_timestamp < redr2.log_timestamp
WHERE redr2.log_timestamp IS NULL
SQL

Checking query status...
