Untitled query #81039

SQL

SELECT REPLACE(p.page_title, "_", " "), 
       SUM(CAST(rev.rev_len AS INT) - CAST(rev_old.rev_len AS INT)) AS total_len
FROM page AS p
JOIN revision_userindex AS rev ON rev.rev_page = p.page_id
JOIN revision_userindex AS rev_old ON rev_old.rev_id = rev.rev_parent_id
JOIN change_tag ON change_tag.ct_rev_id = rev.rev_id
JOIN change_tag_def ON change_tag_def.ctd_id = change_tag.ct_tag_id
JOIN actor ON actor_id = rev.rev_actor
WHERE p.page_is_redirect = 0
AND p.page_namespace = 0
AND (change_tag_def.ctd_name != 'mw-rollback' OR change_tag_def.ctd_name != 'mw-manual-revert' OR change_tag_def.ctd_name != 'mw-undo')
AND actor_name = "Cyclone605"
GROUP BY p.page_title
ORDER BY total_len DESC
LIMIT 100;
SQL

Checking query status...
