UPDATE `item_template` SET `spellid_1`=6307 WHERE `entry`=16321;
UPDATE `item_template` SET `spellid_1`=7804 WHERE `entry`=16322;
UPDATE `item_template` SET `spellid_1`=7805 WHERE `entry`=16323;
UPDATE `item_template` SET `spellid_1`=11766 WHERE `entry`=16324;
UPDATE `item_template` SET `spellid_1`=11767 WHERE `entry`=16325;
UPDATE `item_template` SET `spellid_1`=27268 WHERE `entry`=22180;
UPDATE `item_template` SET `spellid_1`=47982 WHERE `entry`=36959;

DELETE FROM npc_vendor WHERE entry in (5520, 5749, 5750,  5753, 5815, 6027, 6328, 6373, 6374, 6376, 6382, 12776, 12807, 15494, 16267, 16649, 23535);  
UPDATE creature_template SET npcflag=3 WHERE subname="Demon Trainer" ;  
UPDATE creature_template SET subname="" WHERE subname="Demon Trainer" ;

DELETE FROM `npc_vendor` WHERE `item` IN (16321,16322,16323,16324,16325,22180,36959);

REPLACE INTO `npc_trainer` SELECT `entry`,  '23161', '200000', '762', '150', '61' FROM `creature_template` WHERE `subname`='Warlock Trainer';

UPDATE `creature_template` SET npcflag = npcflag&~128;
UPDATE `creature_template` SET npcflag = npcflag|128 WHERE entry in (select entry from npc_trainer);