Sandbox - Quarry

SQL

WITH items as (
    SELECT page_title, actor_name, log_timestamp, comment_text,
           MAX(log_timestamp) OVER (PARTITION BY page_title) AS log_timestamp_max
    FROM page
             JOIN page_restrictions ON page_id = pr_page
        AND pr_type = 'edit'
        AND pr_level = 'sysop'
        AND pr_expiry = 'infinity'
             LEFT JOIN logging_logindex ON log_namespace = page_namespace AND log_title = page_title
        AND log_type = 'protect'
        AND log_action != 'move_prot'
             LEFT JOIN comment_logging ON log_comment_id = comment_id
             LEFT JOIN actor_logging ON log_actor = actor_id
    WHERE page_namespace = 0
      AND page_is_redirect = 1
)
SELECT page_title, actor_name, log_timestamp, comment_text FROM items
WHERE log_timestamp = log_timestamp_max
SQL

Checking query status...
