select trim(B.ZYH000) ZYH000,A.BRXM00 ,A.CH0000 ,B.XB0000 ,(SELECT SUBSTRB(sf_bq_csrqtonl(b.csrq00), 1, 100) FROM DUAL) brnl00,  count(a.yzid00) cfsl00 from YF_YZYPSQ A,zy_brxxb0 b ,bm_yd0000 c where a.zyid00=b.zyid00 and a.ypnm00 = c.ypnm00 and a.yzxz00 = '3' and a.QLZT00 in ('0','1')    and a.FYBZ00='0' and a.CXBZ00='Z' and (B.BRZT00 like '2%' or B.BRZT00 like '3%' or B.BRZT00 like '4%' or B.BRZT00 like '5%')   and a.THBZ00='0' and nvl(c.DPDJ00,0) =0 and nvl(c.mzdj00,0) = 0 and nvl(c.sjdj00,0) = 0  and a.srrq00 between :开始日期 and :结束日期 and a.bqbmbh =:病区  and a.yfbmbh =:XT_BMBM group by b.zyh000,a.brxm00,a.ch0000,b.xb0000,b.csrq00