Untitled query #57614

SQL

WITH items as (
    SELECT page_title, log_timestamp, comment_text, actor_name
    FROM page
    JOIN page_restrictions ON page_id = pr_page 
  		AND pr_type = 'edit' 
  		AND pr_level = 'autoconfirmed' 
  		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 = 0
)
SELECT
   t1.page_title AS Article,
   t1.actor_name AS Protector,
   DATE_FORMAT(t1.log_timestamp, '%Y-%m-%d') AS Date,
   t1.comment_text AS Reason
FROM items t1
LEFT JOIN items t2 ON t1.page_title = t2.page_title AND t1.log_timestamp < t2.log_timestamp
WHERE t2.log_timestamp IS NULL
SQL

Checking query status...
