Find Drupal users with the most revisions over a period of time

activeusers.sql

SELECT c.count,
       users.name
FROM   (SELECT Count(*) count,
               uid
        FROM   node_revision
        WHERE  From_unixtime(timestamp) > Date_sub(Curdate(), INTERVAL 2 month)
        GROUP  BY uid) c,
       users
WHERE  c.uid = users.uid
ORDER  BY count;