Sql query

[Rury]

Hello, i need a Query SQL to delete items of players who do not have promotion (I don't know if this is possible)

Example: If the player have item ID 2160 and not have promotion (Table SQL Promotion = 0) Then Delete

 

[Ninja]

DELETE FROM `player_items` WHERE `itemtype` = 2160 AND `player_id` IN (SELECT `id` FROM `players` WHERE `promotion` = 0);

 

[Rury]

Thanks