SET @rev = (SELECT MIN(rev_id)

            FROM revision

            WHERE rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -120 DAY), "%Y%m%d%H%i%s"));

SELECT COUNT(*) AS 'Edits',

    actor_name AS `User`,

    ug_group AS `Rights`

FROM revision_userindex

JOIN actor_revision ON rev_actor = actor_id

LEFT JOIN user_groups ON ug_user = actor_user

WHERE rev_id >= @rev AND NOT ug_group = 'bot'

GROUP BY `User`

ORDER BY Edits DESC

LIMIT 100;

​