#Выборка по итем сэтам
SET @iset = '211'; #вместо 211 ваш итем сэт для поиска

SET @nm = '900k SPD'; #название/name
SET @scl = '1';       #подкласс/subclass
SET @ilvl = '100';    #итем левел
SET @arm = '20000';   #armor
SET @qua = '2';       #quality/качество
SET @niset = NULL;    #новый ид итем сэта (если хотите убрать ид сэта ставьте NULL)
SET @rlvl = '80';     #уровень для использования предмета
SET @acl = '-1';      #Требуемые классы для использования -1 для всех

SET @sc1 = '2'; #сокет1
SET @sc2 = '4'; #сокет2
SET @sc3 = '8'; #сокет3

SET @st1 = '4'; #stattype1
SET @st2 = '3'; #stattype2   
SET @st3 = '7'; #stattype3
SET @st4 = '5'; #stattype4
SET @st5 = '6'; #stattype5   
SET @st6 = '1'; #stattype6
SET @st7 = '45'; #stattype7   
SET @st8 = '31'; #stattype8   
SET @st9 ='36'; #stattype9
SET @st10 =NULL; #stattype10

SET @sv1 = '900000'; #statvalue1
SET @sv2 = '900000'; #statvalue2
SET @sv3 = '900000'; #statvalue3
SET @sv4 = '900000'; #statvalue4
SET @sv5 = '900000'; #statvalue5
SET @sv6 = '900000'; #statvalue6
SET @sv7 = '900000'; #statvalue7
SET @sv8 = '1000';   #statvalue8
SET @sv9 = '1000';   #statvalue9
SET @sv10 =NULL;     #statvalue10

UPDATE `item_template` SET `spellid_1`=0 WHERE `itemset` = @iset;
UPDATE `item_template` SET `spellid_2`=0 WHERE `itemset` = @iset;
UPDATE `item_template` SET `spellid_3`=0 WHERE `itemset` = @iset;
UPDATE `item_template` SET `spellid_4`=0 WHERE `itemset` = @iset;
UPDATE `item_template` SET `spellid_5`=0 WHERE `itemset` = @iset;

UPDATE `item_template` set `AllowableClass` = @acl WHERE `itemset` = @iset;

UPDATE `item_template` set `subclass` = @scl WHERE `itemset` = @iset;
UPDATE `item_template` set `StatsCount` = 10 WHERE `itemset` = @iset;
UPDATE `item_template` set `name` = @nm WHERE `itemset` = @iset;
UPDATE `item_template` set `quality` = @qua WHERE `itemset` = @iset;
UPDATE `item_template` set `armor`= @arm WHERE `itemset` = @iset;
UPDATE `item_template` set `requiredlevel`= @rlvl WHERE `itemset` = @iset;

UPDATE `item_template` set `stat_type1`=NULL, `stat_value1`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type2`=NULL, `stat_value2`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type3`=NULL, `stat_value3`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type4`=NULL, `stat_value4`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type5`=NULL, `stat_value5`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type6`=NULL, `stat_value6`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type7`=NULL, `stat_value7`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type8`=NULL, `stat_value8`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type9`=NULL, `stat_value9`=NULL WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type10`=NULL, `stat_value10`=NULL WHERE `itemset` = @iset;

UPDATE `item_template` set `stat_type1`= @st1, `stat_value1`= @sv1 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type2`= @st2, `stat_value2`= @sv2 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type3`= @st3, `stat_value3`= @sv3 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type4`= @st4, `stat_value4`= @sv4 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type5`= @st5, `stat_value5`= @sv5 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type6`= @st6, `stat_value6`= @sv6 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type7`= @st7, `stat_value7`= @sv7 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type8`= @st8, `stat_value8`= @sv8 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type9`= @st9, `stat_value9`= @sv9 WHERE `itemset` = @iset;
UPDATE `item_template` set `stat_type10`= @st10, `stat_value10`= @sv10 WHERE `itemset` = @iset;

Update `item_template` SET `itemset`= @niset WHERE `name`= @nm;
UPDATE `item_template` set `itemlevel` = @ilvl WHERE `name` = @nm;

UPDATE `item_template` set `socketColor_1` = @sc1 WHERE `name`= @nm;
UPDATE `item_template` set `socketColor_2` = @sc2 WHERE `name`= @nm;
UPDATE `item_template` set `socketColor_3` = @sc3 WHERE `name`= @nm;