SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY) 日期,SUM(IF(mo.createtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.createtime < CURDATE() ,1,0)) 下单笔数,(SELECT COUNT(DISTINCT mao.userid) FROM mallorder mao WHERE mao.createtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mao.createtime < CURDATE() )   下单用户数量,(SELECT COUNT(DISTINCT userid) FROM express.mallorder mao WHERE mao.createtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mao.createtime < CURDATE() AND mao.paystatus = 2) '支付成功用户数',SUM(IF(mo.createtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.createtime < CURDATE() ,mo.saleprice,0))/100 下单总金额,SUM(IF(mo.paytime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.paytime < CURDATE() AND mo.paystatus = 2,1,0)) 成功支付笔数,SUM(IF(mo.paytime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.paytime < CURDATE() AND mo.paystatus = 2,mo.payprice,0))/100 成功支付总金额,SUM(IF(mo.refoundtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.refoundtime < CURDATE() AND mo.flowStatus IN (6,7,8),1,0)) 退款订单数,SUM(IF(mo.refoundtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.refoundtime < CURDATE() AND mo.flowStatus IN (6,7,8),mo.refoundprice,0))/100 退款总金额,SUM(IF(mo.flowStatus = 2,1,0)) 待发货订单数,(SELECT COUNT(DISTINCT relationname) FROM mallorder mall,mallorderdetail malld WHERE mall.id  = malld.orderid AND mall.createtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mall.createtime < CURDATE() ) 下单商品数 FROM mallorder mo,mallorderdetail mode WHERE mo.id  = mode.orderid;SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY) 日期,mallde.relationname 商品名称,SUM(mallde.relationcount) 销售数量,SUM(IF(mo.paystatus = 2 ,mallde.relationcount,0)) '支付成功数量',mallde.relationkindname 规格 FROM mallorder mo,mallorderdetail mallde WHERE mo.id = mallde.orderid AND mo.createtime > SUBDATE(CURDATE(),INTERVAL 1 DAY) AND mo.createtime < CURDATE() group BY mallde.relationname