most active AoA users

gistfile1.sql

SELECT `customercare_reply`.`twitter_username`, `auth_user`.`username` as 'SUMO_username', count(*) as 'tweets'
FROM `customercare_reply`
LEFT JOIN `auth_user` on `auth_user`.`id`=`customercare_reply`.`user_id`
WHERE `customercare_reply`.`created` >= '2013-04-02 0'
GROUP BY `customercare_reply`.`twitter_username` ORDER BY COUNT(*) DESC;