Убрать дроп

[Nytrex]

Код:

delete from droplist where itemid!=57 and mobid not in ('L2Boss','L2RaidBoss','L2Minion');

[Bumble]

Код:

delete from droplist where itemid!=57 and mobid not in ('L2Boss','L2RaidBoss','L2Minion');

Немного не корректно...

Правильнее так:

Код:

delete from droplist where itemid!=57 and mobid not in (select `id` from `npc` where type = 'L2Boss' and 'L2RaidBoss' and 'L2Minion');