От меня всем спосибо! Я сам нашол что было надо ))
DELETE FROM droplist
WHERE mobid NOT IN (SELECT id FROM npc WHERE TYPE = 'L2GrandBoss')
AND mobid NOT IN (SELECT id FROM npc WHERE TYPE = 'L2RaidBoss')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE 'adena')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%life stone%')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%seal stone%')
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%enchant%' AND item_type = 'scroll')