SELECT 

    page.page_title, 

    first_actor.actor_name, 

    MIN(rev.rev_timestamp) AS rev_timestamp

FROM revision_userindex AS rev

JOIN page ON rev.rev_page = page.page_id

JOIN actor_revision AS act_rev ON act_rev.actor_id = rev.rev_actor

JOIN (

    SELECT rev_page, rev_actor

    FROM revision_userindex

    WHERE rev_parent_id = 0

) AS first_revisions ON first_revisions.rev_page = page.page_id

JOIN actor_revision AS first_actor ON first_actor.actor_id = first_revisions.rev_actor

WHERE act_rev.actor_name = 'GiantSnowman'

AND page.page_namespace = 4

AND page.page_title REGEXP '^Articles_for_deletion/' 

AND page.page_title NOT REGEXP '^Articles_for_deletion/Log/'

-- AND rev.rev_timestamp >= '20240212000000'

GROUP BY page.page_title, first_actor.actor_name

ORDER BY rev.rev_timestamp DESC;