SELECT armor.name, characters.char_name, armor.crystal_type
FROM 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