[LF] Need DB developers for the Emucoach repack projects
What's new

Post 1 of 7 Massive DBError.log Clean-up v7.0.2

mastermind

mastermind

Silver Supporter
Senior User
188
2017
13
Location
PA, USA
Please disregard this post. There is a better and safer way referenced here.
http://www.emucoach.com/showthread.php?2237-Event-Scripts&p=31114&viewfull=1#post31114

Will need multiple posts as this hits the 60000 character cap.

Not game fixing stuff just DBError.log clean up.

Code: 
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- Massive DBError.log Clean-up
-- --------------------------------------------------------------------------------------------------------------------
DELETE FROM `creature_addon` WHERE `guid` = 0;
DELETE FROM `creature_addon` WHERE `guid` = 1846;
DELETE FROM `creature_addon` WHERE `guid` = 7465;
DELETE FROM `creature_addon` WHERE `guid` = 7648;
DELETE FROM `creature_addon` WHERE `guid` = 8399;
DELETE FROM `creature_addon` WHERE `guid` = 12481;
DELETE FROM `creature_addon` WHERE `guid` = 18941;
DELETE FROM `creature_addon` WHERE `guid` = 19187;
DELETE FROM `creature_addon` WHERE `guid` = 33108;
DELETE FROM `creature_addon` WHERE `guid` = 33618;
DELETE FROM `creature_addon` WHERE `guid` = 39526;
DELETE FROM `creature_addon` WHERE `guid` = 45243;
DELETE FROM `creature_addon` WHERE `guid` = 61088;
DELETE FROM `creature_addon` WHERE `guid` = 66487;
DELETE FROM `creature_addon` WHERE `guid` = 66739;
DELETE FROM `creature_addon` WHERE `guid` = 75941;
DELETE FROM `creature_addon` WHERE `guid` = 75989;
DELETE FROM `creature_addon` WHERE `guid` = 76005;
DELETE FROM `creature_addon` WHERE `guid` = 76015;
DELETE FROM `creature_addon` WHERE `guid` = 76180;
DELETE FROM `creature_addon` WHERE `guid` = 76371;
DELETE FROM `creature_addon` WHERE `guid` = 76376;
DELETE FROM `creature_addon` WHERE `guid` = 76630;
DELETE FROM `creature_addon` WHERE `guid` = 76652;
DELETE FROM `creature_addon` WHERE `guid` = 76690;
DELETE FROM `creature_addon` WHERE `guid` = 76843;
DELETE FROM `creature_addon` WHERE `guid` = 76947;
DELETE FROM `creature_addon` WHERE `guid` = 76972;
DELETE FROM `creature_addon` WHERE `guid` = 76999;
DELETE FROM `creature_addon` WHERE `guid` = 90630;
DELETE FROM `creature_addon` WHERE `guid` = 90663;
DELETE FROM `creature_addon` WHERE `guid` = 90859;
DELETE FROM `creature_addon` WHERE `guid` = 91225;
DELETE FROM `creature_addon` WHERE `guid` = 91291;
DELETE FROM `creature_addon` WHERE `guid` = 91384;
DELETE FROM `creature_addon` WHERE `guid` = 91629;
DELETE FROM `creature_addon` WHERE `guid` = 91647;
DELETE FROM `creature_addon` WHERE `guid` = 91892;
DELETE FROM `creature_addon` WHERE `guid` = 94339;
DELETE FROM `creature_addon` WHERE `guid` = 94344;
DELETE FROM `creature_addon` WHERE `guid` = 94353;
DELETE FROM `creature_addon` WHERE `guid` = 94363;
DELETE FROM `creature_addon` WHERE `guid` = 94365;
DELETE FROM `creature_addon` WHERE `guid` = 94366;
DELETE FROM `creature_addon` WHERE `guid` = 94367;
DELETE FROM `creature_addon` WHERE `guid` = 94377;
DELETE FROM `creature_addon` WHERE `guid` = 94384;
DELETE FROM `creature_addon` WHERE `guid` = 94397;
DELETE FROM `creature_addon` WHERE `guid` = 94402;
DELETE FROM `creature_addon` WHERE `guid` = 94405;
DELETE FROM `creature_addon` WHERE `guid` = 94411;
DELETE FROM `creature_addon` WHERE `guid` = 94413;
DELETE FROM `creature_addon` WHERE `guid` = 94414;
DELETE FROM `creature_addon` WHERE `guid` = 94420;
DELETE FROM `creature_addon` WHERE `guid` = 95419;
DELETE FROM `creature_addon` WHERE `guid` = 95562;
DELETE FROM `creature_addon` WHERE `guid` = 109710;
DELETE FROM `creature_addon` WHERE `guid` = 109714;
DELETE FROM `creature_addon` WHERE `guid` = 109715;
DELETE FROM `creature_addon` WHERE `guid` = 112432;
DELETE FROM `creature_addon` WHERE `guid` = 130694;
DELETE FROM `creature_addon` WHERE `guid` = 149277;
DELETE FROM `creature_addon` WHERE `guid` = 149286;
DELETE FROM `creature_addon` WHERE `guid` = 149781;
DELETE FROM `creature_addon` WHERE `guid` = 158224;
DELETE FROM `creature_addon` WHERE `guid` = 161758;
DELETE FROM `creature_addon` WHERE `guid` = 165670;
DELETE FROM `creature_addon` WHERE `guid` = 165671;
DELETE FROM `creature_addon` WHERE `guid` = 166968;
DELETE FROM `creature_addon` WHERE `guid` = 166970;
DELETE FROM `creature_addon` WHERE `guid` = 166971;
DELETE FROM `creature_addon` WHERE `guid` = 173272;
DELETE FROM `creature_addon` WHERE `guid` = 174256;
DELETE FROM `creature_addon` WHERE `guid` = 175369;
DELETE FROM `creature_addon` WHERE `guid` = 175555;
DELETE FROM `creature_addon` WHERE `guid` = 175556;
DELETE FROM `creature_addon` WHERE `guid` = 180244;
DELETE FROM `creature_addon` WHERE `guid` = 180266;
DELETE FROM `creature_addon` WHERE `guid` = 180276;
DELETE FROM `creature_addon` WHERE `guid` = 180279;
DELETE FROM `creature_addon` WHERE `guid` = 180294;
DELETE FROM `creature_addon` WHERE `guid` = 180295;
DELETE FROM `creature_addon` WHERE `guid` = 180299;
DELETE FROM `creature_addon` WHERE `guid` = 180300;
DELETE FROM `creature_addon` WHERE `guid` = 180301;
DELETE FROM `creature_addon` WHERE `guid` = 180302;
DELETE FROM `creature_addon` WHERE `guid` = 180333;
DELETE FROM `creature_addon` WHERE `guid` = 180337;
DELETE FROM `creature_addon` WHERE `guid` = 180348;
DELETE FROM `creature_addon` WHERE `guid` = 180351;
DELETE FROM `creature_addon` WHERE `guid` = 180355;
DELETE FROM `creature_addon` WHERE `guid` = 181767;
DELETE FROM `creature_addon` WHERE `guid` = 182160;
DELETE FROM `creature_addon` WHERE `guid` = 182173;
DELETE FROM `creature_addon` WHERE `guid` = 182176;
DELETE FROM `creature_addon` WHERE `guid` = 182178;
DELETE FROM `creature_addon` WHERE `guid` = 182179;
DELETE FROM `creature_addon` WHERE `guid` = 182180;
DELETE FROM `creature_addon` WHERE `guid` = 182181;
DELETE FROM `creature_addon` WHERE `guid` = 182183;
DELETE FROM `creature_addon` WHERE `guid` = 182188;
DELETE FROM `creature_addon` WHERE `guid` = 182200;
DELETE FROM `creature_addon` WHERE `guid` = 182201;
DELETE FROM `creature_addon` WHERE `guid` = 182203;
DELETE FROM `creature_addon` WHERE `guid` = 182210;
DELETE FROM `creature_addon` WHERE `guid` = 182211;
DELETE FROM `creature_addon` WHERE `guid` = 182213;
DELETE FROM `creature_addon` WHERE `guid` = 182216;
DELETE FROM `creature_addon` WHERE `guid` = 182221;
DELETE FROM `creature_addon` WHERE `guid` = 182222;
DELETE FROM `creature_addon` WHERE `guid` = 182224;
DELETE FROM `creature_addon` WHERE `guid` = 182228;
DELETE FROM `creature_addon` WHERE `guid` = 182230;
DELETE FROM `creature_addon` WHERE `guid` = 182231;
DELETE FROM `creature_addon` WHERE `guid` = 182234;
DELETE FROM `creature_addon` WHERE `guid` = 182236;
DELETE FROM `creature_addon` WHERE `guid` = 182238;
DELETE FROM `creature_addon` WHERE `guid` = 182247;
DELETE FROM `creature_addon` WHERE `guid` = 182252;
DELETE FROM `creature_addon` WHERE `guid` = 182254;
DELETE FROM `creature_addon` WHERE `guid` = 182258;
DELETE FROM `creature_addon` WHERE `guid` = 182260;
DELETE FROM `creature_addon` WHERE `guid` = 182265;
DELETE FROM `creature_addon` WHERE `guid` = 182266;
DELETE FROM `creature_addon` WHERE `guid` = 182268;
DELETE FROM `creature_addon` WHERE `guid` = 182269;
DELETE FROM `creature_addon` WHERE `guid` = 182270;
DELETE FROM `creature_addon` WHERE `guid` = 182271;
DELETE FROM `creature_addon` WHERE `guid` = 182272;
DELETE FROM `creature_addon` WHERE `guid` = 182273;
DELETE FROM `creature_addon` WHERE `guid` = 182274;
DELETE FROM `creature_addon` WHERE `guid` = 182275;
DELETE FROM `creature_addon` WHERE `guid` = 182279;
DELETE FROM `creature_addon` WHERE `guid` = 182280;
DELETE FROM `creature_addon` WHERE `guid` = 183457;
DELETE FROM `creature_addon` WHERE `guid` = 183458;
DELETE FROM `creature_addon` WHERE `guid` = 183502;
DELETE FROM `creature_addon` WHERE `guid` = 183513;
DELETE FROM `creature_addon` WHERE `guid` = 183514;
DELETE FROM `creature_addon` WHERE `guid` = 183522;
DELETE FROM `creature_addon` WHERE `guid` = 183569;
DELETE FROM `creature_addon` WHERE `guid` = 183592;
DELETE FROM `creature_addon` WHERE `guid` = 183662;
DELETE FROM `creature_addon` WHERE `guid` = 183677;
DELETE FROM `creature_addon` WHERE `guid` = 183698;
DELETE FROM `creature_addon` WHERE `guid` = 183815;
DELETE FROM `creature_addon` WHERE `guid` = 183825;
DELETE FROM `creature_addon` WHERE `guid` = 183829;
DELETE FROM `creature_addon` WHERE `guid` = 184485;
DELETE FROM `creature_addon` WHERE `guid` = 184487;
DELETE FROM `creature_addon` WHERE `guid` = 184501;
DELETE FROM `creature_addon` WHERE `guid` = 184504;
DELETE FROM `creature_addon` WHERE `guid` = 184600;
DELETE FROM `creature_addon` WHERE `guid` = 184602;
DELETE FROM `creature_addon` WHERE `guid` = 184603;
DELETE FROM `creature_addon` WHERE `guid` = 184653;
DELETE FROM `creature_addon` WHERE `guid` = 184655;
DELETE FROM `creature_addon` WHERE `guid` = 184667;
DELETE FROM `creature_addon` WHERE `guid` = 184675;
DELETE FROM `creature_addon` WHERE `guid` = 184768;
DELETE FROM `creature_addon` WHERE `guid` = 184769;
DELETE FROM `creature_addon` WHERE `guid` = 184890;
DELETE FROM `creature_addon` WHERE `guid` = 184896;
DELETE FROM `creature_addon` WHERE `guid` = 184898;
DELETE FROM `creature_addon` WHERE `guid` = 184904;
DELETE FROM `creature_addon` WHERE `guid` = 184908;
DELETE FROM `creature_addon` WHERE `guid` = 184928;
DELETE FROM `creature_addon` WHERE `guid` = 184931;
DELETE FROM `creature_addon` WHERE `guid` = 184934;
DELETE FROM `creature_addon` WHERE `guid` = 184935;
DELETE FROM `creature_addon` WHERE `guid` = 184946;
DELETE FROM `creature_addon` WHERE `guid` = 184948;
DELETE FROM `creature_addon` WHERE `guid` = 184949;
DELETE FROM `creature_addon` WHERE `guid` = 184953;
DELETE FROM `creature_addon` WHERE `guid` = 184954;
DELETE FROM `creature_addon` WHERE `guid` = 185545;
DELETE FROM `creature_addon` WHERE `guid` = 185546;
DELETE FROM `creature_addon` WHERE `guid` = 185559;
DELETE FROM `creature_addon` WHERE `guid` = 185560;
DELETE FROM `creature_addon` WHERE `guid` = 185561;
DELETE FROM `creature_addon` WHERE `guid` = 185562;
DELETE FROM `creature_addon` WHERE `guid` = 185575;
DELETE FROM `creature_addon` WHERE `guid` = 185873;
DELETE FROM `creature_addon` WHERE `guid` = 185874;
DELETE FROM `creature_addon` WHERE `guid` = 185887;
DELETE FROM `creature_addon` WHERE `guid` = 185888;
DELETE FROM `creature_addon` WHERE `guid` = 185891;
DELETE FROM `creature_addon` WHERE `guid` = 185894;
DELETE FROM `creature_addon` WHERE `guid` = 185895;
DELETE FROM `creature_addon` WHERE `guid` = 185931;
DELETE FROM `creature_addon` WHERE `guid` = 185936;
DELETE FROM `creature_addon` WHERE `guid` = 185958;
DELETE FROM `creature_addon` WHERE `guid` = 185959;
DELETE FROM `creature_addon` WHERE `guid` = 185993;
DELETE FROM `creature_addon` WHERE `guid` = 185997;
DELETE FROM `creature_addon` WHERE `guid` = 186046;
DELETE FROM `creature_addon` WHERE `guid` = 186100;
DELETE FROM `creature_addon` WHERE `guid` = 186101;
DELETE FROM `creature_addon` WHERE `guid` = 186103;
DELETE FROM `creature_addon` WHERE `guid` = 186105;
DELETE FROM `creature_addon` WHERE `guid` = 186125;
DELETE FROM `creature_addon` WHERE `guid` = 186126;
DELETE FROM `creature_addon` WHERE `guid` = 186252;
DELETE FROM `creature_addon` WHERE `guid` = 186253;
DELETE FROM `creature_addon` WHERE `guid` = 186254;
DELETE FROM `creature_addon` WHERE `guid` = 186340;
DELETE FROM `creature_addon` WHERE `guid` = 186342;
DELETE FROM `creature_addon` WHERE `guid` = 186372;
DELETE FROM `creature_addon` WHERE `guid` = 186373;
DELETE FROM `creature_addon` WHERE `guid` = 186382;
DELETE FROM `creature_addon` WHERE `guid` = 186383;
DELETE FROM `creature_addon` WHERE `guid` = 186384;
DELETE FROM `creature_addon` WHERE `guid` = 186432;
DELETE FROM `creature_addon` WHERE `guid` = 186458;
DELETE FROM `creature_addon` WHERE `guid` = 186461;
DELETE FROM `creature_addon` WHERE `guid` = 186466;
DELETE FROM `creature_addon` WHERE `guid` = 186471;
DELETE FROM `creature_addon` WHERE `guid` = 186474;
DELETE FROM `creature_addon` WHERE `guid` = 186475;
DELETE FROM `creature_addon` WHERE `guid` = 186508;
DELETE FROM `creature_addon` WHERE `guid` = 186538;
DELETE FROM `creature_addon` WHERE `guid` = 186539;
DELETE FROM `creature_addon` WHERE `guid` = 186550;
DELETE FROM `creature_addon` WHERE `guid` = 186552;
DELETE FROM `creature_addon` WHERE `guid` = 186745;
DELETE FROM `creature_addon` WHERE `guid` = 186746;
DELETE FROM `creature_addon` WHERE `guid` = 186869;
DELETE FROM `creature_addon` WHERE `guid` = 186870;
DELETE FROM `creature_addon` WHERE `guid` = 186871;
DELETE FROM `creature_addon` WHERE `guid` = 186872;
DELETE FROM `creature_addon` WHERE `guid` = 186873;
DELETE FROM `creature_addon` WHERE `guid` = 186874;
DELETE FROM `creature_addon` WHERE `guid` = 186875;
DELETE FROM `creature_addon` WHERE `guid` = 187006;
DELETE FROM `creature_addon` WHERE `guid` = 187042;
DELETE FROM `creature_addon` WHERE `guid` = 187046;
DELETE FROM `creature_addon` WHERE `guid` = 187051;
DELETE FROM `creature_addon` WHERE `guid` = 187213;
DELETE FROM `creature_addon` WHERE `guid` = 187245;
DELETE FROM `creature_addon` WHERE `guid` = 187272;
DELETE FROM `creature_addon` WHERE `guid` = 187328;
DELETE FROM `creature_addon` WHERE `guid` = 187402;
DELETE FROM `creature_addon` WHERE `guid` = 187403;
DELETE FROM `creature_addon` WHERE `guid` = 187405;
DELETE FROM `creature_addon` WHERE `guid` = 187406;
DELETE FROM `creature_addon` WHERE `guid` = 187408;
DELETE FROM `creature_addon` WHERE `guid` = 187412;
DELETE FROM `creature_addon` WHERE `guid` = 187413;
DELETE FROM `creature_addon` WHERE `guid` = 187415;
DELETE FROM `creature_addon` WHERE `guid` = 187417;
DELETE FROM `creature_addon` WHERE `guid` = 187759;
DELETE FROM `creature_addon` WHERE `guid` = 187771;
DELETE FROM `creature_addon` WHERE `guid` = 187772;
DELETE FROM `creature_addon` WHERE `guid` = 187838;
DELETE FROM `creature_addon` WHERE `guid` = 187840;
DELETE FROM `creature_addon` WHERE `guid` = 187843;
DELETE FROM `creature_addon` WHERE `guid` = 187845;
DELETE FROM `creature_addon` WHERE `guid` = 187870;
DELETE FROM `creature_addon` WHERE `guid` = 187904;
DELETE FROM `creature_addon` WHERE `guid` = 187918;
DELETE FROM `creature_addon` WHERE `guid` = 187919;
DELETE FROM `creature_addon` WHERE `guid` = 187920;
DELETE FROM `creature_addon` WHERE `guid` = 187925;
DELETE FROM `creature_addon` WHERE `guid` = 187939;
DELETE FROM `creature_addon` WHERE `guid` = 187956;
DELETE FROM `creature_addon` WHERE `guid` = 187982;
DELETE FROM `creature_addon` WHERE `guid` = 188053;
DELETE FROM `creature_addon` WHERE `guid` = 188114;
DELETE FROM `creature_addon` WHERE `guid` = 188118;
DELETE FROM `creature_addon` WHERE `guid` = 188119;
DELETE FROM `creature_addon` WHERE `guid` = 188121;
DELETE FROM `creature_addon` WHERE `guid` = 188198;
DELETE FROM `creature_addon` WHERE `guid` = 188204;
DELETE FROM `creature_addon` WHERE `guid` = 188441;
DELETE FROM `creature_addon` WHERE `guid` = 188565;
DELETE FROM `creature_addon` WHERE `guid` = 188568;
DELETE FROM `creature_addon` WHERE `guid` = 188569;
DELETE FROM `creature_addon` WHERE `guid` = 188575;
DELETE FROM `creature_addon` WHERE `guid` = 188579;
DELETE FROM `creature_addon` WHERE `guid` = 188599;
DELETE FROM `creature_addon` WHERE `guid` = 188606;
DELETE FROM `creature_addon` WHERE `guid` = 188608;
DELETE FROM `creature_addon` WHERE `guid` = 189245;
DELETE FROM `creature_addon` WHERE `guid` = 189246;
DELETE FROM `creature_addon` WHERE `guid` = 189247;
DELETE FROM `creature_addon` WHERE `guid` = 189248;
DELETE FROM `creature_addon` WHERE `guid` = 189249;
DELETE FROM `creature_addon` WHERE `guid` = 189250;
DELETE FROM `creature_addon` WHERE `guid` = 189251;
DELETE FROM `creature_addon` WHERE `guid` = 189252;
DELETE FROM `creature_addon` WHERE `guid` = 189253;
DELETE FROM `creature_addon` WHERE `guid` = 189254;
DELETE FROM `creature_addon` WHERE `guid` = 189255;
DELETE FROM `creature_addon` WHERE `guid` = 189256;
DELETE FROM `creature_addon` WHERE `guid` = 189258;
DELETE FROM `creature_addon` WHERE `guid` = 189259;
DELETE FROM `creature_addon` WHERE `guid` = 189260;
DELETE FROM `creature_addon` WHERE `guid` = 189261;
DELETE FROM `creature_addon` WHERE `guid` = 189263;
DELETE FROM `creature_addon` WHERE `guid` = 189264;
DELETE FROM `creature_addon` WHERE `guid` = 189265;
DELETE FROM `creature_addon` WHERE `guid` = 189266;
DELETE FROM `creature_addon` WHERE `guid` = 189267;
DELETE FROM `creature_addon` WHERE `guid` = 189268;
DELETE FROM `creature_addon` WHERE `guid` = 189269;
DELETE FROM `creature_addon` WHERE `guid` = 189270;
DELETE FROM `creature_addon` WHERE `guid` = 189271;
DELETE FROM `creature_addon` WHERE `guid` = 189273;
DELETE FROM `creature_addon` WHERE `guid` = 189283;
DELETE FROM `creature_addon` WHERE `guid` = 189284;
DELETE FROM `creature_addon` WHERE `guid` = 189289;
DELETE FROM `creature_addon` WHERE `guid` = 189291;
DELETE FROM `creature_addon` WHERE `guid` = 189318;
DELETE FROM `creature_addon` WHERE `guid` = 189319;
DELETE FROM `creature_addon` WHERE `guid` = 189320;
DELETE FROM `creature_addon` WHERE `guid` = 189321;
DELETE FROM `creature_addon` WHERE `guid` = 189322;
DELETE FROM `creature_addon` WHERE `guid` = 189323;
DELETE FROM `creature_addon` WHERE `guid` = 189328;
DELETE FROM `creature_addon` WHERE `guid` = 189329;
DELETE FROM `creature_addon` WHERE `guid` = 189338;
DELETE FROM `creature_addon` WHERE `guid` = 189339;
DELETE FROM `creature_addon` WHERE `guid` = 189345;
DELETE FROM `creature_addon` WHERE `guid` = 189346;
DELETE FROM `creature_addon` WHERE `guid` = 189347;
DELETE FROM `creature_addon` WHERE `guid` = 189348;
DELETE FROM `creature_addon` WHERE `guid` = 189349;
DELETE FROM `creature_addon` WHERE `guid` = 189350;
DELETE FROM `creature_addon` WHERE `guid` = 189351;
DELETE FROM `creature_addon` WHERE `guid` = 189352;
DELETE FROM `creature_addon` WHERE `guid` = 189353;
DELETE FROM `creature_addon` WHERE `guid` = 189354;
DELETE FROM `creature_addon` WHERE `guid` = 189355;
DELETE FROM `creature_addon` WHERE `guid` = 189356;
DELETE FROM `creature_addon` WHERE `guid` = 189357;
DELETE FROM `creature_addon` WHERE `guid` = 189358;
DELETE FROM `creature_addon` WHERE `guid` = 189359;
DELETE FROM `creature_addon` WHERE `guid` = 189360;
DELETE FROM `creature_addon` WHERE `guid` = 189361;
DELETE FROM `creature_addon` WHERE `guid` = 189364;
DELETE FROM `creature_addon` WHERE `guid` = 189365;
DELETE FROM `creature_addon` WHERE `guid` = 189366;
DELETE FROM `creature_addon` WHERE `guid` = 189367;
DELETE FROM `creature_addon` WHERE `guid` = 189368;
DELETE FROM `creature_addon` WHERE `guid` = 189369;
DELETE FROM `creature_addon` WHERE `guid` = 189370;
DELETE FROM `creature_addon` WHERE `guid` = 189371;
DELETE FROM `creature_addon` WHERE `guid` = 189373;
DELETE FROM `creature_addon` WHERE `guid` = 189374;
DELETE FROM `creature_addon` WHERE `guid` = 189375;
DELETE FROM `creature_addon` WHERE `guid` = 189376;
DELETE FROM `creature_addon` WHERE `guid` = 189377;
DELETE FROM `creature_addon` WHERE `guid` = 189378;
DELETE FROM `creature_addon` WHERE `guid` = 189379;
DELETE FROM `creature_addon` WHERE `guid` = 189380;
DELETE FROM `creature_addon` WHERE `guid` = 189383;
DELETE FROM `creature_addon` WHERE `guid` = 189384;
DELETE FROM `creature_addon` WHERE `guid` = 189385;
DELETE FROM `creature_addon` WHERE `guid` = 189386;
DELETE FROM `creature_addon` WHERE `guid` = 189387;
DELETE FROM `creature_addon` WHERE `guid` = 189388;
DELETE FROM `creature_addon` WHERE `guid` = 189391;
DELETE FROM `creature_addon` WHERE `guid` = 189392;
DELETE FROM `creature_addon` WHERE `guid` = 189393;
DELETE FROM `creature_addon` WHERE `guid` = 189394;
DELETE FROM `creature_addon` WHERE `guid` = 189395;
DELETE FROM `creature_addon` WHERE `guid` = 189396;
DELETE FROM `creature_addon` WHERE `guid` = 189461;
DELETE FROM `creature_addon` WHERE `guid` = 189462;
DELETE FROM `creature_addon` WHERE `guid` = 189463;
DELETE FROM `creature_addon` WHERE `guid` = 189464;
DELETE FROM `creature_addon` WHERE `guid` = 189466;
DELETE FROM `creature_addon` WHERE `guid` = 189467;
DELETE FROM `creature_addon` WHERE `guid` = 189470;
DELETE FROM `creature_addon` WHERE `guid` = 189471;
DELETE FROM `creature_addon` WHERE `guid` = 189476;
DELETE FROM `creature_addon` WHERE `guid` = 189477;
DELETE FROM `creature_addon` WHERE `guid` = 189481;
DELETE FROM `creature_addon` WHERE `guid` = 189482;
DELETE FROM `creature_addon` WHERE `guid` = 189485;
DELETE FROM `creature_addon` WHERE `guid` = 189486;
DELETE FROM `creature_addon` WHERE `guid` = 189487;
DELETE FROM `creature_addon` WHERE `guid` = 189488;
DELETE FROM `creature_addon` WHERE `guid` = 189489;
DELETE FROM `creature_addon` WHERE `guid` = 189490;
DELETE FROM `creature_addon` WHERE `guid` = 189491;
DELETE FROM `creature_addon` WHERE `guid` = 189492;
DELETE FROM `creature_addon` WHERE `guid` = 189493;
DELETE FROM `creature_addon` WHERE `guid` = 189494;
DELETE FROM `creature_addon` WHERE `guid` = 189495;
DELETE FROM `creature_addon` WHERE `guid` = 189496;
DELETE FROM `creature_addon` WHERE `guid` = 189497;
DELETE FROM `creature_addon` WHERE `guid` = 189500;
DELETE FROM `creature_addon` WHERE `guid` = 189606;
DELETE FROM `creature_addon` WHERE `guid` = 189607;
DELETE FROM `creature_addon` WHERE `guid` = 189609;
DELETE FROM `creature_addon` WHERE `guid` = 189610;
DELETE FROM `creature_addon` WHERE `guid` = 189671;
DELETE FROM `creature_addon` WHERE `guid` = 189672;
DELETE FROM `creature_addon` WHERE `guid` = 189673;
DELETE FROM `creature_addon` WHERE `guid` = 189674;
DELETE FROM `creature_addon` WHERE `guid` = 189675;
DELETE FROM `creature_addon` WHERE `guid` = 189676;
DELETE FROM `creature_addon` WHERE `guid` = 189677;
DELETE FROM `creature_addon` WHERE `guid` = 189678;
DELETE FROM `creature_addon` WHERE `guid` = 189679;
DELETE FROM `creature_addon` WHERE `guid` = 189680;
DELETE FROM `creature_addon` WHERE `guid` = 189681;
DELETE FROM `creature_addon` WHERE `guid` = 189688;
DELETE FROM `creature_addon` WHERE `guid` = 189701;
DELETE FROM `creature_addon` WHERE `guid` = 189702;
DELETE FROM `creature_addon` WHERE `guid` = 189703;
DELETE FROM `creature_addon` WHERE `guid` = 189704;
DELETE FROM `creature_addon` WHERE `guid` = 189705;
DELETE FROM `creature_addon` WHERE `guid` = 189706;
DELETE FROM `creature_addon` WHERE `guid` = 189707;
DELETE FROM `creature_addon` WHERE `guid` = 189708;
DELETE FROM `creature_addon` WHERE `guid` = 189709;
DELETE FROM `creature_addon` WHERE `guid` = 189711;
DELETE FROM `creature_addon` WHERE `guid` = 189713;
DELETE FROM `creature_addon` WHERE `guid` = 189714;
DELETE FROM `creature_addon` WHERE `guid` = 189715;
DELETE FROM `creature_addon` WHERE `guid` = 189716;
DELETE FROM `creature_addon` WHERE `guid` = 189717;
DELETE FROM `creature_addon` WHERE `guid` = 189718;
DELETE FROM `creature_addon` WHERE `guid` = 189719;
DELETE FROM `creature_addon` WHERE `guid` = 189720;
DELETE FROM `creature_addon` WHERE `guid` = 189721;
DELETE FROM `creature_addon` WHERE `guid` = 189722;
DELETE FROM `creature_addon` WHERE `guid` = 189723;
DELETE FROM `creature_addon` WHERE `guid` = 189724;
DELETE FROM `creature_addon` WHERE `guid` = 189725;
DELETE FROM `creature_addon` WHERE `guid` = 189726;
DELETE FROM `creature_addon` WHERE `guid` = 189727;
DELETE FROM `creature_addon` WHERE `guid` = 189728;
DELETE FROM `creature_addon` WHERE `guid` = 189729;
DELETE FROM `creature_addon` WHERE `guid` = 189730;
DELETE FROM `creature_addon` WHERE `guid` = 189731;
DELETE FROM `creature_addon` WHERE `guid` = 189732;
DELETE FROM `creature_addon` WHERE `guid` = 189733;
DELETE FROM `creature_addon` WHERE `guid` = 189734;
DELETE FROM `creature_addon` WHERE `guid` = 189735;
DELETE FROM `creature_addon` WHERE `guid` = 189736;
DELETE FROM `creature_addon` WHERE `guid` = 189737;
DELETE FROM `creature_addon` WHERE `guid` = 189738;
DELETE FROM `creature_addon` WHERE `guid` = 189739;
DELETE FROM `creature_addon` WHERE `guid` = 189740;
DELETE FROM `creature_addon` WHERE `guid` = 189815;
DELETE FROM `creature_addon` WHERE `guid` = 189817;
DELETE FROM `creature_addon` WHERE `guid` = 189818;
DELETE FROM `creature_addon` WHERE `guid` = 189819;
DELETE FROM `creature_addon` WHERE `guid` = 189820;
DELETE FROM `creature_addon` WHERE `guid` = 189831;
DELETE FROM `creature_addon` WHERE `guid` = 189845;
DELETE FROM `creature_addon` WHERE `guid` = 189847;
DELETE FROM `creature_addon` WHERE `guid` = 189883;
DELETE FROM `creature_addon` WHERE `guid` = 189884;
DELETE FROM `creature_addon` WHERE `guid` = 189887;
DELETE FROM `creature_addon` WHERE `guid` = 189888;
DELETE FROM `creature_addon` WHERE `guid` = 189889;
DELETE FROM `creature_addon` WHERE `guid` = 189890;
DELETE FROM `creature_addon` WHERE `guid` = 189891;
DELETE FROM `creature_addon` WHERE `guid` = 189900;
DELETE FROM `creature_addon` WHERE `guid` = 189901;
DELETE FROM `creature_addon` WHERE `guid` = 189907;
DELETE FROM `creature_addon` WHERE `guid` = 189908;
DELETE FROM `creature_addon` WHERE `guid` = 190014;
DELETE FROM `creature_addon` WHERE `guid` = 190051;
DELETE FROM `creature_addon` WHERE `guid` = 190056;
DELETE FROM `creature_addon` WHERE `guid` = 190057;
DELETE FROM `creature_addon` WHERE `guid` = 190058;
DELETE FROM `creature_addon` WHERE `guid` = 190068;
DELETE FROM `creature_addon` WHERE `guid` = 190069;
DELETE FROM `creature_addon` WHERE `guid` = 190070;
DELETE FROM `creature_addon` WHERE `guid` = 190121;
DELETE FROM `creature_addon` WHERE `guid` = 190122;
DELETE FROM `creature_addon` WHERE `guid` = 190125;
DELETE FROM `creature_addon` WHERE `guid` = 190126;
DELETE FROM `creature_addon` WHERE `guid` = 190136;
DELETE FROM `creature_addon` WHERE `guid` = 190137;
DELETE FROM `creature_addon` WHERE `guid` = 190138;
DELETE FROM `creature_addon` WHERE `guid` = 190139;
DELETE FROM `creature_addon` WHERE `guid` = 190142;
DELETE FROM `creature_addon` WHERE `guid` = 190143;
DELETE FROM `creature_addon` WHERE `guid` = 190148;
DELETE FROM `creature_addon` WHERE `guid` = 190149;
DELETE FROM `creature_addon` WHERE `guid` = 190160;
DELETE FROM `creature_addon` WHERE `guid` = 190161;
DELETE FROM `creature_addon` WHERE `guid` = 190163;
DELETE FROM `creature_addon` WHERE `guid` = 190164;
DELETE FROM `creature_addon` WHERE `guid` = 190165;
DELETE FROM `creature_addon` WHERE `guid` = 190166;
DELETE FROM `creature_addon` WHERE `guid` = 190167;
DELETE FROM `creature_addon` WHERE `guid` = 190233;
DELETE FROM `creature_addon` WHERE `guid` = 190236;
DELETE FROM `creature_addon` WHERE `guid` = 190251;
DELETE FROM `creature_addon` WHERE `guid` = 190252;
DELETE FROM `creature_addon` WHERE `guid` = 190258;
DELETE FROM `creature_addon` WHERE `guid` = 190259;
DELETE FROM `creature_addon` WHERE `guid` = 190316;
DELETE FROM `creature_addon` WHERE `guid` = 190317;
DELETE FROM `creature_addon` WHERE `guid` = 190336;
DELETE FROM `creature_addon` WHERE `guid` = 190337;
DELETE FROM `creature_addon` WHERE `guid` = 190340;
DELETE FROM `creature_addon` WHERE `guid` = 190341;
DELETE FROM `creature_addon` WHERE `guid` = 190348;
DELETE FROM `creature_addon` WHERE `guid` = 190353;
DELETE FROM `creature_addon` WHERE `guid` = 190354;
DELETE FROM `creature_addon` WHERE `guid` = 190355;
DELETE FROM `creature_addon` WHERE `guid` = 190358;
DELETE FROM `creature_addon` WHERE `guid` = 190361;
DELETE FROM `creature_addon` WHERE `guid` = 190367;
DELETE FROM `creature_addon` WHERE `guid` = 190368;
DELETE FROM `creature_addon` WHERE `guid` = 190373;
DELETE FROM `creature_addon` WHERE `guid` = 190374;
DELETE FROM `creature_addon` WHERE `guid` = 190394;
DELETE FROM `creature_addon` WHERE `guid` = 190397;
DELETE FROM `creature_addon` WHERE `guid` = 190503;
DELETE FROM `creature_addon` WHERE `guid` = 190505;
DELETE FROM `creature_addon` WHERE `guid` = 190506;
DELETE FROM `creature_addon` WHERE `guid` = 190507;
DELETE FROM `creature_addon` WHERE `guid` = 190508;
DELETE FROM `creature_addon` WHERE `guid` = 190509;
DELETE FROM `creature_addon` WHERE `guid` = 190557;
DELETE FROM `creature_addon` WHERE `guid` = 190558;
DELETE FROM `creature_addon` WHERE `guid` = 190559;
DELETE FROM `creature_addon` WHERE `guid` = 190560;
DELETE FROM `creature_addon` WHERE `guid` = 190561;
DELETE FROM `creature_addon` WHERE `guid` = 190562;
DELETE FROM `creature_addon` WHERE `guid` = 190566;
DELETE FROM `creature_addon` WHERE `guid` = 190567;
DELETE FROM `creature_addon` WHERE `guid` = 190568;
DELETE FROM `creature_addon` WHERE `guid` = 190569;
DELETE FROM `creature_addon` WHERE `guid` = 190570;
DELETE FROM `creature_addon` WHERE `guid` = 190571;
DELETE FROM `creature_addon` WHERE `guid` = 190572;
DELETE FROM `creature_addon` WHERE `guid` = 190573;
DELETE FROM `creature_addon` WHERE `guid` = 190574;
DELETE FROM `creature_addon` WHERE `guid` = 190575;
DELETE FROM `creature_addon` WHERE `guid` = 190576;
DELETE FROM `creature_addon` WHERE `guid` = 190577;
DELETE FROM `creature_addon` WHERE `guid` = 190580;
DELETE FROM `creature_addon` WHERE `guid` = 190581;
DELETE FROM `creature_addon` WHERE `guid` = 190583;
DELETE FROM `creature_addon` WHERE `guid` = 190585;
DELETE FROM `creature_addon` WHERE `guid` = 190586;
DELETE FROM `creature_addon` WHERE `guid` = 190609;
DELETE FROM `creature_addon` WHERE `guid` = 190611;
DELETE FROM `creature_addon` WHERE `guid` = 190613;
DELETE FROM `creature_addon` WHERE `guid` = 190614;
DELETE FROM `creature_addon` WHERE `guid` = 190616;
DELETE FROM `creature_addon` WHERE `guid` = 190617;
DELETE FROM `creature_addon` WHERE `guid` = 190618;
DELETE FROM `creature_addon` WHERE `guid` = 190622;
DELETE FROM `creature_addon` WHERE `guid` = 190623;
DELETE FROM `creature_addon` WHERE `guid` = 190751;
DELETE FROM `creature_addon` WHERE `guid` = 190766;
DELETE FROM `creature_addon` WHERE `guid` = 190816;
DELETE FROM `creature_addon` WHERE `guid` = 190819;
DELETE FROM `creature_addon` WHERE `guid` = 190836;
DELETE FROM `creature_addon` WHERE `guid` = 190845;
DELETE FROM `creature_addon` WHERE `guid` = 190851;
DELETE FROM `creature_addon` WHERE `guid` = 190853;
DELETE FROM `creature_addon` WHERE `guid` = 190858;
DELETE FROM `creature_addon` WHERE `guid` = 190859;
DELETE FROM `creature_addon` WHERE `guid` = 190860;
DELETE FROM `creature_addon` WHERE `guid` = 190861;
DELETE FROM `creature_addon` WHERE `guid` = 190862;
DELETE FROM `creature_addon` WHERE `guid` = 190863;
DELETE FROM `creature_addon` WHERE `guid` = 190864;
DELETE FROM `creature_addon` WHERE `guid` = 190865;
DELETE FROM `creature_addon` WHERE `guid` = 190866;
DELETE FROM `creature_addon` WHERE `guid` = 190872;
DELETE FROM `creature_addon` WHERE `guid` = 190879;
DELETE FROM `creature_addon` WHERE `guid` = 190880;
DELETE FROM `creature_addon` WHERE `guid` = 190881;
DELETE FROM `creature_addon` WHERE `guid` = 190882;
DELETE FROM `creature_addon` WHERE `guid` = 190883;
DELETE FROM `creature_addon` WHERE `guid` = 190884;
DELETE FROM `creature_addon` WHERE `guid` = 190885;
DELETE FROM `creature_addon` WHERE `guid` = 190886;
DELETE FROM `creature_addon` WHERE `guid` = 190888;
DELETE FROM `creature_addon` WHERE `guid` = 190889;
DELETE FROM `creature_addon` WHERE `guid` = 190890;
DELETE FROM `creature_addon` WHERE `guid` = 190891;
DELETE FROM `creature_addon` WHERE `guid` = 190892;
DELETE FROM `creature_addon` WHERE `guid` = 190893;
DELETE FROM `creature_addon` WHERE `guid` = 190894;
DELETE FROM `creature_addon` WHERE `guid` = 190895;
DELETE FROM `creature_addon` WHERE `guid` = 190896;
DELETE FROM `creature_addon` WHERE `guid` = 190897;
DELETE FROM `creature_addon` WHERE `guid` = 190910;
DELETE FROM `creature_addon` WHERE `guid` = 190920;
DELETE FROM `creature_addon` WHERE `guid` = 190942;
DELETE FROM `creature_addon` WHERE `guid` = 191227;
DELETE FROM `creature_addon` WHERE `guid` = 191231;
DELETE FROM `creature_addon` WHERE `guid` = 191394;
DELETE FROM `creature_addon` WHERE `guid` = 191395;
DELETE FROM `creature_addon` WHERE `guid` = 191396;
DELETE FROM `creature_addon` WHERE `guid` = 191397;
DELETE FROM `creature_addon` WHERE `guid` = 191398;
DELETE FROM `creature_addon` WHERE `guid` = 191399;
DELETE FROM `creature_addon` WHERE `guid` = 191400;
DELETE FROM `creature_addon` WHERE `guid` = 191634;
DELETE FROM `creature_addon` WHERE `guid` = 191635;
DELETE FROM `creature_addon` WHERE `guid` = 191655;
DELETE FROM `creature_addon` WHERE `guid` = 191656;
DELETE FROM `creature_addon` WHERE `guid` = 191692;
DELETE FROM `creature_addon` WHERE `guid` = 191694;
DELETE FROM `creature_addon` WHERE `guid` = 191699;
DELETE FROM `creature_addon` WHERE `guid` = 191711;
DELETE FROM `creature_addon` WHERE `guid` = 191714;
DELETE FROM `creature_addon` WHERE `guid` = 191715;
DELETE FROM `creature_addon` WHERE `guid` = 191718;
DELETE FROM `creature_addon` WHERE `guid` = 191722;
DELETE FROM `creature_addon` WHERE `guid` = 191724;
DELETE FROM `creature_addon` WHERE `guid` = 191729;
DELETE FROM `creature_addon` WHERE `guid` = 191730;
DELETE FROM `creature_addon` WHERE `guid` = 191731;
DELETE FROM `creature_addon` WHERE `guid` = 191734;
DELETE FROM `creature_addon` WHERE `guid` = 191742;
DELETE FROM `creature_addon` WHERE `guid` = 191743;
DELETE FROM `creature_addon` WHERE `guid` = 191746;
DELETE FROM `creature_addon` WHERE `guid` = 191750;
DELETE FROM `creature_addon` WHERE `guid` = 191826;
DELETE FROM `creature_addon` WHERE `guid` = 191829;
DELETE FROM `creature_addon` WHERE `guid` = 191830;
DELETE FROM `creature_addon` WHERE `guid` = 191831;
DELETE FROM `creature_addon` WHERE `guid` = 191842;
DELETE FROM `creature_addon` WHERE `guid` = 191843;
DELETE FROM `creature_addon` WHERE `guid` = 191884;
DELETE FROM `creature_addon` WHERE `guid` = 191906;
DELETE FROM `creature_addon` WHERE `guid` = 191907;
DELETE FROM `creature_addon` WHERE `guid` = 191912;
DELETE FROM `creature_addon` WHERE `guid` = 191916;
DELETE FROM `creature_addon` WHERE `guid` = 191922;
DELETE FROM `creature_addon` WHERE `guid` = 191925;
DELETE FROM `creature_addon` WHERE `guid` = 191926;
DELETE FROM `creature_addon` WHERE `guid` = 191931;
DELETE FROM `creature_addon` WHERE `guid` = 191932;
DELETE FROM `creature_addon` WHERE `guid` = 191999;
DELETE FROM `creature_addon` WHERE `guid` = 192228;
DELETE FROM `creature_addon` WHERE `guid` = 192235;
DELETE FROM `creature_addon` WHERE `guid` = 192509;
DELETE FROM `creature_addon` WHERE `guid` = 192518;
DELETE FROM `creature_addon` WHERE `guid` = 192608;
DELETE FROM `creature_addon` WHERE `guid` = 192611;
DELETE FROM `creature_addon` WHERE `guid` = 192612;
DELETE FROM `creature_addon` WHERE `guid` = 192624;
DELETE FROM `creature_addon` WHERE `guid` = 192625;
DELETE FROM `creature_addon` WHERE `guid` = 192626;
DELETE FROM `creature_addon` WHERE `guid` = 192627;
DELETE FROM `creature_addon` WHERE `guid` = 192628;
DELETE FROM `creature_addon` WHERE `guid` = 192629;
DELETE FROM `creature_addon` WHERE `guid` = 192631;
DELETE FROM `creature_addon` WHERE `guid` = 192632;
DELETE FROM `creature_addon` WHERE `guid` = 192633;
DELETE FROM `creature_addon` WHERE `guid` = 192634;
DELETE FROM `creature_addon` WHERE `guid` = 192636;
DELETE FROM `creature_addon` WHERE `guid` = 192672;
DELETE FROM `creature_addon` WHERE `guid` = 192673;
DELETE FROM `creature_addon` WHERE `guid` = 192692;
DELETE FROM `creature_addon` WHERE `guid` = 192693;
DELETE FROM `creature_addon` WHERE `guid` = 192694;
DELETE FROM `creature_addon` WHERE `guid` = 192762;
DELETE FROM `creature_addon` WHERE `guid` = 192763;
DELETE FROM `creature_addon` WHERE `guid` = 192764;
DELETE FROM `creature_addon` WHERE `guid` = 192765;
DELETE FROM `creature_addon` WHERE `guid` = 192766;
DELETE FROM `creature_addon` WHERE `guid` = 192767;
DELETE FROM `creature_addon` WHERE `guid` = 192768;
DELETE FROM `creature_addon` WHERE `guid` = 192769;
DELETE FROM `creature_addon` WHERE `guid` = 192770;
DELETE FROM `creature_addon` WHERE `guid` = 192771;
DELETE FROM `creature_addon` WHERE `guid` = 192776;
DELETE FROM `creature_addon` WHERE `guid` = 192777;
DELETE FROM `creature_addon` WHERE `guid` = 192778;
DELETE FROM `creature_addon` WHERE `guid` = 192779;
DELETE FROM `creature_addon` WHERE `guid` = 192780;
DELETE FROM `creature_addon` WHERE `guid` = 192781;
DELETE FROM `creature_addon` WHERE `guid` = 192782;
DELETE FROM `creature_addon` WHERE `guid` = 192783;
DELETE FROM `creature_addon` WHERE `guid` = 192784;
DELETE FROM `creature_addon` WHERE `guid` = 192785;
DELETE FROM `creature_addon` WHERE `guid` = 192805;
DELETE FROM `creature_addon` WHERE `guid` = 192806;
DELETE FROM `creature_addon` WHERE `guid` = 192995;
DELETE FROM `creature_addon` WHERE `guid` = 193027;
DELETE FROM `creature_addon` WHERE `guid` = 193028;
DELETE FROM `creature_addon` WHERE `guid` = 193029;
DELETE FROM `creature_addon` WHERE `guid` = 193030;
DELETE FROM `creature_addon` WHERE `guid` = 193031;
DELETE FROM `creature_addon` WHERE `guid` = 193032;
DELETE FROM `creature_addon` WHERE `guid` = 193033;
DELETE FROM `creature_addon` WHERE `guid` = 193034;
DELETE FROM `creature_addon` WHERE `guid` = 193035;
DELETE FROM `creature_addon` WHERE `guid` = 193049;
DELETE FROM `creature_addon` WHERE `guid` = 193057;
DELETE FROM `creature_addon` WHERE `guid` = 193058;
DELETE FROM `creature_addon` WHERE `guid` = 193067;
DELETE FROM `creature_addon` WHERE `guid` = 193068;
DELETE FROM `creature_addon` WHERE `guid` = 193072;
DELETE FROM `creature_addon` WHERE `guid` = 193073;
DELETE FROM `creature_addon` WHERE `guid` = 193081;
DELETE FROM `creature_addon` WHERE `guid` = 193082;
DELETE FROM `creature_addon` WHERE `guid` = 193095;
DELETE FROM `creature_addon` WHERE `guid` = 193096;
DELETE FROM `creature_addon` WHERE `guid` = 193097;
DELETE FROM `creature_addon` WHERE `guid` = 193098;
DELETE FROM `creature_addon` WHERE `guid` = 193111;
DELETE FROM `creature_addon` WHERE `guid` = 193112;
DELETE FROM `creature_addon` WHERE `guid` = 193113;
DELETE FROM `creature_addon` WHERE `guid` = 193124;
DELETE FROM `creature_addon` WHERE `guid` = 193125;
DELETE FROM `creature_addon` WHERE `guid` = 193126;
DELETE FROM `creature_addon` WHERE `guid` = 193134;
DELETE FROM `creature_addon` WHERE `guid` = 193176;
DELETE FROM `creature_addon` WHERE `guid` = 193178;
DELETE FROM `creature_addon` WHERE `guid` = 193180;
DELETE FROM `creature_addon` WHERE `guid` = 193182;
DELETE FROM `creature_addon` WHERE `guid` = 193184;
DELETE FROM `creature_addon` WHERE `guid` = 193186;
DELETE FROM `creature_addon` WHERE `guid` = 193807;
DELETE FROM `creature_addon` WHERE `guid` = 193808;
DELETE FROM `creature_addon` WHERE `guid` = 193874;
DELETE FROM `creature_addon` WHERE `guid` = 193876;
DELETE FROM `creature_addon` WHERE `guid` = 193877;
DELETE FROM `creature_addon` WHERE `guid` = 193878;
DELETE FROM `creature_addon` WHERE `guid` = 193912;
DELETE FROM `creature_addon` WHERE `guid` = 193913;
DELETE FROM `creature_addon` WHERE `guid` = 193984;
DELETE FROM `creature_addon` WHERE `guid` = 193985;
DELETE FROM `creature_addon` WHERE `guid` = 193995;
DELETE FROM `creature_addon` WHERE `guid` = 193996;
DELETE FROM `creature_addon` WHERE `guid` = 194039;
DELETE FROM `creature_addon` WHERE `guid` = 194058;
DELETE FROM `creature_addon` WHERE `guid` = 194059;
DELETE FROM `creature_addon` WHERE `guid` = 194060;
DELETE FROM `creature_addon` WHERE `guid` = 194061;
DELETE FROM `creature_addon` WHERE `guid` = 194068;
DELETE FROM `creature_addon` WHERE `guid` = 194077;
DELETE FROM `creature_addon` WHERE `guid` = 194078;
DELETE FROM `creature_addon` WHERE `guid` = 194079;
DELETE FROM `creature_addon` WHERE `guid` = 194080;
DELETE FROM `creature_addon` WHERE `guid` = 194081;
DELETE FROM `creature_addon` WHERE `guid` = 194082;
DELETE FROM `creature_addon` WHERE `guid` = 194095;
DELETE FROM `creature_addon` WHERE `guid` = 194096;
DELETE FROM `creature_addon` WHERE `guid` = 194097;
DELETE FROM `creature_addon` WHERE `guid` = 194098;
DELETE FROM `creature_addon` WHERE `guid` = 194099;
DELETE FROM `creature_addon` WHERE `guid` = 194100;
DELETE FROM `creature_addon` WHERE `guid` = 194101;
DELETE FROM `creature_addon` WHERE `guid` = 194102;
DELETE FROM `creature_addon` WHERE `guid` = 194160;
DELETE FROM `creature_addon` WHERE `guid` = 194161;
DELETE FROM `creature_addon` WHERE `guid` = 194162;
DELETE FROM `creature_addon` WHERE `guid` = 194164;
DELETE FROM `creature_addon` WHERE `guid` = 194165;
DELETE FROM `creature_addon` WHERE `guid` = 194168;
DELETE FROM `creature_addon` WHERE `guid` = 194169;
DELETE FROM `creature_addon` WHERE `guid` = 194171;
DELETE FROM `creature_addon` WHERE `guid` = 194172;
DELETE FROM `creature_addon` WHERE `guid` = 194175;
DELETE FROM `creature_addon` WHERE `guid` = 194177;
DELETE FROM `creature_addon` WHERE `guid` = 194178;
DELETE FROM `creature_addon` WHERE `guid` = 194186;
DELETE FROM `creature_addon` WHERE `guid` = 194322;
DELETE FROM `creature_addon` WHERE `guid` = 194642;
DELETE FROM `creature_addon` WHERE `guid` = 195411;
DELETE FROM `creature_addon` WHERE `guid` = 195412;
DELETE FROM `creature_addon` WHERE `guid` = 195413;
DELETE FROM `creature_addon` WHERE `guid` = 195414;
DELETE FROM `creature_addon` WHERE `guid` = 195564;
DELETE FROM `creature_addon` WHERE `guid` = 195576;
DELETE FROM `creature_addon` WHERE `guid` = 195577;
DELETE FROM `creature_addon` WHERE `guid` = 195578;
DELETE FROM `creature_addon` WHERE `guid` = 195579;
DELETE FROM `creature_addon` WHERE `guid` = 195613;
DELETE FROM `creature_addon` WHERE `guid` = 195622;
DELETE FROM `creature_addon` WHERE `guid` = 195671;
DELETE FROM `creature_addon` WHERE `guid` = 195672;
DELETE FROM `creature_addon` WHERE `guid` = 195686;
DELETE FROM `creature_addon` WHERE `guid` = 195688;
DELETE FROM `creature_addon` WHERE `guid` = 195689;
DELETE FROM `creature_addon` WHERE `guid` = 195705;
DELETE FROM `creature_addon` WHERE `guid` = 195733;
DELETE FROM `creature_addon` WHERE `guid` = 195781;
DELETE FROM `creature_addon` WHERE `guid` = 195931;
DELETE FROM `creature_addon` WHERE `guid` = 195932;
DELETE FROM `creature_addon` WHERE `guid` = 195933;
DELETE FROM `creature_addon` WHERE `guid` = 195934;
DELETE FROM `creature_addon` WHERE `guid` = 195940;
DELETE FROM `creature_addon` WHERE `guid` = 195941;
DELETE FROM `creature_addon` WHERE `guid` = 195942;
DELETE FROM `creature_addon` WHERE `guid` = 195943;
DELETE FROM `creature_addon` WHERE `guid` = 195944;
DELETE FROM `creature_addon` WHERE `guid` = 195946;
DELETE FROM `creature_addon` WHERE `guid` = 196055;
DELETE FROM `creature_addon` WHERE `guid` = 196058;
DELETE FROM `creature_addon` WHERE `guid` = 196066;
DELETE FROM `creature_addon` WHERE `guid` = 196067;
DELETE FROM `creature_addon` WHERE `guid` = 196343;
DELETE FROM `creature_addon` WHERE `guid` = 196344;
DELETE FROM `creature_addon` WHERE `guid` = 196407;
DELETE FROM `creature_addon` WHERE `guid` = 196445;
DELETE FROM `creature_addon` WHERE `guid` = 196447;
DELETE FROM `creature_addon` WHERE `guid` = 196449;
DELETE FROM `creature_addon` WHERE `guid` = 196511;
DELETE FROM `creature_addon` WHERE `guid` = 196513;
DELETE FROM `creature_addon` WHERE `guid` = 196529;
DELETE FROM `creature_addon` WHERE `guid` = 196540;
DELETE FROM `creature_addon` WHERE `guid` = 196541;
DELETE FROM `creature_addon` WHERE `guid` = 196552;
DELETE FROM `creature_addon` WHERE `guid` = 196623;
DELETE FROM `creature_addon` WHERE `guid` = 196624;
DELETE FROM `creature_addon` WHERE `guid` = 196625;
DELETE FROM `creature_addon` WHERE `guid` = 196626;
DELETE FROM `creature_addon` WHERE `guid` = 196627;
DELETE FROM `creature_addon` WHERE `guid` = 196628;
DELETE FROM `creature_addon` WHERE `guid` = 196629;
DELETE FROM `creature_addon` WHERE `guid` = 196630;
DELETE FROM `creature_addon` WHERE `guid` = 196631;
DELETE FROM `creature_addon` WHERE `guid` = 196632;
DELETE FROM `creature_addon` WHERE `guid` = 196633;
DELETE FROM `creature_addon` WHERE `guid` = 196634;
DELETE FROM `creature_addon` WHERE `guid` = 196637;
DELETE FROM `creature_addon` WHERE `guid` = 196643;
DELETE FROM `creature_addon` WHERE `guid` = 196736;
DELETE FROM `creature_addon` WHERE `guid` = 196739;
DELETE FROM `creature_addon` WHERE `guid` = 196749;
DELETE FROM `creature_addon` WHERE `guid` = 196762;
DELETE FROM `creature_addon` WHERE `guid` = 196789;
DELETE FROM `creature_addon` WHERE `guid` = 196790;
DELETE FROM `creature_addon` WHERE `guid` = 196798;
DELETE FROM `creature_addon` WHERE `guid` = 196799;
DELETE FROM `creature_addon` WHERE `guid` = 196805;
DELETE FROM `creature_addon` WHERE `guid` = 196808;
DELETE FROM `creature_addon` WHERE `guid` = 196812;
DELETE FROM `creature_addon` WHERE `guid` = 196813;
DELETE FROM `creature_addon` WHERE `guid` = 196816;
DELETE FROM `creature_addon` WHERE `guid` = 196817;
DELETE FROM `creature_addon` WHERE `guid` = 196818;
DELETE FROM `creature_addon` WHERE `guid` = 196819;
DELETE FROM `creature_addon` WHERE `guid` = 196820;
DELETE FROM `creature_addon` WHERE `guid` = 196821;
DELETE FROM `creature_addon` WHERE `guid` = 196822;
DELETE FROM `creature_addon` WHERE `guid` = 196823;
DELETE FROM `creature_addon` WHERE `guid` = 196824;
DELETE FROM `creature_addon` WHERE `guid` = 196831;
DELETE FROM `creature_addon` WHERE `guid` = 196832;
DELETE FROM `creature_addon` WHERE `guid` = 196833;
DELETE FROM `creature_addon` WHERE `guid` = 196879;
DELETE FROM `creature_addon` WHERE `guid` = 196881;
DELETE FROM `creature_addon` WHERE `guid` = 196883;
DELETE FROM `creature_addon` WHERE `guid` = 196889;
DELETE FROM `creature_addon` WHERE `guid` = 196892;
DELETE FROM `creature_addon` WHERE `guid` = 196893;
DELETE FROM `creature_addon` WHERE `guid` = 196894;
DELETE FROM `creature_addon` WHERE `guid` = 196979;
DELETE FROM `creature_addon` WHERE `guid` = 196980;
DELETE FROM `creature_addon` WHERE `guid` = 197036;
DELETE FROM `creature_addon` WHERE `guid` = 197039;
DELETE FROM `creature_addon` WHERE `guid` = 197040;
DELETE FROM `creature_addon` WHERE `guid` = 197041;
DELETE FROM `creature_addon` WHERE `guid` = 197045;
DELETE FROM `creature_addon` WHERE `guid` = 197048;
DELETE FROM `creature_addon` WHERE `guid` = 197049;
DELETE FROM `creature_addon` WHERE `guid` = 197050;
DELETE FROM `creature_addon` WHERE `guid` = 197051;
DELETE FROM `creature_addon` WHERE `guid` = 197052;
DELETE FROM `creature_addon` WHERE `guid` = 197053;
DELETE FROM `creature_addon` WHERE `guid` = 197054;
DELETE FROM `creature_addon` WHERE `guid` = 197055;
DELETE FROM `creature_addon` WHERE `guid` = 197056;
DELETE FROM `creature_addon` WHERE `guid` = 197057;
DELETE FROM `creature_addon` WHERE `guid` = 197058;
DELETE FROM `creature_addon` WHERE `guid` = 197059;
DELETE FROM `creature_addon` WHERE `guid` = 197060;
DELETE FROM `creature_addon` WHERE `guid` = 197061;
DELETE FROM `creature_addon` WHERE `guid` = 197062;
DELETE FROM `creature_addon` WHERE `guid` = 197063;
DELETE FROM `creature_addon` WHERE `guid` = 197064;
DELETE FROM `creature_addon` WHERE `guid` = 197065;
DELETE FROM `creature_addon` WHERE `guid` = 197066;
DELETE FROM `creature_addon` WHERE `guid` = 197067;
DELETE FROM `creature_addon` WHERE `guid` = 197068;
DELETE FROM `creature_addon` WHERE `guid` = 197069;
DELETE FROM `creature_addon` WHERE `guid` = 197070;
DELETE FROM `creature_addon` WHERE `guid` = 197071;
DELETE FROM `creature_addon` WHERE `guid` = 197072;
DELETE FROM `creature_addon` WHERE `guid` = 197073;
DELETE FROM `creature_addon` WHERE `guid` = 197074;
DELETE FROM `creature_addon` WHERE `guid` = 197075;
DELETE FROM `creature_addon` WHERE `guid` = 197076;
DELETE FROM `creature_addon` WHERE `guid` = 197077;
DELETE FROM `creature_addon` WHERE `guid` = 197078;
DELETE FROM `creature_addon` WHERE `guid` = 197081;
DELETE FROM `creature_addon` WHERE `guid` = 197096;
DELETE FROM `creature_addon` WHERE `guid` = 197097;
DELETE FROM `creature_addon` WHERE `guid` = 197102;
DELETE FROM `creature_addon` WHERE `guid` = 197103;
DELETE FROM `creature_addon` WHERE `guid` = 197106;
DELETE FROM `creature_addon` WHERE `guid` = 197107;
DELETE FROM `creature_addon` WHERE `guid` = 197108;
DELETE FROM `creature_addon` WHERE `guid` = 197109;
DELETE FROM `creature_addon` WHERE `guid` = 197112;
DELETE FROM `creature_addon` WHERE `guid` = 197113;
DELETE FROM `creature_addon` WHERE `guid` = 197177;
DELETE FROM `creature_addon` WHERE `guid` = 197179;
DELETE FROM `creature_addon` WHERE `guid` = 197181;
DELETE FROM `creature_addon` WHERE `guid` = 197188;
DELETE FROM `creature_addon` WHERE `guid` = 197190;
DELETE FROM `creature_addon` WHERE `guid` = 197191;
DELETE FROM `creature_addon` WHERE `guid` = 197193;
DELETE FROM `creature_addon` WHERE `guid` = 197194;
DELETE FROM `creature_addon` WHERE `guid` = 197195;
DELETE FROM `creature_addon` WHERE `guid` = 197196;
DELETE FROM `creature_addon` WHERE `guid` = 197197;
DELETE FROM `creature_addon` WHERE `guid` = 197200;
DELETE FROM `creature_addon` WHERE `guid` = 197205;
DELETE FROM `creature_addon` WHERE `guid` = 197208;
DELETE FROM `creature_addon` WHERE `guid` = 197209;
DELETE FROM `creature_addon` WHERE `guid` = 197210;
DELETE FROM `creature_addon` WHERE `guid` = 197211;
DELETE FROM `creature_addon` WHERE `guid` = 197212;
DELETE FROM `creature_addon` WHERE `guid` = 197213;
DELETE FROM `creature_addon` WHERE `guid` = 197214;
DELETE FROM `creature_addon` WHERE `guid` = 197216;
DELETE FROM `creature_addon` WHERE `guid` = 197217;
DELETE FROM `creature_addon` WHERE `guid` = 197220;
DELETE FROM `creature_addon` WHERE `guid` = 197221;
DELETE FROM `creature_addon` WHERE `guid` = 197222;
DELETE FROM `creature_addon` WHERE `guid` = 197223;
DELETE FROM `creature_addon` WHERE `guid` = 197226;
DELETE FROM `creature_addon` WHERE `guid` = 197227;
DELETE FROM `creature_addon` WHERE `guid` = 197229;
DELETE FROM `creature_addon` WHERE `guid` = 197230;
DELETE FROM `creature_addon` WHERE `guid` = 197231;
DELETE FROM `creature_addon` WHERE `guid` = 197234;
DELETE FROM `creature_addon` WHERE `guid` = 197235;
DELETE FROM `creature_addon` WHERE `guid` = 197239;
DELETE FROM `creature_addon` WHERE `guid` = 197243;
DELETE FROM `creature_addon` WHERE `guid` = 197245;
DELETE FROM `creature_addon` WHERE `guid` = 197246;
DELETE FROM `creature_addon` WHERE `guid` = 197250;
DELETE FROM `creature_addon` WHERE `guid` = 197294;
DELETE FROM `creature_addon` WHERE `guid` = 197295;
DELETE FROM `creature_addon` WHERE `guid` = 197296;
DELETE FROM `creature_addon` WHERE `guid` = 197297;
DELETE FROM `creature_addon` WHERE `guid` = 197298;
DELETE FROM `creature_addon` WHERE `guid` = 197300;
DELETE FROM `creature_addon` WHERE `guid` = 197301;
DELETE FROM `creature_addon` WHERE `guid` = 197302;
DELETE FROM `creature_addon` WHERE `guid` = 197314;
DELETE FROM `creature_addon` WHERE `guid` = 197315;
DELETE FROM `creature_addon` WHERE `guid` = 197317;
DELETE FROM `creature_addon` WHERE `guid` = 197329;
DELETE FROM `creature_addon` WHERE `guid` = 197336;
DELETE FROM `creature_addon` WHERE `guid` = 197343;
DELETE FROM `creature_addon` WHERE `guid` = 197344;
DELETE FROM `creature_addon` WHERE `guid` = 197351;
DELETE FROM `creature_addon` WHERE `guid` = 197352;
DELETE FROM `creature_addon` WHERE `guid` = 197353;
DELETE FROM `creature_addon` WHERE `guid` = 197354;
DELETE FROM `creature_addon` WHERE `guid` = 197355;
DELETE FROM `creature_addon` WHERE `guid` = 197356;
DELETE FROM `creature_addon` WHERE `guid` = 197357;
DELETE FROM `creature_addon` WHERE `guid` = 197358;
DELETE FROM `creature_addon` WHERE `guid` = 197359;
DELETE FROM `creature_addon` WHERE `guid` = 197360;
DELETE FROM `creature_addon` WHERE `guid` = 197361;
DELETE FROM `creature_addon` WHERE `guid` = 197362;
DELETE FROM `creature_addon` WHERE `guid` = 197363;
DELETE FROM `creature_addon` WHERE `guid` = 197364;
DELETE FROM `creature_addon` WHERE `guid` = 197365;
DELETE FROM `creature_addon` WHERE `guid` = 197376;
DELETE FROM `creature_addon` WHERE `guid` = 197380;
DELETE FROM `creature_addon` WHERE `guid` = 197385;
DELETE FROM `creature_addon` WHERE `guid` = 197386;
DELETE FROM `creature_addon` WHERE `guid` = 197387;
DELETE FROM `creature_addon` WHERE `guid` = 197390;
DELETE FROM `creature_addon` WHERE `guid` = 197405;
DELETE FROM `creature_addon` WHERE `guid` = 197464;
DELETE FROM `creature_addon` WHERE `guid` = 197465;
DELETE FROM `creature_addon` WHERE `guid` = 197466;
DELETE FROM `creature_addon` WHERE `guid` = 197467;
DELETE FROM `creature_addon` WHERE `guid` = 197469;
DELETE FROM `creature_addon` WHERE `guid` = 197470;
DELETE FROM `creature_addon` WHERE `guid` = 197471;
DELETE FROM `creature_addon` WHERE `guid` = 197478;
DELETE FROM `creature_addon` WHERE `guid` = 197479;
DELETE FROM `creature_addon` WHERE `guid` = 197481;
DELETE FROM `creature_addon` WHERE `guid` = 197482;
DELETE FROM `creature_addon` WHERE `guid` = 197483;
DELETE FROM `creature_addon` WHERE `guid` = 197484;
DELETE FROM `creature_addon` WHERE `guid` = 197638;
DELETE FROM `creature_addon` WHERE `guid` = 197643;
DELETE FROM `creature_addon` WHERE `guid` = 197644;
DELETE FROM `creature_addon` WHERE `guid` = 197691;
 
Last edited:
ExO

ExO

Admin
5,119
2014
1,639
[MENTION=18032]mastermind[/MENTION]

The idea is good (I hope you haven't done this manually man). But there is some issues. If we have worked on the repack further than the repack version and used some of these guids for creature_addon and creature table it can break these things, so the idea is good but it's a risky query.

I had something a bit more, well forwarding in mind. [MENTION=18032]mastermind[/MENTION]
Basically just make a, if not exist in creature.@guid, then simply delete in creature_addon:

DELETE FROM creature_addon
WHERE guid NOT IN
(SELECT guid
FROM creature
WHERE guid is NOT NULL
)
 
mastermind

mastermind

Silver Supporter
Senior User
188
2017
13
Location
PA, USA
No, these were not all manually coded. That would have taken forever. :D
I had initially planned to do something like that but after our PM I thought you wanted them as single deletes.
[MENTION=13745]Titesusy[/MENTION] did something like the above command back in 2016 to clean these up. We discussed it in the 7th post in the series.

You may want to delete these posts. Don't want to have something out there that can cause issues.

I will find the one [MENTION=13745]Titesusy[/MENTION] wrote and mention in a new thread in this sections. I believe it is in the requests forum.
 
You must log in or register to reply here.
Top