sql语句:

SELECT FROM_UNIXTIME(add_time,'%Y-%m-%d') as days,(`order_amount`-`integral_money`-`discount`-`member_discount`) as money FROM dcsx_order WHERE agentid=2 and order_type in(10,100,30) and is_pay=1 and orgid in(1,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,12,11,7,6,5,4,3,2) and add_time BETWEEN 1488297600 and 1490544000 GROUP BY days LIMIT 0,10