SELECT armor.name, armor.crystal_type, npc.name, droplist.chance
FROM droplist, armor, weapon, npc
WHERE (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.id
ORDER BY npc.name, droplist.chance, armor.name, armor.crystal_type