Query sandbox - Quarry

SQL

SELECT *
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
-- LEFT JOIN logging logging2 ON logging.log_page = logging2.log_page AND logging.log_timestamp < logging2.log_timestamp
JOIN actor ON logging.log_actor = actor_id
WHERE -- logging2.log_timestamp IS NULL
-- AND 
page_namespace = 0 
AND page_is_redirect = 1
ORDER BY page_id
SQL

Checking query status...
