Miscellany

delete from droplist using npc, droplist, etcitem
where npc.id = droplist.mobId and droplist.itemId = etcitem.item_id and (etcitem.crystal_type = 's' or etcitem.name like '%sealed%');

delete from droplist using npc, droplist, etcitem
where npc.id = droplist.mobId and droplist.itemId = etcitem.item_id and (etcitem.crystal_type = 'a' or etcitem.name like '%sealed%');

delete from droplist using npc, droplist, weapon
where npc.id = droplist.mobId and droplist.itemId = weapon.item_id and (weapon.crystal_type = 's' or weapon.name like '%sealed%'); 

delete from droplist using npc, droplist, weapon
where npc.id = droplist.mobId and droplist.itemId = weapon.item_id and (weapon.crystal_type = 'a' or weapon.name like '%sealed%');

delete from droplist using npc, droplist, armor
where npc.id = droplist.mobId and droplist.itemId = armor.item_id and (armor.crystal_type = 's' or armor.name like '%sealed%');

delete from droplist using npc, droplist, armor
where npc.id = droplist.mobId and droplist.itemId = armor.item_id and (armor.crystal_type = 'a' or armor.name like '%sealed%');