Problem editing data base

[dgprado]

Help plz:
i am using this query:
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players)

But nothing is deletd:
0 row(s) deleted.

i had deleted a lot of players.
if this heapends because some trigger ploblem, is there some way to fix it ?

 

[dgprado]

Help plz i relly need this.

 

[Jano]

the query its ok, should work :/

 

[Specjalist]

everything is fine, items are getting deleted automatically