mysql语句之-一列中连续的日期

select * from (
select a.assigned_date date,ifnull(b.nn,0) kwtimes from
(select assigned_date
from
(select adddate('2020-01-01',t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) assigned_date
from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3
) c
where assigned_date between (select min(date(time)) from pushdata) and NOW()) a
left join (select date(time) as date,count(*) nn from pushdata where (select @kw:='数字货币') or app like concat('%',@kw,'%') or title like concat('%',@kw,'%') or content like concat('%',@kw,'%') group by date) b
on a.assigned_date=b.date
) d
where date>=(select min(date(time)) from pushdata where app like concat('%',@kw,'%') or title like concat('%',@kw,'%') or content like concat('%',@kw,'%'))