update catalog_product_entity p,catalog_product_entity_int ci,disable d set ci.value=2
where p.entity_id=ci.entity_id and ci.attribute_id=84 and d.product_code=p.sku
update catalog_product_entity p,cataloginventory_stock_item ci,disable d set ci.is_in_stock=0
where p.entity_id=ci.product_id and d.product_code=p.sku
where p.entity_id=ci.entity_id and ci.attribute_id=84 and d.product_code=p.sku
update catalog_product_entity p,cataloginventory_stock_item ci,disable d set ci.is_in_stock=0
where p.entity_id=ci.product_id and d.product_code=p.sku