Get largest net addition edits of user

SQL

SELECT
	*,
    (CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len` AS SIGNED)) AS `diff`,
    (
      SELECT GROUP_CONCAT(ctd_name SEPARATOR ",")
      FROM change_tag
      JOIN change_tag_def ON ctd_id = ct_tag_id
      WHERE ct_rev_id = main.rev_id
    ) AS ts_tags
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`
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 ts_tags NOT REGEXP "\\Wmw-rollback\\W"
    AND ts_tags NOT REGEXP "\\Wmw-undo\\W"
ORDER BY (CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len` AS SIGNED)) DESC
LIMIT 100
SQL

Checking query status...
