Untitled query #79206

SQL

WITH cte AS 
(SELECT 1 n, 2, 3, 4, 5 UNION ALL SELECT
n+1,
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)
SELECT * FROM cte
SQL

Checking query status...
