sql query donor gear

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;