Untitled query #63421

SQL

WITH items as (
    SELECT *
    FROM revision
    LEFT JOIN logging_logindex ON log_namespace = page_namespace AND log_title = page_title 
    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.comment_text AS Edit summary
   t1.actor_name AS Editor
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...
