SELECT channelid AS name, count(uid) AS value FROM rc_user_info WHERE addtime >= (NOW() - INTERVAL 24 HOUR) GROUP BY channelid
最近24小时记录
原文:http://www.cnblogs.com/dengyg200891/p/6859960.html