Registration date and first edit date

SQL

SET @page_title = 'Buon_Natale';

WITH image_additions AS (
    SELECT rev.rev_id, il.il_to AS added_image
    FROM revision rev
    JOIN page p ON rev.rev_page = p.page_id
    JOIN imagelinks il ON rev.rev_page = il.il_from
    WHERE p.page_title = @page_title
        AND p.page_namespace = 0
        AND NOT EXISTS (
            SELECT 1
            FROM revision prev
            JOIN imagelinks prev_il ON prev.rev_page = prev_il.il_from
            WHERE prev.rev_page = rev.rev_page
                AND prev.rev_id < rev.rev_id
                AND prev_il.il_to = il.il_to
        )
),
latest_revision_per_image AS (
    SELECT ia.added_image, MAX(rev.rev_id) AS latest_rev_id
    FROM image_additions ia
    JOIN revision rev ON ia.rev_id = rev.rev_id
    GROUP BY ia.added_image
)
SELECT lr.rev_id, rev.rev_timestamp, ia.added_image, u.user_name
FROM latest_revision_per_image lr
JOIN revision rev ON lr.latest_rev_id = rev.rev_id
JOIN imagelinks ia ON rev.rev_page = ia.il_from
JOIN user u ON rev.rev_actor = u.user_id
ORDER BY rev.rev_timestamp DESC;
SQL

Checking query status...
