/*уст игнор аварию от снятого для ручных фобос 3*/
update device_list
set device_mode = device_mode - 2147483648
where code_type_device in
(
  select code_type_device from type_device
  where model_id in(30,32,33,35,38)
)
and bin_and(device_mode, -2147483648)=0
and parent_device_code in
(
  select code_device_list from device_list
  where code_type_device in(98, 149)
);