-- delete  old warrior spells
DELETE FROM npc_trainer WHERE spell IN (1671, 1672, 6554, 7372, 7373, 7400, 7402, 7887, 11584, 11585, 20559, 20560, 20616, 20617, 23892, 23893, 23894, 25212, 25251, 25266, 25272, 25275, 29704, 30335);
  
-- 17844	Vindicator Aesom need some spells.
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(17844, 3127, 100, 0, 0, 8),			-- Parry (Passive)
(17844, 13820, 10000, 0, 0, 20),        -- Warhorse (Summon)
(17844, 20217, 3600, 0, 0, 20),         -- Blessing of Kings
(17844, 23214, 200000, 762, 150, 40),   -- Charger (Summon)
(17844, 62124, 3000, 0, 0, 16);         -- Hand of Reckoning

-- (10930)Dargh Trueaim, (4138)Jeen'ra Nightrunner, (8308)Alenndaar Lapidaar, (17122)Vord need 62757 - Call Stabled Pet
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(10930,62757,300000,0,0,80),
(4138,62757,300000,0,0,80),
(8308,62757,300000,0,0,80),
(17122,62757,300000,0,0,80);

-- (31084)Highlord Darion Mograine  need some spells.
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(31084,61999,360000,0,0,72),-- 61999-Raise Ally
(31084,62158,360000,0,0,40),-- 62158-Rune of the Stoneskin Gargoyle
(31084,42650,360000,0,0,80);-- 42650-Army of the Dead


-- High Priest Rohan is Priest trainer;
UPDATE creature_template
SET  trainer_class = 5
WHERE entry = 11406;

-- delete Priest spell 528-Cure Disease from shamans trainers
DELETE FROM npc_trainer
WHERE   spell = 528 AND entry IN (SELECT entry  FROM  creature_template WHERE trainer_class = 7);

-- delete 42955-Conjure Refreshment Spell Level = 75 from beginners mage trainers 198-Khelden Bremen, 2124-Isabella, 15279-Julia Sunstriker
DELETE FROM   npc_trainer
WHERE   spell = 42955 AND entry IN (198,2124,15279);    

-- delete from Warlock trainer 6251-Strahad Farsan  spells DK Death Coil (Rank 1-5) and Priest Shadow Protection (Rank 5) 
DELETE FROM npc_trainer WHERE  entry  = 6251 AND spell IN (47541, 48169, 49892, 49893, 49894, 49895);

-- Delete 1066 Aquatic Form (Shapeshift) from beginners druid trainer 3060	Gart Mistrunner
DELETE FROM npc_trainer WHERE  entry  =  3060	and spell=1066;

-- delete  SPELLFAMILY_HUNTER spell 19883-Track Humanoids from 3036	Kym Wildmane
DELETE FROM npc_trainer WHERE  entry  =  3036	and spell=19883;