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

FROM (

  SELECT r_first.rev_page, r_first.rev_timestamp

  FROM revision r_first

  WHERE r_first.rev_parent_id = 0

    AND r_first.rev_timestamp >= '20100101000000'

    AND r_first.rev_timestamp < '20120823203303'

    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

    )

  ORDER BY r_first.rev_timestamp

  LIMIT 100

) AS filtered

JOIN page p ON p.page_id = filtered.rev_page;