select BAH000,
       BRXM00,
       BRXB00,
       CYKBMC,
       BASCYXYZYZD,
       dyb.JBMC00,
       cm.SSMC00,
       ZYTS00,
       ZLXG00,
       ZFY,
       BLFX00,
       ZYZD,
       ZYZL,
       ZYQT,
       ZCYF,
       ZCYF1,
       CYRQ00,
       ss.SSZL00
  from VW_BA_BRZYFY_30 VW
  left join bq_brzdxx zd on VW.LSH000 = zd.zyid00
                        and ZDLB00 = '4'
  left join xt_icddyb dyb on zd.ZDM000 = dyb.ICD100
  left join ba_brssxx ss on VW.LSH000 = ss.lsh000
  left join (select cm1.cm3000, max(cm1.ssmc00) ssmc00
               from ba_cm3000 cm1
              group by cm1.cm3000) cm on ss.SSM000 = cm.cm3000
 where 1 = 1
   and (SSXH00 =
       (select min(b1.ssxh00) from ba_brssxx b1 where b1.lsh000 = vw.lsh000) or
       SSXH00 is null)
   and vw.lsh000 in
       (select (vw.lsh000)
          from VW_BA_BRZYFY_30 VW
          left join bq_brzdxx zd on VW.LSH000 = zd.zyid00
                                and ZDLB00 = '4'
          left join xt_icddyb dyb on zd.ZDM000 = dyb.ICD100
          left join ba_brssxx ss on VW.LSH000 = ss.lsh000
          left join (select cm1.cm3000, max(cm1.ssmc00) ssmc00
                      from ba_cm3000 cm1
                     group by cm1.cm3000) cm on ss.SSM000 = cm.cm3000
         where 1 = 1
           and CYRQ00 >= '20190101'
           and CYRQ00 <= '20191231'
           and CYKB00 in
               (select bmbh00 from bm_bmbm00 where yyid00 = '220006'))
 order by vw.bah000