trwiki:Top 1000 editors by bytes

SQL

USE trwiki_p;
/*SELECT actor_name, SUM(rev_len) as bytes
FROM revision
JOIN actor_revision ON rev_actor = actor_id
JOIN page ON rev_page = page_id
WHERE
	rev_parent_id = 0
    AND page_namespace = 0
    AND page_is_redirect=0
    AND rev_deleted=0
GROUP BY actor_id
ORDER BY bytes DESC
LIMIT 1000;
SELECT actor_name,
       SUM(b.rev_len - COALESCE(a.rev_len, 0)) AS bytes
FROM revision_userindex b
LEFT JOIN revision a ON a.rev_id = b.rev_parent_id
JOIN actor_revision on actor_id = b.rev_actor
JOIN page ON page_id = a.rev_page
WHERE page_namespace = 0
AND page_is_redirect=0
AND b.rev_deleted=0 AND a.rev_deleted=0
GROUP BY actor_id
ORDER BY bytes DESC
LIMIT 1000;*/

SELECT actor_name,
       SUM(b.rev_len - COALESCE(a.rev_len, 0)) AS bytes
FROM revision_userindex b
LEFT JOIN revision a ON a.rev_id = b.rev_parent_id
JOIN actor_revision on actor_id = b.rev_actor
JOIN page ON page_id = a.rev_page
JOIN user_groups ON ug_user = a.rev_actor AND ug_group NOT LIKE '%bot%'
WHERE page_namespace = 0
AND page_is_redirect=0
AND b.rev_deleted=0 AND a.rev_deleted=0
GROUP BY actor_id
ORDER BY bytes DESC
LIMIT 1000;
SQL

Checking query status...
