长SQL语句

select 
id,       
plat_date,       
actiontype,       
exdebtcode,       
t8.codevalue,       
submit_user,       
submit_date,       
feed_user,       
feed_date,      
 t4.jgmc debtorcode,      
 t2.codevalue debtype,      
 valuedate,       
t5.codevalue contractcurrname,       
contractamount,       
maturity,       
t9.codevalue FLOATRATE,       
ANNINRATE,       
appcode,       
appname,       
creditorcode,       
creditorname,       
creditornamen,      
 t3.codevalue creditortype,       
t6.codevalue crehqcode,      
 t7.codevalue opercode,      
 INLTCABUSCODE,       
t10.codevalue spapfeboindex,       
actiondesc,      
 remark  
from T_FEDS_HWDFQXB      t1,       
t_feds_appcodeparam t2,      
 t_feds_appcodeparam t3,      
 t_base_bankinst     t4,       
T_FEDS_APPCODEPARAM T5,       
T_FEDS_APPCODEPARAM t6,       
T_FEDS_APPCODEPARAM t7,      
T_FEDS_APPCODEPARAM t8,       
T_FEDS_APPCODEPARAM t9,       
T_FEDS_APPCODEPARAM t10 


where t1.debtype = t2.codenumber   
and t2.codetype = '1'   
and t1.creditortype = t3.codenumber   
and t3.codetype = '9'   
and t1.contractcurr = t5.codenumber   
and t5.codetype = '17'   
and t1.crehqcode = t6.codenumber   
and t6.codetype = '11'   
and t1.opercode = t7.codenumber   
and t7.codetype = '11'   
and t1.debtorcode = t4.jgbh   
and t8.codetype='97'   
and t1.submit_id=t8.codenumber   
and t9.codetype='98'   
and t1.FLOATRATE=t9.codenumber   
and t10.codetype='98'   
and t1.spapfeboindex=t10.codenumber   
and plat_date like '%'   
and (debtorcode = '310000006200' or       debtorcode in       (select jgbh from t_base_bankinst where sjjg = '310000006200')) order by plat_date desc, plat_time desc