Something

SELECT armor.name, armor.crystal_type, npc.name, droplist.chanceFROM droplist, armor, weapon, npcWHERE (armor.crystal_type = "A" OR armor.crystal_type = "S" OR armor.name LIKE "%Sealed%" OR weapon.crystal_type = "A" OR weapon.crystal_type = "S")AND (armor.item_id = droplist.itemId OR weapon.item_id = droplist.itemId)AND droplist.mobId = npc.idORDER BY npc.name, droplist.chance, armor.name, armor.crystal_type