/*снимает аварию как тревога, где не надо*/
update device_list
set device_mode = device_mode - 4096
where code_type_device in
(
  select code_type_device from type_device
  where model_id in(30,32,33,35,38, 22, 23, 30,31, 34)
)
and bin_and(device_mode, 4096) <> 0;