SELECT `SeatID` FROM `tickets` WHERE `OrderID` IN (3021,3022,3023);

UPDATE `seats` SET `Status`= 0 WHERE `ID` IN(SELECT `SeatID` FROM `tickets` WHERE `OrderID` IN (3021,3022,3023));

SELECT * FROM `seats` WHERE `ID` IN(SELECT `SeatID` FROM `tickets` WHERE `OrderID` IN (3021,3022,3023));

DELETE FROM `tickets` WHERE  `OrderID` IN (3021,3022,3023);

DELETE FROM `orders` WHERE `ID` IN (3021,3022,3023);