mysql -- 分组统计 和 日期过滤

SELECT
uuif.nickname as nickname ,
uuif.userpicurl as userpicurl,
SUM(ggr.giftnum) as giftnum,   #分组统计
ggr.sendmemberid as memberid
from
g_gift_reocrd ggr
LEFT JOIN
u_userinfo uuif
ON
uuif.memberid = ggr.sendmemberid
WHERE
date_format(ggr.sendtime,'%Y-%m-%d') = date_format(NOW(),'%Y-%m-%d')  #sendtime 为 当天
AND
ggr.receivememberid = 9168782639328552
GROUP BY
ggr.sendmemberid  
ORDER BY
giftnum DESC
LIMIT
0,5
;