SELECT Count(*) AS ActivityCount, `user`.`userid`, `user`.`username` AS Username FROM `post` INNER JOIN `user` ON `post`.`userid` = `user`.`userid` WHERE FROM_UNIXTIME(`post`.`dateline`) >= DATE_SUB(NOW(), INTERVAL 1 DAY) AND `post`.`visible` < 2 GROUP BY Username ORDER BY ActivityCount DESC, Username ASC