SET
@head = " Donor Head",
@shoulder = " Donor Shoulder",
@chest = " Donor Chest",
@legs = " Donor Legs",
@gloves = " Donor Gloves";
SELECT 
entry, 
class, 
CASE AllowableClass
	WHEN 1 THEN 
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Warrior", @head)
			WHEN 3 THEN CONCAT ("Warrior", @shoulder)
			WHEN 5 THEN CONCAT ("Warrior", @chest)
			WHEN 7 THEN CONCAT ("Warrior", @legs)
			WHEN 10 THEN CONCAT ("Warrior", @gloves)
			WHEN 20 THEN CONCAT ("Warrior", @chest)
		END
	WHEN 2 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Paladin", @head)
			WHEN 3 THEN CONCAT ("Paladin", @shoulder)
			WHEN 5 THEN CONCAT ("Paladin", @chest)
			WHEN 7 THEN CONCAT ("Paladin", @legs)
			WHEN 10 THEN CONCAT ("Paladin", @gloves)
			WHEN 20 THEN CONCAT ("Paladin", @chest)
		END
	WHEN 4 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Hunter", @head)
			WHEN 3 THEN CONCAT ("Hunter", @shoulder)
			WHEN 5 THEN CONCAT ("Hunter", @chest)
			WHEN 7 THEN CONCAT ("Hunter", @legs)
			WHEN 10 THEN CONCAT ("Hunter", @gloves)
			WHEN 20 THEN CONCAT ("Hunter", @chest)
		END
	WHEN 8 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Rogue", @head)
			WHEN 3 THEN CONCAT ("Rogue", @shoulder)
			WHEN 5 THEN CONCAT ("Rogue", @chest)
			WHEN 7 THEN CONCAT ("Rogue", @legs)
			WHEN 10 THEN CONCAT ("Rogue", @gloves)
			WHEN 20 THEN CONCAT ("Rogue", @chest)
		END
	WHEN 16 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Priest", @head)
			WHEN 3 THEN CONCAT ("Priest", @shoulder)
			WHEN 5 THEN CONCAT ("Priest", @chest)
			WHEN 7 THEN CONCAT ("Priest", @legs)
			WHEN 10 THEN CONCAT ("Priest", @gloves)
			WHEN 20 THEN CONCAT ("Priest", @chest)
		END
	WHEN 32 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Death Knight", @head)
			WHEN 3 THEN CONCAT ("Death Knight", @shoulder)
			WHEN 5 THEN CONCAT ("Death Knight", @chest)
			WHEN 7 THEN CONCAT ("Death Knight", @legs)
			WHEN 10 THEN CONCAT ("Death Knight", @gloves)
			WHEN 20 THEN CONCAT ("Death Knight", @chest)
		END
	WHEN 64 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Shaman", @head)
			WHEN 3 THEN CONCAT ("Shaman", @shoulder)
			WHEN 5 THEN CONCAT ("Shaman", @chest)
			WHEN 7 THEN CONCAT ("Shaman", @legs)
			WHEN 10 THEN CONCAT ("Shaman", @gloves)
			WHEN 20 THEN CONCAT ("Shaman", @chest)
		END
	WHEN 128 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Mage", @head)
			WHEN 3 THEN CONCAT ("Mage", @shoulder)
			WHEN 5 THEN CONCAT ("Mage", @chest)
			WHEN 7 THEN CONCAT ("Mage", @legs)
			WHEN 10 THEN CONCAT ("Mage", @gloves)
			WHEN 20 THEN CONCAT ("Mage", @chest)
		END
	WHEN 256 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Warlock", @head)
			WHEN 3 THEN CONCAT ("Warlock", @shoulder)
			WHEN 5 THEN CONCAT ("Warlock", @chest)
			WHEN 7 THEN CONCAT ("Warlock", @legs)
			WHEN 10 THEN CONCAT ("Warlock", @gloves)
			WHEN 20 THEN CONCAT ("Warlock", @chest)
		END
	WHEN 1024 THEN
		CASE InventoryType
			WHEN 1 THEN CONCAT ("Druid", @head)
			WHEN 3 THEN CONCAT ("Druid", @shoulder)
			WHEN 5 THEN CONCAT ("Druid", @chest)
			WHEN 7 THEN CONCAT ("Druid", @legs)
			WHEN 10 THEN CONCAT ("Druid", @gloves)
			WHEN 20 THEN CONCAT ("Druid", @chest)
		END
END as name, 
displayid, 
allowableclass, 
inventorytype 
FROM item_template WHERE name LIKE "sanctified%" AND inventorytype > 0 AND itemlevel = 264;