Hello. I',m trying to remove all droplist from monsters, and i wanna to leave only Adena.
I tried like that -
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE itemid <> 57);
But not working for me. Maybe anyone can me explain how to make it?