Изменения

update Ip INNER JOIN users ON users.uid=Ip.user_uid SET Ip.user_uid = NULL, Ip.mac = NULL WHERE users.disabled > 0 and users.disable_date < '20172019-01-01' and Ip.subnet_id= xx ;