Query sandbox - Quarry

SQL

SELECT redr.page_title, redr.log_timestamp, redr.comment_text, redr.actor_name FROM (
  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' AND log_action != 'move_prot'
  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
) redr
LEFT JOIN (
  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' AND log_action != 'move_prot'
  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
) t2 ON redr.page_id = t2.page_id AND redr.log_timestamp < t2.log_timestamp
WHERE t2.log_timestamp IS NULL
SQL

Checking query status...
