select a.click_date,IFNULL(b.count,0) as couns,IFNULL(b.totprice,0) as totprice
from (
SELECT curdate() as click_date
union all
SELECT date_sub(curdate(), interval 1 day) as click_date
union all
SELECT date_sub(curdate(), interval 2 day) as click_date
union all
SELECT date_sub(curdate(), interval 3 day) as click_date
union all
SELECT date_sub(curdate(), interval 4 day) as click_date
union all
SELECT date_sub(curdate(), interval 5 day) as click_date
union all
SELECT date_sub(curdate(), interval 6 day) as click_date
) a left join (
select date(order_pay_time) as datetime, count(*) as count,sum(order_fee_total_pay) as totprice
from sys_order
where seller_id=12
group by date(order_pay_time) ASC
) b on a.click_date = b.datetime;
//参考https://blog.csdn.net/ouyang1...