Untitled query #79326

SQL

SELECT new_posts.page_title, a.actor_name AS first_user
FROM (
    SELECT p.page_id, MIN(r.rev_timestamp) AS first_revision
    FROM revision r
    JOIN page p ON p.page_id = r.rev_page
    WHERE p.page_namespace = 0 
        AND p.page_is_redirect = 0 
        AND r.rev_parent_id = 0
    GROUP BY p.page_id
    HAVING first_revision BETWEEN 20230101000000 AND 20231231235959
) AS new_posts
JOIN revision r ON new_posts.page_id = r.rev_page AND new_posts.first_revision = r.rev_timestamp
JOIN actor a ON r.rev_actor = a.actor_id
limit 10
SQL

Checking query status...
