SET STATEMENT max_statement_time = 300 FOR
SELECT * FROM (
    SELECT
        revs.rev_id AS `id`,
        revs.rev_timestamp AS `timestamp`,
        revs.rev_minor_edit AS `minor`,
        revs.rev_len AS `length`,
        (CAST(revs.rev_len AS SIGNED) - IFNULL(parentrevs.rev_len, 0)) AS `length_change`,
        actor_user AS user_id,
        actor_name AS username,
        comment_text AS `comment`,
        revs.rev_sha1 AS `sha`,
        revs.rev_deleted AS `deleted`
    FROM `enwiki_p`.`revision` AS revs
    LEFT JOIN `enwiki_p`.`actor` ON revs.rev_actor = actor_id
    LEFT JOIN `enwiki_p`.`revision` AS parentrevs ON (revs.rev_parent_id = parentrevs.rev_id)
    LEFT OUTER JOIN `enwiki_p`.`comment` ON comment_id = revs.rev_comment_id
    WHERE  revs.rev_page = 22929254
    ORDER BY revs.rev_timestamp DESC
) a
ORDER BY `timestamp` ASC