mariaDB 提取两个日期之间的日期列表，并显示星期几

SELECT tt.selected_date,tt.xq,
 CASE WHEN tt.xq = 1 THEN '星期日' 
            WHEN tt.xq = 2 THEN '星期一' 
            WHEN tt.xq = 3 THEN '星期二' 
      WHEN tt.xq = 4 THEN '星期三' 
            WHEN tt.xq = 5 THEN '星期四' 
            WHEN tt.xq = 6 THEN '星期五' 
            WHEN tt.xq = 7 THEN '星期六' 
      ELSE '' END as xqj
from (
select date_format(selected_date,'%Y-%m-%d') as selected_date,dayofweek(date_format(selected_date,'%Y%m%d')) as xq 
from 
(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_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 sel