SELECT count(username) as num,uid,username FROM ubbs_home_blog WHERE `status`='0' AND `time`>='123456' GROUP BY `username` ASC ORDER BY `num` DESC limit();