Get largest net addition edits of user

SQL

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` = "Chlod")
    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
SQL

Checking query status...
