select has.id HAS_ID,
               htf.id HTF_ID,
               htfbew.halmv_id HAS_MSN_ID,
               case
                 when htfbew.bew = 1 and hv.bew_von is not null and hv.bew_bis is not null then
                  1
                 else
                  0
               end HTF_BEW,