1       10:38:46  SQL Execute: ORACLE -  select  C.BMMC00 DQBQMC,Trim(replace(B.CYXJ00,chr(10),'$')) CYXJ00,B.XM0000 BRXM00,A.*,B.*,D.YBMC00,E.FBMC00 RYFBMC,F.YZCS00,F.YZYBJE,D.SFXNH0,
 (select decode(count(*),0,0,1) bafsbz from zy_basyxx f where f.zyid00=B.zyid00 and f.fscgbz='1' ) BAFSBZ, 
 (select decode(count(*),0,0,1) zdlrbz from bq_brzdxx g where g.zyid00=B.zyid00 and g.zdlb00='3' ) ZDLRBZ, 
 (select YSZJHM from bm_ygbm00 where ygbh00=decode(B.ZZYS00,0,B.SXYS00,B.ZZYS00)) YSZJHM,(select bmmc00 from bm_bmbm00 where bmbh00=b.rybq00) RYBQMC 
 from VW_SF_BRXX00 A, ZY_BRXXB0 B,bm_bmbm00 C,IC_YBBRLB D,BM_BRFBB0 E,ZY_BRZHXX F
 where  A.BRID00 = B.BRID00  and  B.DQBQ00 = C.BMBH00  and B.YBLB00 = D.YBLB00  and B.FBBH00 = D.FBBH00 and B.FBBH00 = E.FBBH00 AND A.BRID00 = F.BRID00
 and B.brzt00 in ('4','5') and B.fbbh00+0=3 and not exists ( select 1 from zy_basyxx F where f.zyid00=B.zyid00 and f.fscgbz='1' )
 AND D.SFXNH0='1' 
ORDER BY B.ZYID00 desc

2       10:38:52  SQL Execute: ORACLE -  select  C.BMMC00 DQBQMC,Trim(replace(B.CYXJ00,chr(10),'$')) CYXJ00,B.XM0000 BRXM00,A.*,B.*,D.YBMC00,E.FBMC00 RYFBMC,F.YZCS00,F.YZYBJE,D.SFXNH0,
 (select decode(count(*),0,0,1) bafsbz from zy_basyxx f where f.zyid00=B.zyid00 and f.fscgbz='1' ) BAFSBZ, 
 (select decode(count(*),0,0,1) zdlrbz from bq_brzdxx g where g.zyid00=B.zyid00 and g.zdlb00='3' ) ZDLRBZ, 
 (select YSZJHM from bm_ygbm00 where ygbh00=decode(B.ZZYS00,0,B.SXYS00,B.ZZYS00)) YSZJHM,(select bmmc00 from bm_bmbm00 where bmbh00=b.rybq00) RYBQMC 
 from VW_SF_BRXX00 A, ZY_BRXXB0 B,bm_bmbm00 C,IC_YBBRLB D,BM_BRFBB0 E,ZY_BRZHXX F
 where  A.BRID00 = B.BRID00  and  B.DQBQ00 = C.BMBH00  and B.YBLB00 = D.YBLB00  and B.FBBH00 = D.FBBH00 and B.FBBH00 = E.FBBH00 AND A.BRID00 = F.BRID00
 and B.brzt00 in ('4','5') and B.fbbh00+0=3 and not exists ( select 1 from zy_basyxx F where f.zyid00=B.zyid00 and f.fscgbz='1' )
 AND D.SFXNH0='1' 
ORDER BY B.ZYID00 desc