Registration date and first edit date

SQL

SET @page_title = 'Buon_Natale';

WITH latest_revision_per_image AS (
    SELECT il.il_to AS added_image, MAX(rev.rev_id) AS latest_rev_id
    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
    GROUP BY il.il_to
)
SELECT lr.added_image, rev.rev_id, rev.rev_timestamp, u.user_name
FROM latest_revision_per_image lr
JOIN revision rev ON lr.latest_rev_id = rev.rev_id
JOIN imagelinks il ON rev.rev_page = il.il_from
JOIN (
    SELECT DISTINCT rev_page, rev_actor, rev_timestamp
    FROM revision
) rev_distinct ON rev_distinct.rev_page = rev.rev_page
JOIN user u ON rev_distinct.rev_actor = u.user_id
ORDER BY rev.rev_timestamp DESC;
SQL

Checking query status...
