SELECT

    *,

    (CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len` AS SIGNED)) AS `diff`

FROM `revision_userindex` AS `main`

LEFT JOIN `revision_userindex` AS `parent` ON `parent`.`rev_id` = `main`.`rev_parent_id`

LEFT JOIN `comment_revision` ON `main`.`rev_comment_id` = `comment_id`

LEFT JOIN `change_tag` ct_rb ON 

    ct_rb.`ct_rev_id` = main.`rev_id` 

    AND ct_rb.`ct_tag_id` = ( SELECT ctd_id FROM change_tag_def WHERE ctd_name = "mw-rollback" )

LEFT JOIN `change_tag` ct_ud ON 

    ct_ud.`ct_rev_id` = main.`rev_id` 

    AND ct_ud.`ct_tag_id` = ( SELECT ctd_id FROM change_tag_def WHERE ctd_name = "mw-undo" )

RIGHT JOIN `page` ON `main`.`rev_page` = `page_id`

WHERE

    `main`.`rev_actor` = (SELECT `actor_id` FROM `actor_revision` WHERE `actor_name` = "FormalDude")

    AND `page_namespace` = 0

    AND ct_rb.`ct_id` IS NULL

    AND ct_ud.`ct_id` IS NULL

ORDER BY (CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len` AS SIGNED)) DESC

LIMIT 100