Anonymous

SELECT armor.name, characters.char_name, armor.crystal_typeFROM items, armor, weapon, characters WHERE (armor.crystal_type = "A" OR armor.crystal_type = "S" OR armor.name LIKE "%Sealed%")AND (armor.item_id = items.item_id OR weapon.item_id = items.item_id)AND characters.obj_Id = items.owner_id