SELECT 

    p.page_id, 

    p.page_title, 

    p.page_touched, 

    actor.actor_name AS creator_username

FROM page AS p

INNER JOIN (

    SELECT rev_page, MIN(rev_id) AS first_rev_id

    FROM revision

    GROUP BY rev_page

) AS first_rev ON p.page_id = first_rev.rev_page

INNER JOIN revision AS r ON first_rev.rev_page = r.rev_page AND first_rev.first_rev_id = r.rev_id

INNER JOIN actor ON r.rev_actor = actor.actor_id

LEFT JOIN recentchanges AS rc ON p.page_id = rc.rc_cur_id

WHERE 

    p.page_namespace = 0  -- Only main namespace (Articles)

    AND p.page_is_redirect = 0  -- Exclude redirects

    AND (rc.rc_patrolled IS NULL OR rc.rc_patrolled = 0)  -- Unpatrolled pages

ORDER BY p.page_touched DESC

LIMIT 100;

​