select distinct a.brxm00,a.txm000,a.YEXM00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.dycs00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH ,SUBSTR(SF_JY_UNION_XMMC00_BBK(txm000,mzzybz,zyhghh,'','',0,1),1,120) xmmc00,a.sqks00,a.SQBQ00 from VW_JY_YW0000 a where 1=1  and  sqks00 = '474'  and  pyrq00 >= '2020-08-12'  and  pyrq00 <= '2020-08-19'  and zlxmid not in (17917)  order by PYRQ00 ,yqdh00,ybh000,ch0000