sql for items

SET @name = "V.I.P";
SELECT
class,
subclass,
CASE allowableclass
    WHEN 1 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Warrior ", "Head")
        WHEN 3 THEN CONCAT(@name, " Warrior ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Warrior ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Warrior ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Warrior ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Warrior ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Warrior ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Warrior ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Warrior ", "Chest")
    END

    WHEN 2 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Paladin ", "Head")
        WHEN 3 THEN CONCAT(@name, " Paladin ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Paladin ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Paladin ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Paladin ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Paladin ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Paladin ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Paladin ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Paladin ", "Chest")
    END

    WHEN 4 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Hunter ", "Head")
        WHEN 3 THEN CONCAT(@name, " Hunter ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Hunter ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Hunter ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Hunter ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Hunter ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Hunter ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Hunter ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Hunter ", "Chest")
    END

    WHEN 8 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Rogue ", "Head")
        WHEN 3 THEN CONCAT(@name, " Rogue ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Rogue ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Rogue ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Rogue ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Rogue ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Rogue ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Rogue ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Rogue ", "Chest")
    END

    WHEN 16 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Priest ", "Head")
        WHEN 3 THEN CONCAT(@name, " Priest ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Priest ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Priest ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Priest ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Priest ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Priest ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Priest ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Priest ", "Chest")
    END

    WHEN 64 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Shaman ", "Head")
        WHEN 3 THEN CONCAT(@name, " Shaman ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Shaman ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Shaman ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Shaman ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Shaman ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Shaman ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Shaman ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Shaman ", "Chest")
    END

    WHEN 128 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Mage ", "Head")
        WHEN 3 THEN CONCAT(@name, " Mage ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Mage ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Mage ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Mage ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Mage ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Mage ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Mage ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Mage ", "Chest")
    END

    WHEN 256 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Warlock ", "Head")
        WHEN 3 THEN CONCAT(@name, " Warlock ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Warlock ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Warlock ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Warlock ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Warlock ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Warlock ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Warlock ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Warlock ", "Chest")
    END

    WHEN 1024 THEN
    CASE inventorytype
        WHEN 1 THEN CONCAT(@name, " Druid ", "Head")
        WHEN 3 THEN CONCAT(@name, " Druid ", "Shoulder")
        WHEN 5 THEN CONCAT(@name, " Druid ", "Chest")
        WHEN 6 THEN CONCAT(@name, " Druid ", "Waist")
        WHEN 7 THEN CONCAT(@name, " Druid ", "Legs")
        WHEN 8 THEN CONCAT(@name, " Druid ", "Feet")
        WHEN 9 THEN CONCAT(@name, " Druid ", "Wrist")
        WHEN 10 THEN CONCAT(@name, " Druid ", "Gloves")
        WHEN 20 THEN CONCAT(@name, " Druid ", "Chest")
    END
END AS name,
5 AS quality,
allowableclass,
inventorytype,
displayid,
255 AS itemlevel,
255 AS requiredlevel,
10 AS StatsCount,
10000 AS armor,
1 AS bonding,
1 AS socketColor_1,
2 AS socketColor_2,
4 AS socketColor_3,
"VIP Instance Item" AS description
FROM item_template WHERE itemset IN (669,679,670,672,684,668,671,677,675) ORDER BY allowableclass;