Registration date and first edit date

Fork of Malayalam Wikipedia Articles without images by Gnoeee

This query is marked as a draft This query has been published by Gnoeee.

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 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
FROM revision rev
JOIN image_additions ia ON rev.rev_id = ia.rev_id
JOIN user u ON rev.rev_actor = u.user_id
ORDER BY rev.rev_timestamp DESC;

SQL

Checking query status...