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
        )
)
SELECT rev.rev_id, rev.rev_timestamp, ia.added_image, u.user_name, t.old_text, t.old_flags
FROM revision rev
JOIN image_additions ia ON rev.rev_id = ia.rev_id
JOIN user u ON rev.rev_actor = u.user_id
JOIN text t ON rev.rev_text_id = t.old_id
WHERE rev.rev_timestamp IS NOT NULL
ORDER BY rev.rev_timestamp DESC;
SQL

Checking query status...
