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 latest_revision_cte AS (
    SELECT rev.rev_id, rev.rev_timestamp, u.user_name
    FROM revision rev
    JOIN page p ON rev.rev_page = p.page_id
    JOIN user u ON rev.rev_actor = u.user_id
    WHERE p.page_title = @page_title
        AND p.page_namespace = 0  -- Filter for article namespace (ID 0)
    ORDER BY rev.rev_timestamp DESC
    LIMIT 1
)
SELECT lr.rev_id, lr.rev_timestamp, il.il_to AS added_image, lr.user_name
FROM latest_revision_cte lr
JOIN imagelinks il ON lr.rev_id = il.il_from;

SQL

Checking query status...