select '2018-12-12',a.bq,b.sq,f.tq
from (select concat(nfdm,substr(char(int(djz)+100),2,2)) bq
from dm.td_rq
where rqdm='2018-12-12') a
inner join
(select concat(nfdm,substr(char(int(djz)+100),2,2)) sq
from dm.td_rq
where rqdm='2018-12-05')b on 1=1
inner join
(select concat(nfdm,substr(char(int(djz)+100),2,2)) tq
from dm.td_rq
where rqdm='2017-12-12')f
on 1=1
with qsz_rq_bq as(
select max(rqdm) rq
from dm.td_rq
where nfdm=case when INT(V_ZC)=1 then trim(char(int(V_NF)-1)) else V_NF end
and djz=case when INT(V_ZC)=1 then 53 else INT(V_ZC)-1 end
),
qsz_rq_tq as(
select max(rqdm) rq
from dm.td_rq
where nfdm=case when INT(V_ZC)=1 then trim(char(int(V_NF)-2)) else trim(char(int(V_NF)-1)) end
and djz=case when INT(V_ZC)=1 then 53 else INT(V_ZC)-1 end
),
qsz_rq as(
select a.rq rq_bq,a.rq - 7 days rq_sq,b.rq rq_tq
from qsz_rq_bq a
inner join qsz_rq_tq b on 1=1
)
