update catalog_product_entity_int m
left join eav_attribute a on a.entity_type_id = 4 and a.attribute_id =
m.attribute_id
set value = 2
where
  a.attribute_code = 'status'
  and m.entity_id in
    (
  select m.entity_id
  from catalog_product_entity m
  left join catalog_product_entity_media_gallery_value_to_entity a
  on a.entity_id = m.entity_id
  where a.value_id is null
)