SELECT p.page_id, p.page_namespace, p.page_title, r_first.rev_timestamp

FROM revision r_first

JOIN page p ON r_first.rev_page = p.page_id

WHERE r_first.rev_parent_id = 0

  AND EXISTS (

    SELECT 1

    FROM revision r_later

    WHERE r_later.rev_page = r_first.rev_page

      AND r_later.rev_comment_id = 33984

      AND r_later.rev_timestamp > r_first.rev_timestamp  -- Ensure it's a later revision

  )

ORDER BY r_first.rev_timestamp

LIMIT 100;