ANTICHAT — форум по информационной безопасности, OSINT и технологиям

UPDATE `ankets`,`posred` 
SET `priority` = CASE WHEN `tp` != "-1" AND `balance` >= `tp` 
   THEN `tp` WHEN `priority` != 0 AND `balance` < `priority`  
   THEN 0 ELSE `priority` END,
`balance` =  CASE WHEN `balance` >= `tp` AND `tp` != "-1" 
   THEN `balance` - `tp` WHEN `priority` != 0  
   THEN `balance` - `priority` ELSE `balance` END ,`tp` = "-1" 
WHERE `ankets`.`order_id` = `posred`.`id`