Untitled query #79206

SQL

SET @i=0;
SELECT @i:=@i+1 n, t.* FROM
(SELECT
actor_name					AS editor,
-- COUNT(DISTINCT actor_name),
    COUNT(*)					AS revisions,
    COUNT(DISTINCT rev_page) 	AS pages,
	ROUND(SUM(rev_len)/1024)	AS size_Kbytes
FROM revision r JOIN actor a ON rev_actor = actor_id
JOIN page p ON p.page_id = r.rev_page
JOIN user_groups ug ON a.actor_user = ug.ug_user
WHERE rev_timestamp > NOW() - INTERVAL 1 YEAR
AND p.page_namespace = 0
AND ug.ug_group <> 'bot'
GROUP BY rev_actor
HAVING pages > 1000
ORDER BY size_Kbytes DESC) t;
SQL

Checking query status...
