SQL Query get item stats

INSERT INTO item_template (
entry, class, subclass,
name, displayid, quality,
inventorytype, StatsCount,
stat_type1, stat_value1,
stat_type2, stat_value2,
stat_type3, stat_value3,
stat_type4, stat_value4,
stat_type5, stat_value5,
stat_type6, stat_value6,
stat_type7, stat_value7,
stat_type8, stat_value8,
stat_type9, stat_value9,
stat_type10, stat_value10,
dmg_min1, dmg_max1, armor,
delay, ammo_type, RangedModRange,
bonding, description, Material,
sheath, itemset, socketColor_1,
socketColor_2, socketColor_3,
socketContent_1, socketContent_2,
socketContent_3, socketBonus)
SELECT MAX(entry)+1, class, subclass, name, displayid, quality, inventoryType, StatsCount, stat_type1,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value1*300 FROM item_template WHERE stat_type1 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value1*300 FROM item_template WHERE stat_type1 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value1*300 FROM item_template WHERE stat_type1 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value1*300 FROM item_template WHERE stat_type1 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value1*300 FROM item_template WHERE stat_type1 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type2,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value2*300 FROM item_template WHERE stat_type2 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value2*300 FROM item_template WHERE stat_type2 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value2*300 FROM item_template WHERE stat_type2 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value2*300 FROM item_template WHERE stat_type2 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value2*300 FROM item_template WHERE stat_type2 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type3,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value3*300 FROM item_template WHERE stat_type3 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value3*300 FROM item_template WHERE stat_type3 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value3*300 FROM item_template WHERE stat_type3 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value3*300 FROM item_template WHERE stat_type3 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value3*300 FROM item_template WHERE stat_type3 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type4,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value4*300 FROM item_template WHERE stat_type4 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value4*300 FROM item_template WHERE stat_type4 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value4*300 FROM item_template WHERE stat_type4 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value4*300 FROM item_template WHERE stat_type4 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value4*300 FROM item_template WHERE stat_type4 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type5,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value5*300 FROM item_template WHERE stat_type5 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value5*300 FROM item_template WHERE stat_type5 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value5*300 FROM item_template WHERE stat_type5 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value5*300 FROM item_template WHERE stat_type5 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value5*300 FROM item_template WHERE stat_type5 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type6,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value6*300 FROM item_template WHERE stat_type6 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value6*300 FROM item_template WHERE stat_type6 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value6*300 FROM item_template WHERE stat_type6 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value6*300 FROM item_template WHERE stat_type6 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value6*300 FROM item_template WHERE stat_type6 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type7,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value7*300 FROM item_template WHERE stat_type7 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value7*300 FROM item_template WHERE stat_type7 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value7*300 FROM item_template WHERE stat_type7 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value7*300 FROM item_template WHERE stat_type7 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value7*300 FROM item_template WHERE stat_type7 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type8,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value8*300 FROM item_template WHERE stat_type8 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value8*300 FROM item_template WHERE stat_type8 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value8*300 FROM item_template WHERE stat_type8 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value8*300 FROM item_template WHERE stat_type8 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value8*300 FROM item_template WHERE stat_type8 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type9,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value9*300 FROM item_template WHERE stat_type9 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value9*300 FROM item_template WHERE stat_type9 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value9*300 FROM item_template WHERE stat_type9 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value9*300 FROM item_template WHERE stat_type9 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value9*300 FROM item_template WHERE stat_type9 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END, stat_type10,
    CASE inventoryType
        WHEN 1 THEN (SELECT stat_value10*300 FROM item_template WHERE stat_type10 > 0 AND inventoryType = 1 AND name LIKE "%sanctified%") -- Head
        WHEN 2 THEN (SELECT stat_value10*300 FROM item_template WHERE stat_type10 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Shoulder
        WHEN 2 THEN (SELECT stat_value10*300 FROM item_template WHERE stat_type10 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Chest
        WHEN 2 THEN (SELECT stat_value10*300 FROM item_template WHERE stat_type10 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Legs
        WHEN 2 THEN (SELECT stat_value10*300 FROM item_template WHERE stat_type10 > 0 AND inventoryType = 2 AND name LIKE "%sanctified%") -- Hands
        ELSE 0
    END,
dmg_min1 * 300, dmg_max1 * 300, armor,
delay, ammo_type, RangedModRange,
bonding, "Tier1", Material,
sheath, itemset, socketColor_1,
socketColor_2, socketColor_3,
socketContent_1, socketContent_2,
socketContent_3, socketBonus FROM item_template WHERE name LIKE "%sanctified%";