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

Post 7 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


Last but not least ;)

Code: 
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- Massive DBError.log Clean-up
-- --------------------------------------------------------------------------------------------------------------------
DELETE FROM `creature_addon` WHERE `guid` = 234714;
DELETE FROM `creature_addon` WHERE `guid` = 234715;
DELETE FROM `creature_addon` WHERE `guid` = 234716;
DELETE FROM `creature_addon` WHERE `guid` = 234717;
DELETE FROM `creature_addon` WHERE `guid` = 234718;
DELETE FROM `creature_addon` WHERE `guid` = 234719;
DELETE FROM `creature_addon` WHERE `guid` = 234720;
DELETE FROM `creature_addon` WHERE `guid` = 234721;
DELETE FROM `creature_addon` WHERE `guid` = 234722;
DELETE FROM `creature_addon` WHERE `guid` = 234723;
DELETE FROM `creature_addon` WHERE `guid` = 234724;
DELETE FROM `creature_addon` WHERE `guid` = 234725;
DELETE FROM `creature_addon` WHERE `guid` = 234726;
DELETE FROM `creature_addon` WHERE `guid` = 234727;
DELETE FROM `creature_addon` WHERE `guid` = 234728;
DELETE FROM `creature_addon` WHERE `guid` = 234729;
DELETE FROM `creature_addon` WHERE `guid` = 234730;
DELETE FROM `creature_addon` WHERE `guid` = 234731;
DELETE FROM `creature_addon` WHERE `guid` = 234733;
DELETE FROM `creature_addon` WHERE `guid` = 234734;
DELETE FROM `creature_addon` WHERE `guid` = 234735;
DELETE FROM `creature_addon` WHERE `guid` = 234736;
DELETE FROM `creature_addon` WHERE `guid` = 234737;
DELETE FROM `creature_addon` WHERE `guid` = 234738;
DELETE FROM `creature_addon` WHERE `guid` = 234739;
DELETE FROM `creature_addon` WHERE `guid` = 234740;
DELETE FROM `creature_addon` WHERE `guid` = 234741;
DELETE FROM `creature_addon` WHERE `guid` = 234742;
DELETE FROM `creature_addon` WHERE `guid` = 234775;
DELETE FROM `creature_addon` WHERE `guid` = 234776;
DELETE FROM `creature_addon` WHERE `guid` = 234777;
DELETE FROM `creature_addon` WHERE `guid` = 234778;
DELETE FROM `creature_addon` WHERE `guid` = 234779;
DELETE FROM `creature_addon` WHERE `guid` = 234780;
DELETE FROM `creature_addon` WHERE `guid` = 234781;
DELETE FROM `creature_addon` WHERE `guid` = 234782;
DELETE FROM `creature_addon` WHERE `guid` = 234783;
DELETE FROM `creature_addon` WHERE `guid` = 234784;
DELETE FROM `creature_addon` WHERE `guid` = 234785;
DELETE FROM `creature_addon` WHERE `guid` = 234786;
DELETE FROM `creature_addon` WHERE `guid` = 234787;
DELETE FROM `creature_addon` WHERE `guid` = 234788;
DELETE FROM `creature_addon` WHERE `guid` = 234789;
DELETE FROM `creature_addon` WHERE `guid` = 234790;
DELETE FROM `creature_addon` WHERE `guid` = 234791;
DELETE FROM `creature_addon` WHERE `guid` = 234792;
DELETE FROM `creature_addon` WHERE `guid` = 234793;
DELETE FROM `creature_addon` WHERE `guid` = 234794;
DELETE FROM `creature_addon` WHERE `guid` = 234795;
DELETE FROM `creature_addon` WHERE `guid` = 234796;
DELETE FROM `creature_addon` WHERE `guid` = 234797;
DELETE FROM `creature_addon` WHERE `guid` = 234798;
DELETE FROM `creature_addon` WHERE `guid` = 234799;
DELETE FROM `creature_addon` WHERE `guid` = 234800;
DELETE FROM `creature_addon` WHERE `guid` = 234801;
DELETE FROM `creature_addon` WHERE `guid` = 234802;
DELETE FROM `creature_addon` WHERE `guid` = 234803;
DELETE FROM `creature_addon` WHERE `guid` = 234804;
DELETE FROM `creature_addon` WHERE `guid` = 234805;
DELETE FROM `creature_addon` WHERE `guid` = 234806;
DELETE FROM `creature_addon` WHERE `guid` = 234807;
DELETE FROM `creature_addon` WHERE `guid` = 234808;
DELETE FROM `creature_addon` WHERE `guid` = 234810;
DELETE FROM `creature_addon` WHERE `guid` = 234811;
DELETE FROM `creature_addon` WHERE `guid` = 234812;
DELETE FROM `creature_addon` WHERE `guid` = 234813;
DELETE FROM `creature_addon` WHERE `guid` = 234814;
DELETE FROM `creature_addon` WHERE `guid` = 234815;
DELETE FROM `creature_addon` WHERE `guid` = 234816;
DELETE FROM `creature_addon` WHERE `guid` = 234817;
DELETE FROM `creature_addon` WHERE `guid` = 234818;
DELETE FROM `creature_addon` WHERE `guid` = 234819;
DELETE FROM `creature_addon` WHERE `guid` = 234824;
DELETE FROM `creature_addon` WHERE `guid` = 234825;
DELETE FROM `creature_addon` WHERE `guid` = 234826;
DELETE FROM `creature_addon` WHERE `guid` = 234827;
DELETE FROM `creature_addon` WHERE `guid` = 234828;
DELETE FROM `creature_addon` WHERE `guid` = 234871;
DELETE FROM `creature_addon` WHERE `guid` = 234874;
DELETE FROM `creature_addon` WHERE `guid` = 234878;
DELETE FROM `creature_addon` WHERE `guid` = 234879;
DELETE FROM `creature_addon` WHERE `guid` = 234880;
DELETE FROM `creature_addon` WHERE `guid` = 234883;
DELETE FROM `creature_addon` WHERE `guid` = 234884;
DELETE FROM `creature_addon` WHERE `guid` = 234885;
DELETE FROM `creature_addon` WHERE `guid` = 234895;
DELETE FROM `creature_addon` WHERE `guid` = 234896;
DELETE FROM `creature_addon` WHERE `guid` = 234897;
DELETE FROM `creature_addon` WHERE `guid` = 234898;
DELETE FROM `creature_addon` WHERE `guid` = 234900;
DELETE FROM `creature_addon` WHERE `guid` = 234901;
DELETE FROM `creature_addon` WHERE `guid` = 234905;
DELETE FROM `creature_addon` WHERE `guid` = 234906;
DELETE FROM `creature_addon` WHERE `guid` = 234910;
DELETE FROM `creature_addon` WHERE `guid` = 234914;
DELETE FROM `creature_addon` WHERE `guid` = 234915;
DELETE FROM `creature_addon` WHERE `guid` = 234916;
DELETE FROM `creature_addon` WHERE `guid` = 234917;
DELETE FROM `creature_addon` WHERE `guid` = 234918;
DELETE FROM `creature_addon` WHERE `guid` = 234919;
DELETE FROM `creature_addon` WHERE `guid` = 234920;
DELETE FROM `creature_addon` WHERE `guid` = 234921;
DELETE FROM `creature_addon` WHERE `guid` = 234922;
DELETE FROM `creature_addon` WHERE `guid` = 234923;
DELETE FROM `creature_addon` WHERE `guid` = 234924;
DELETE FROM `creature_addon` WHERE `guid` = 234925;
DELETE FROM `creature_addon` WHERE `guid` = 234926;
DELETE FROM `creature_addon` WHERE `guid` = 234927;
DELETE FROM `creature_addon` WHERE `guid` = 234928;
DELETE FROM `creature_addon` WHERE `guid` = 234937;
DELETE FROM `creature_addon` WHERE `guid` = 234940;
DELETE FROM `creature_addon` WHERE `guid` = 234947;
DELETE FROM `creature_addon` WHERE `guid` = 234949;
DELETE FROM `creature_addon` WHERE `guid` = 234950;
DELETE FROM `creature_addon` WHERE `guid` = 234951;
DELETE FROM `creature_addon` WHERE `guid` = 234953;
DELETE FROM `creature_addon` WHERE `guid` = 234954;
DELETE FROM `creature_addon` WHERE `guid` = 234955;
DELETE FROM `creature_addon` WHERE `guid` = 234956;
DELETE FROM `creature_addon` WHERE `guid` = 234957;
DELETE FROM `creature_addon` WHERE `guid` = 234959;
DELETE FROM `creature_addon` WHERE `guid` = 234960;
DELETE FROM `creature_addon` WHERE `guid` = 234961;
DELETE FROM `creature_addon` WHERE `guid` = 234962;
DELETE FROM `creature_addon` WHERE `guid` = 234963;
DELETE FROM `creature_addon` WHERE `guid` = 234964;
DELETE FROM `creature_addon` WHERE `guid` = 234965;
DELETE FROM `creature_addon` WHERE `guid` = 234966;
DELETE FROM `creature_addon` WHERE `guid` = 234967;
DELETE FROM `creature_addon` WHERE `guid` = 234968;
DELETE FROM `creature_addon` WHERE `guid` = 234969;
DELETE FROM `creature_addon` WHERE `guid` = 234970;
DELETE FROM `creature_addon` WHERE `guid` = 234971;
DELETE FROM `creature_addon` WHERE `guid` = 234972;
DELETE FROM `creature_addon` WHERE `guid` = 234973;
DELETE FROM `creature_addon` WHERE `guid` = 234974;
DELETE FROM `creature_addon` WHERE `guid` = 234975;
DELETE FROM `creature_addon` WHERE `guid` = 234976;
DELETE FROM `creature_addon` WHERE `guid` = 234977;
DELETE FROM `creature_addon` WHERE `guid` = 234979;
DELETE FROM `creature_addon` WHERE `guid` = 234980;
DELETE FROM `creature_addon` WHERE `guid` = 234981;
DELETE FROM `creature_addon` WHERE `guid` = 234982;
DELETE FROM `creature_addon` WHERE `guid` = 234983;
DELETE FROM `creature_addon` WHERE `guid` = 234984;
DELETE FROM `creature_addon` WHERE `guid` = 234985;
DELETE FROM `creature_addon` WHERE `guid` = 234988;
DELETE FROM `creature_addon` WHERE `guid` = 234989;
DELETE FROM `creature_addon` WHERE `guid` = 234990;
DELETE FROM `creature_addon` WHERE `guid` = 234991;
DELETE FROM `creature_addon` WHERE `guid` = 234992;
DELETE FROM `creature_addon` WHERE `guid` = 234993;
DELETE FROM `creature_addon` WHERE `guid` = 234994;
DELETE FROM `creature_addon` WHERE `guid` = 234995;
DELETE FROM `creature_addon` WHERE `guid` = 234996;
DELETE FROM `creature_addon` WHERE `guid` = 234997;
DELETE FROM `creature_addon` WHERE `guid` = 234998;
DELETE FROM `creature_addon` WHERE `guid` = 234999;
DELETE FROM `creature_addon` WHERE `guid` = 235000;
DELETE FROM `creature_addon` WHERE `guid` = 235001;
DELETE FROM `creature_addon` WHERE `guid` = 235002;
DELETE FROM `creature_addon` WHERE `guid` = 235005;
DELETE FROM `creature_addon` WHERE `guid` = 235007;
DELETE FROM `creature_addon` WHERE `guid` = 235011;
DELETE FROM `creature_addon` WHERE `guid` = 235012;
DELETE FROM `creature_addon` WHERE `guid` = 235013;
DELETE FROM `creature_addon` WHERE `guid` = 235017;
DELETE FROM `creature_addon` WHERE `guid` = 235018;
DELETE FROM `creature_addon` WHERE `guid` = 235019;
DELETE FROM `creature_addon` WHERE `guid` = 235020;
DELETE FROM `creature_addon` WHERE `guid` = 235021;
DELETE FROM `creature_addon` WHERE `guid` = 235022;
DELETE FROM `creature_addon` WHERE `guid` = 235023;
DELETE FROM `creature_addon` WHERE `guid` = 235025;
DELETE FROM `creature_addon` WHERE `guid` = 235026;
DELETE FROM `creature_addon` WHERE `guid` = 235027;
DELETE FROM `creature_addon` WHERE `guid` = 235028;
DELETE FROM `creature_addon` WHERE `guid` = 235029;
DELETE FROM `creature_addon` WHERE `guid` = 235030;
DELETE FROM `creature_addon` WHERE `guid` = 235036;
DELETE FROM `creature_addon` WHERE `guid` = 235037;
DELETE FROM `creature_addon` WHERE `guid` = 235070;
DELETE FROM `creature_addon` WHERE `guid` = 235085;
DELETE FROM `creature_addon` WHERE `guid` = 235329;
DELETE FROM `creature_addon` WHERE `guid` = 235346;
DELETE FROM `creature_addon` WHERE `guid` = 235386;
DELETE FROM `creature_addon` WHERE `guid` = 235912;
DELETE FROM `creature_addon` WHERE `guid` = 235919;
DELETE FROM `creature_addon` WHERE `guid` = 236332;
DELETE FROM `creature_addon` WHERE `guid` = 236333;
DELETE FROM `creature_addon` WHERE `guid` = 236334;
DELETE FROM `creature_addon` WHERE `guid` = 236335;
DELETE FROM `creature_addon` WHERE `guid` = 236336;
DELETE FROM `creature_addon` WHERE `guid` = 236337;
DELETE FROM `creature_addon` WHERE `guid` = 236339;
DELETE FROM `creature_addon` WHERE `guid` = 236341;
DELETE FROM `creature_addon` WHERE `guid` = 236934;
DELETE FROM `creature_addon` WHERE `guid` = 237278;
DELETE FROM `creature_addon` WHERE `guid` = 237279;
DELETE FROM `creature_addon` WHERE `guid` = 242392;
DELETE FROM `creature_addon` WHERE `guid` = 242393;
DELETE FROM `creature_addon` WHERE `guid` = 244094;
DELETE FROM `creature_addon` WHERE `guid` = 244095;
DELETE FROM `creature_addon` WHERE `guid` = 244096;
DELETE FROM `creature_addon` WHERE `guid` = 244098;
DELETE FROM `creature_addon` WHERE `guid` = 244100;
DELETE FROM `creature_addon` WHERE `guid` = 244101;
DELETE FROM `creature_addon` WHERE `guid` = 244102;
DELETE FROM `creature_addon` WHERE `guid` = 244103;
DELETE FROM `creature_addon` WHERE `guid` = 244104;
DELETE FROM `creature_addon` WHERE `guid` = 244105;
DELETE FROM `creature_addon` WHERE `guid` = 244106;
DELETE FROM `creature_addon` WHERE `guid` = 244107;
DELETE FROM `creature_addon` WHERE `guid` = 244108;
DELETE FROM `creature_addon` WHERE `guid` = 244109;
DELETE FROM `creature_addon` WHERE `guid` = 244110;
DELETE FROM `creature_addon` WHERE `guid` = 244111;
DELETE FROM `creature_addon` WHERE `guid` = 244112;
DELETE FROM `creature_addon` WHERE `guid` = 244204;
DELETE FROM `creature_addon` WHERE `guid` = 244205;
DELETE FROM `creature_addon` WHERE `guid` = 244206;
DELETE FROM `creature_addon` WHERE `guid` = 244207;
DELETE FROM `creature_addon` WHERE `guid` = 244208;
DELETE FROM `creature_addon` WHERE `guid` = 244212;
DELETE FROM `creature_addon` WHERE `guid` = 244214;
DELETE FROM `creature_addon` WHERE `guid` = 244219;
DELETE FROM `creature_addon` WHERE `guid` = 244244;
DELETE FROM `creature_addon` WHERE `guid` = 244245;
DELETE FROM `creature_addon` WHERE `guid` = 244246;
DELETE FROM `creature_addon` WHERE `guid` = 244247;
DELETE FROM `creature_addon` WHERE `guid` = 244248;
DELETE FROM `creature_addon` WHERE `guid` = 244249;
DELETE FROM `creature_addon` WHERE `guid` = 244250;
DELETE FROM `creature_addon` WHERE `guid` = 244251;
DELETE FROM `creature_addon` WHERE `guid` = 244252;
DELETE FROM `creature_addon` WHERE `guid` = 244253;
DELETE FROM `creature_addon` WHERE `guid` = 244254;
DELETE FROM `creature_addon` WHERE `guid` = 244255;
DELETE FROM `creature_addon` WHERE `guid` = 244256;
DELETE FROM `creature_addon` WHERE `guid` = 244257;
DELETE FROM `creature_addon` WHERE `guid` = 244258;
DELETE FROM `creature_addon` WHERE `guid` = 244260;
DELETE FROM `creature_addon` WHERE `guid` = 244261;
DELETE FROM `creature_addon` WHERE `guid` = 244262;
DELETE FROM `creature_addon` WHERE `guid` = 244263;
DELETE FROM `creature_addon` WHERE `guid` = 244264;
DELETE FROM `creature_addon` WHERE `guid` = 244265;
DELETE FROM `creature_addon` WHERE `guid` = 244266;
DELETE FROM `creature_addon` WHERE `guid` = 244267;
DELETE FROM `creature_addon` WHERE `guid` = 244268;
DELETE FROM `creature_addon` WHERE `guid` = 244269;
DELETE FROM `creature_addon` WHERE `guid` = 244270;
DELETE FROM `creature_addon` WHERE `guid` = 244271;
DELETE FROM `creature_addon` WHERE `guid` = 244272;
DELETE FROM `creature_addon` WHERE `guid` = 244273;
DELETE FROM `creature_addon` WHERE `guid` = 244274;
DELETE FROM `creature_addon` WHERE `guid` = 244275;
DELETE FROM `creature_addon` WHERE `guid` = 244276;
DELETE FROM `creature_addon` WHERE `guid` = 244277;
DELETE FROM `creature_addon` WHERE `guid` = 244278;
DELETE FROM `creature_addon` WHERE `guid` = 244279;
DELETE FROM `creature_addon` WHERE `guid` = 244280;
DELETE FROM `creature_addon` WHERE `guid` = 244281;
DELETE FROM `creature_addon` WHERE `guid` = 244282;
DELETE FROM `creature_addon` WHERE `guid` = 244283;
DELETE FROM `creature_addon` WHERE `guid` = 244284;
DELETE FROM `creature_addon` WHERE `guid` = 244285;
DELETE FROM `creature_addon` WHERE `guid` = 244286;
DELETE FROM `creature_addon` WHERE `guid` = 244288;
DELETE FROM `creature_addon` WHERE `guid` = 244295;
DELETE FROM `creature_addon` WHERE `guid` = 244296;
DELETE FROM `creature_addon` WHERE `guid` = 244298;
DELETE FROM `creature_addon` WHERE `guid` = 244299;
DELETE FROM `creature_addon` WHERE `guid` = 244301;
DELETE FROM `creature_addon` WHERE `guid` = 244338;
DELETE FROM `creature_addon` WHERE `guid` = 244339;
DELETE FROM `creature_addon` WHERE `guid` = 244345;
DELETE FROM `creature_addon` WHERE `guid` = 244348;
DELETE FROM `creature_addon` WHERE `guid` = 244349;
DELETE FROM `creature_addon` WHERE `guid` = 244350;
DELETE FROM `creature_addon` WHERE `guid` = 244352;
DELETE FROM `creature_addon` WHERE `guid` = 244353;
DELETE FROM `creature_addon` WHERE `guid` = 244354;
DELETE FROM `creature_addon` WHERE `guid` = 244375;
DELETE FROM `creature_addon` WHERE `guid` = 244376;
DELETE FROM `creature_addon` WHERE `guid` = 244380;
DELETE FROM `creature_addon` WHERE `guid` = 244381;
DELETE FROM `creature_addon` WHERE `guid` = 244383;
DELETE FROM `creature_addon` WHERE `guid` = 244408;
DELETE FROM `creature_addon` WHERE `guid` = 244409;
DELETE FROM `creature_addon` WHERE `guid` = 244410;
DELETE FROM `creature_addon` WHERE `guid` = 244411;
DELETE FROM `creature_addon` WHERE `guid` = 244412;
DELETE FROM `creature_addon` WHERE `guid` = 244413;
DELETE FROM `creature_addon` WHERE `guid` = 244414;
DELETE FROM `creature_addon` WHERE `guid` = 244415;
DELETE FROM `creature_addon` WHERE `guid` = 244416;
DELETE FROM `creature_addon` WHERE `guid` = 244417;
DELETE FROM `creature_addon` WHERE `guid` = 244418;
DELETE FROM `creature_addon` WHERE `guid` = 244419;
DELETE FROM `creature_addon` WHERE `guid` = 244420;
DELETE FROM `creature_addon` WHERE `guid` = 244421;
DELETE FROM `creature_addon` WHERE `guid` = 244422;
DELETE FROM `creature_addon` WHERE `guid` = 244423;
DELETE FROM `creature_addon` WHERE `guid` = 244424;
DELETE FROM `creature_addon` WHERE `guid` = 244425;
DELETE FROM `creature_addon` WHERE `guid` = 244428;
DELETE FROM `creature_addon` WHERE `guid` = 244429;
DELETE FROM `creature_addon` WHERE `guid` = 244431;
DELETE FROM `creature_addon` WHERE `guid` = 244439;
DELETE FROM `creature_addon` WHERE `guid` = 244440;
DELETE FROM `creature_addon` WHERE `guid` = 244441;
DELETE FROM `creature_addon` WHERE `guid` = 244442;
DELETE FROM `creature_addon` WHERE `guid` = 244444;
DELETE FROM `creature_addon` WHERE `guid` = 244447;
DELETE FROM `creature_addon` WHERE `guid` = 244448;
DELETE FROM `creature_addon` WHERE `guid` = 244451;
DELETE FROM `creature_addon` WHERE `guid` = 244454;
DELETE FROM `creature_addon` WHERE `guid` = 244455;
DELETE FROM `creature_addon` WHERE `guid` = 244459;
DELETE FROM `creature_addon` WHERE `guid` = 244460;
DELETE FROM `creature_addon` WHERE `guid` = 244468;
DELETE FROM `creature_addon` WHERE `guid` = 244469;
DELETE FROM `creature_addon` WHERE `guid` = 244470;
DELETE FROM `creature_addon` WHERE `guid` = 244471;
DELETE FROM `creature_addon` WHERE `guid` = 248419;
DELETE FROM `creature_addon` WHERE `guid` = 248679;
DELETE FROM `creature_addon` WHERE `guid` = 250048;
DELETE FROM `creature_addon` WHERE `guid` = 250049;
DELETE FROM `creature_addon` WHERE `guid` = 250050;
DELETE FROM `creature_addon` WHERE `guid` = 250051;
DELETE FROM `creature_addon` WHERE `guid` = 250052;
DELETE FROM `creature_addon` WHERE `guid` = 250053;
DELETE FROM `creature_addon` WHERE `guid` = 250054;
DELETE FROM `creature_addon` WHERE `guid` = 250055;
DELETE FROM `creature_addon` WHERE `guid` = 250056;
DELETE FROM `creature_addon` WHERE `guid` = 250057;
DELETE FROM `creature_addon` WHERE `guid` = 250058;
DELETE FROM `creature_addon` WHERE `guid` = 250059;
DELETE FROM `creature_addon` WHERE `guid` = 250060;
DELETE FROM `creature_addon` WHERE `guid` = 250061;
DELETE FROM `creature_addon` WHERE `guid` = 250062;
DELETE FROM `creature_addon` WHERE `guid` = 250063;
DELETE FROM `creature_addon` WHERE `guid` = 250064;
DELETE FROM `creature_addon` WHERE `guid` = 250065;
DELETE FROM `creature_addon` WHERE `guid` = 250066;
DELETE FROM `creature_addon` WHERE `guid` = 250067;
DELETE FROM `creature_addon` WHERE `guid` = 250068;
DELETE FROM `creature_addon` WHERE `guid` = 250069;
DELETE FROM `creature_addon` WHERE `guid` = 250070;
DELETE FROM `creature_addon` WHERE `guid` = 250071;
DELETE FROM `creature_addon` WHERE `guid` = 250072;
DELETE FROM `creature_addon` WHERE `guid` = 250073;
DELETE FROM `creature_addon` WHERE `guid` = 250074;
DELETE FROM `creature_addon` WHERE `guid` = 250075;
DELETE FROM `creature_addon` WHERE `guid` = 250076;
DELETE FROM `creature_addon` WHERE `guid` = 250077;
DELETE FROM `creature_addon` WHERE `guid` = 250078;
DELETE FROM `creature_addon` WHERE `guid` = 250079;
DELETE FROM `creature_addon` WHERE `guid` = 250080;
DELETE FROM `creature_addon` WHERE `guid` = 250081;
DELETE FROM `creature_addon` WHERE `guid` = 250082;
DELETE FROM `creature_addon` WHERE `guid` = 250083;
DELETE FROM `creature_addon` WHERE `guid` = 250084;
DELETE FROM `creature_addon` WHERE `guid` = 250085;
DELETE FROM `creature_addon` WHERE `guid` = 250086;
DELETE FROM `creature_addon` WHERE `guid` = 250087;
DELETE FROM `creature_addon` WHERE `guid` = 250090;
DELETE FROM `creature_addon` WHERE `guid` = 250091;
DELETE FROM `creature_addon` WHERE `guid` = 250092;
DELETE FROM `creature_addon` WHERE `guid` = 250093;
DELETE FROM `creature_addon` WHERE `guid` = 250094;
DELETE FROM `creature_addon` WHERE `guid` = 250095;
DELETE FROM `creature_addon` WHERE `guid` = 250096;
DELETE FROM `creature_addon` WHERE `guid` = 250097;
DELETE FROM `creature_addon` WHERE `guid` = 250098;
DELETE FROM `creature_addon` WHERE `guid` = 250099;
DELETE FROM `creature_addon` WHERE `guid` = 250100;
DELETE FROM `creature_addon` WHERE `guid` = 250101;
DELETE FROM `creature_addon` WHERE `guid` = 250102;
DELETE FROM `creature_addon` WHERE `guid` = 250103;
DELETE FROM `creature_addon` WHERE `guid` = 250104;
DELETE FROM `creature_addon` WHERE `guid` = 250105;
DELETE FROM `creature_addon` WHERE `guid` = 250106;
DELETE FROM `creature_addon` WHERE `guid` = 250107;
DELETE FROM `creature_addon` WHERE `guid` = 250108;
DELETE FROM `creature_addon` WHERE `guid` = 250109;
DELETE FROM `creature_addon` WHERE `guid` = 250111;
DELETE FROM `creature_addon` WHERE `guid` = 250112;
DELETE FROM `creature_addon` WHERE `guid` = 250113;
DELETE FROM `creature_addon` WHERE `guid` = 250114;
DELETE FROM `creature_addon` WHERE `guid` = 250115;
DELETE FROM `creature_addon` WHERE `guid` = 250116;
DELETE FROM `creature_addon` WHERE `guid` = 250118;
DELETE FROM `creature_addon` WHERE `guid` = 250119;
DELETE FROM `creature_addon` WHERE `guid` = 250120;
DELETE FROM `creature_addon` WHERE `guid` = 250122;
DELETE FROM `creature_addon` WHERE `guid` = 250124;
DELETE FROM `creature_addon` WHERE `guid` = 250125;
DELETE FROM `creature_addon` WHERE `guid` = 250126;
DELETE FROM `creature_addon` WHERE `guid` = 250127;
DELETE FROM `creature_addon` WHERE `guid` = 250129;
DELETE FROM `creature_addon` WHERE `guid` = 250130;
DELETE FROM `creature_addon` WHERE `guid` = 250132;
DELETE FROM `creature_addon` WHERE `guid` = 250134;
DELETE FROM `creature_addon` WHERE `guid` = 250135;
DELETE FROM `creature_addon` WHERE `guid` = 250136;
DELETE FROM `creature_addon` WHERE `guid` = 250137;
DELETE FROM `creature_addon` WHERE `guid` = 250138;
DELETE FROM `creature_addon` WHERE `guid` = 250139;
DELETE FROM `creature_addon` WHERE `guid` = 250142;
DELETE FROM `creature_addon` WHERE `guid` = 250143;
DELETE FROM `creature_addon` WHERE `guid` = 250145;
DELETE FROM `creature_addon` WHERE `guid` = 250146;
DELETE FROM `creature_addon` WHERE `guid` = 250147;
DELETE FROM `creature_addon` WHERE `guid` = 250148;
DELETE FROM `creature_addon` WHERE `guid` = 250149;
DELETE FROM `creature_addon` WHERE `guid` = 250150;
DELETE FROM `creature_addon` WHERE `guid` = 250151;
DELETE FROM `creature_addon` WHERE `guid` = 250152;
DELETE FROM `creature_addon` WHERE `guid` = 250154;
DELETE FROM `creature_addon` WHERE `guid` = 250156;
DELETE FROM `creature_addon` WHERE `guid` = 250157;
DELETE FROM `creature_addon` WHERE `guid` = 250158;
DELETE FROM `creature_addon` WHERE `guid` = 250164;
DELETE FROM `creature_addon` WHERE `guid` = 250167;
DELETE FROM `creature_addon` WHERE `guid` = 250200;
DELETE FROM `creature_addon` WHERE `guid` = 250202;
DELETE FROM `creature_addon` WHERE `guid` = 250203;
DELETE FROM `creature_addon` WHERE `guid` = 250204;
DELETE FROM `creature_addon` WHERE `guid` = 250220;
DELETE FROM `creature_addon` WHERE `guid` = 250228;
DELETE FROM `creature_addon` WHERE `guid` = 250242;
DELETE FROM `creature_addon` WHERE `guid` = 250251;
DELETE FROM `creature_addon` WHERE `guid` = 250253;
DELETE FROM `creature_addon` WHERE `guid` = 250261;
DELETE FROM `creature_addon` WHERE `guid` = 250263;
DELETE FROM `creature_addon` WHERE `guid` = 250286;
DELETE FROM `creature_addon` WHERE `guid` = 250326;
DELETE FROM `creature_addon` WHERE `guid` = 250341;
DELETE FROM `creature_addon` WHERE `guid` = 250477;
DELETE FROM `creature_addon` WHERE `guid` = 250594;
DELETE FROM `creature_addon` WHERE `guid` = 251221;
DELETE FROM `creature_addon` WHERE `guid` = 251251;
DELETE FROM `creature_addon` WHERE `guid` = 255567;
DELETE FROM `creature_addon` WHERE `guid` = 255576;
DELETE FROM `creature_addon` WHERE `guid` = 280314;
DELETE FROM `creature_addon` WHERE `guid` = 280316;
DELETE FROM `creature_addon` WHERE `guid` = 314092;
DELETE FROM `creature_addon` WHERE `guid` = 316560;
DELETE FROM `creature_addon` WHERE `guid` = 316622;
DELETE FROM `creature_addon` WHERE `guid` = 316624;
DELETE FROM `creature_addon` WHERE `guid` = 316626;
DELETE FROM `creature_addon` WHERE `guid` = 316629;
DELETE FROM `creature_addon` WHERE `guid` = 316634;
DELETE FROM `creature_addon` WHERE `guid` = 316637;
DELETE FROM `creature_addon` WHERE `guid` = 316638;
DELETE FROM `creature_addon` WHERE `guid` = 316639;
DELETE FROM `creature_addon` WHERE `guid` = 316640;
DELETE FROM `creature_addon` WHERE `guid` = 316641;
DELETE FROM `creature_addon` WHERE `guid` = 316644;
DELETE FROM `creature_addon` WHERE `guid` = 316645;
DELETE FROM `creature_addon` WHERE `guid` = 316673;
DELETE FROM `creature_addon` WHERE `guid` = 316674;
DELETE FROM `creature_addon` WHERE `guid` = 316682;
DELETE FROM `creature_addon` WHERE `guid` = 316683;
DELETE FROM `creature_addon` WHERE `guid` = 316684;
DELETE FROM `creature_addon` WHERE `guid` = 316685;
DELETE FROM `creature_addon` WHERE `guid` = 316686;
DELETE FROM `creature_addon` WHERE `guid` = 316687;
DELETE FROM `creature_addon` WHERE `guid` = 316688;
DELETE FROM `creature_addon` WHERE `guid` = 316713;
DELETE FROM `creature_addon` WHERE `guid` = 316714;
DELETE FROM `creature_addon` WHERE `guid` = 316715;
DELETE FROM `creature_addon` WHERE `guid` = 316716;
DELETE FROM `creature_addon` WHERE `guid` = 316717;
DELETE FROM `creature_addon` WHERE `guid` = 316718;
DELETE FROM `creature_addon` WHERE `guid` = 316719;
DELETE FROM `creature_addon` WHERE `guid` = 316720;
DELETE FROM `creature_addon` WHERE `guid` = 316721;
DELETE FROM `creature_addon` WHERE `guid` = 316722;
DELETE FROM `creature_addon` WHERE `guid` = 316723;
DELETE FROM `creature_addon` WHERE `guid` = 316724;
DELETE FROM `creature_addon` WHERE `guid` = 316725;
DELETE FROM `creature_addon` WHERE `guid` = 316726;
DELETE FROM `creature_addon` WHERE `guid` = 316727;
DELETE FROM `creature_addon` WHERE `guid` = 316728;
DELETE FROM `creature_addon` WHERE `guid` = 316729;
DELETE FROM `creature_addon` WHERE `guid` = 316730;
DELETE FROM `creature_addon` WHERE `guid` = 316731;
DELETE FROM `creature_addon` WHERE `guid` = 316732;
DELETE FROM `creature_addon` WHERE `guid` = 316733;
DELETE FROM `creature_addon` WHERE `guid` = 316734;
DELETE FROM `creature_addon` WHERE `guid` = 316735;
DELETE FROM `creature_addon` WHERE `guid` = 316736;
DELETE FROM `creature_addon` WHERE `guid` = 316737;
DELETE FROM `creature_addon` WHERE `guid` = 316738;
DELETE FROM `creature_addon` WHERE `guid` = 316739;
DELETE FROM `creature_addon` WHERE `guid` = 316740;
DELETE FROM `creature_addon` WHERE `guid` = 316741;
DELETE FROM `creature_addon` WHERE `guid` = 316742;
DELETE FROM `creature_addon` WHERE `guid` = 316744;
DELETE FROM `creature_addon` WHERE `guid` = 316746;
DELETE FROM `creature_addon` WHERE `guid` = 316747;
DELETE FROM `creature_addon` WHERE `guid` = 316748;
DELETE FROM `creature_addon` WHERE `guid` = 316749;
DELETE FROM `creature_addon` WHERE `guid` = 316750;
DELETE FROM `creature_addon` WHERE `guid` = 316755;
DELETE FROM `creature_addon` WHERE `guid` = 316756;
DELETE FROM `creature_addon` WHERE `guid` = 316758;
DELETE FROM `creature_addon` WHERE `guid` = 316759;
DELETE FROM `creature_addon` WHERE `guid` = 316760;
DELETE FROM `creature_addon` WHERE `guid` = 316761;
DELETE FROM `creature_addon` WHERE `guid` = 316762;
DELETE FROM `creature_addon` WHERE `guid` = 316764;
DELETE FROM `creature_addon` WHERE `guid` = 316765;
DELETE FROM `creature_addon` WHERE `guid` = 316766;
DELETE FROM `creature_addon` WHERE `guid` = 316767;
DELETE FROM `creature_addon` WHERE `guid` = 316768;
DELETE FROM `creature_addon` WHERE `guid` = 316769;
DELETE FROM `creature_addon` WHERE `guid` = 316770;
DELETE FROM `creature_addon` WHERE `guid` = 316771;
DELETE FROM `creature_addon` WHERE `guid` = 316772;
DELETE FROM `creature_addon` WHERE `guid` = 316773;
DELETE FROM `creature_addon` WHERE `guid` = 316774;
DELETE FROM `creature_addon` WHERE `guid` = 316775;
DELETE FROM `creature_addon` WHERE `guid` = 316776;
DELETE FROM `creature_addon` WHERE `guid` = 316777;
DELETE FROM `creature_addon` WHERE `guid` = 316778;
DELETE FROM `creature_addon` WHERE `guid` = 316779;
DELETE FROM `creature_addon` WHERE `guid` = 316780;
DELETE FROM `creature_addon` WHERE `guid` = 316781;
DELETE FROM `creature_addon` WHERE `guid` = 316783;
DELETE FROM `creature_addon` WHERE `guid` = 316787;
DELETE FROM `creature_addon` WHERE `guid` = 316789;
DELETE FROM `creature_addon` WHERE `guid` = 316790;
DELETE FROM `creature_addon` WHERE `guid` = 316791;
DELETE FROM `creature_addon` WHERE `guid` = 316792;
DELETE FROM `creature_addon` WHERE `guid` = 316793;
DELETE FROM `creature_addon` WHERE `guid` = 316794;
DELETE FROM `creature_addon` WHERE `guid` = 316795;
DELETE FROM `creature_addon` WHERE `guid` = 316796;
DELETE FROM `creature_addon` WHERE `guid` = 316797;
DELETE FROM `creature_addon` WHERE `guid` = 316798;
DELETE FROM `creature_addon` WHERE `guid` = 316799;
DELETE FROM `creature_addon` WHERE `guid` = 316800;
DELETE FROM `creature_addon` WHERE `guid` = 316801;
DELETE FROM `creature_addon` WHERE `guid` = 316802;
DELETE FROM `creature_addon` WHERE `guid` = 316803;
DELETE FROM `creature_addon` WHERE `guid` = 316804;
DELETE FROM `creature_addon` WHERE `guid` = 316805;
DELETE FROM `creature_addon` WHERE `guid` = 316806;
DELETE FROM `creature_addon` WHERE `guid` = 316807;
DELETE FROM `creature_addon` WHERE `guid` = 316808;
DELETE FROM `creature_addon` WHERE `guid` = 316809;
DELETE FROM `creature_addon` WHERE `guid` = 316810;
DELETE FROM `creature_addon` WHERE `guid` = 316814;
DELETE FROM `creature_addon` WHERE `guid` = 316815;
DELETE FROM `creature_addon` WHERE `guid` = 316816;
DELETE FROM `creature_addon` WHERE `guid` = 316818;
DELETE FROM `creature_addon` WHERE `guid` = 316820;
DELETE FROM `creature_addon` WHERE `guid` = 316821;
DELETE FROM `creature_addon` WHERE `guid` = 316825;
DELETE FROM `creature_addon` WHERE `guid` = 316826;
DELETE FROM `creature_addon` WHERE `guid` = 316827;
DELETE FROM `creature_addon` WHERE `guid` = 316831;
DELETE FROM `creature_addon` WHERE `guid` = 316832;
DELETE FROM `creature_addon` WHERE `guid` = 316833;
DELETE FROM `creature_addon` WHERE `guid` = 316834;
DELETE FROM `creature_addon` WHERE `guid` = 316835;
DELETE FROM `creature_addon` WHERE `guid` = 316836;
DELETE FROM `creature_addon` WHERE `guid` = 316838;
DELETE FROM `creature_addon` WHERE `guid` = 316840;
DELETE FROM `creature_addon` WHERE `guid` = 316843;
DELETE FROM `creature_addon` WHERE `guid` = 316844;
DELETE FROM `creature_addon` WHERE `guid` = 316846;
DELETE FROM `creature_addon` WHERE `guid` = 316847;
DELETE FROM `creature_addon` WHERE `guid` = 316848;
DELETE FROM `creature_addon` WHERE `guid` = 316849;
DELETE FROM `creature_addon` WHERE `guid` = 316850;
DELETE FROM `creature_addon` WHERE `guid` = 316851;
DELETE FROM `creature_addon` WHERE `guid` = 316852;
DELETE FROM `creature_addon` WHERE `guid` = 316853;
DELETE FROM `creature_addon` WHERE `guid` = 316854;
DELETE FROM `creature_addon` WHERE `guid` = 316855;
DELETE FROM `creature_addon` WHERE `guid` = 316857;
DELETE FROM `creature_addon` WHERE `guid` = 316858;
DELETE FROM `creature_addon` WHERE `guid` = 316859;
DELETE FROM `creature_addon` WHERE `guid` = 316861;
DELETE FROM `creature_addon` WHERE `guid` = 316863;
DELETE FROM `creature_addon` WHERE `guid` = 316864;
DELETE FROM `creature_addon` WHERE `guid` = 316866;
DELETE FROM `creature_addon` WHERE `guid` = 316867;
DELETE FROM `creature_addon` WHERE `guid` = 316871;
DELETE FROM `creature_addon` WHERE `guid` = 316872;
DELETE FROM `creature_addon` WHERE `guid` = 316874;
DELETE FROM `creature_addon` WHERE `guid` = 316875;
DELETE FROM `creature_addon` WHERE `guid` = 316877;
DELETE FROM `creature_addon` WHERE `guid` = 316879;
DELETE FROM `creature_addon` WHERE `guid` = 316880;
DELETE FROM `creature_addon` WHERE `guid` = 316882;
DELETE FROM `creature_addon` WHERE `guid` = 316886;
DELETE FROM `creature_addon` WHERE `guid` = 316887;
DELETE FROM `creature_addon` WHERE `guid` = 316888;
DELETE FROM `creature_addon` WHERE `guid` = 316889;
DELETE FROM `creature_addon` WHERE `guid` = 316891;
DELETE FROM `creature_addon` WHERE `guid` = 316894;
DELETE FROM `creature_addon` WHERE `guid` = 316895;
DELETE FROM `creature_addon` WHERE `guid` = 316897;
DELETE FROM `creature_addon` WHERE `guid` = 316900;
DELETE FROM `creature_addon` WHERE `guid` = 316902;
DELETE FROM `creature_addon` WHERE `guid` = 316903;
DELETE FROM `creature_addon` WHERE `guid` = 316905;
DELETE FROM `creature_addon` WHERE `guid` = 316937;
DELETE FROM `creature_addon` WHERE `guid` = 316938;
DELETE FROM `creature_addon` WHERE `guid` = 316963;
DELETE FROM `creature_addon` WHERE `guid` = 316999;
DELETE FROM `creature_addon` WHERE `guid` = 317000;
DELETE FROM `creature_addon` WHERE `guid` = 317008;
DELETE FROM `creature_addon` WHERE `guid` = 317039;
DELETE FROM `creature_addon` WHERE `guid` = 317061;
DELETE FROM `creature_addon` WHERE `guid` = 317063;
DELETE FROM `creature_addon` WHERE `guid` = 317064;
DELETE FROM `creature_addon` WHERE `guid` = 317065;
DELETE FROM `creature_addon` WHERE `guid` = 317066;
DELETE FROM `creature_addon` WHERE `guid` = 317067;
DELETE FROM `creature_addon` WHERE `guid` = 317068;
DELETE FROM `creature_addon` WHERE `guid` = 317069;
DELETE FROM `creature_addon` WHERE `guid` = 317071;
DELETE FROM `creature_addon` WHERE `guid` = 317072;
DELETE FROM `creature_addon` WHERE `guid` = 317073;
DELETE FROM `creature_addon` WHERE `guid` = 317074;
DELETE FROM `creature_addon` WHERE `guid` = 317076;
DELETE FROM `creature_addon` WHERE `guid` = 317078;
DELETE FROM `creature_addon` WHERE `guid` = 317079;
DELETE FROM `creature_addon` WHERE `guid` = 317083;
DELETE FROM `creature_addon` WHERE `guid` = 317084;
DELETE FROM `creature_addon` WHERE `guid` = 317085;
DELETE FROM `creature_addon` WHERE `guid` = 317087;
DELETE FROM `creature_addon` WHERE `guid` = 317089;
DELETE FROM `creature_addon` WHERE `guid` = 317091;
DELETE FROM `creature_addon` WHERE `guid` = 317092;
DELETE FROM `creature_addon` WHERE `guid` = 317093;
DELETE FROM `creature_addon` WHERE `guid` = 317094;
DELETE FROM `creature_addon` WHERE `guid` = 317095;
DELETE FROM `creature_addon` WHERE `guid` = 317096;
DELETE FROM `creature_addon` WHERE `guid` = 317097;
DELETE FROM `creature_addon` WHERE `guid` = 317098;
DELETE FROM `creature_addon` WHERE `guid` = 317099;
DELETE FROM `creature_addon` WHERE `guid` = 317100;
DELETE FROM `creature_addon` WHERE `guid` = 317110;
DELETE FROM `creature_addon` WHERE `guid` = 317111;
DELETE FROM `creature_addon` WHERE `guid` = 317112;
DELETE FROM `creature_addon` WHERE `guid` = 317113;
DELETE FROM `creature_addon` WHERE `guid` = 317114;
DELETE FROM `creature_addon` WHERE `guid` = 317115;
DELETE FROM `creature_addon` WHERE `guid` = 317116;
DELETE FROM `creature_addon` WHERE `guid` = 317117;
DELETE FROM `creature_addon` WHERE `guid` = 317118;
DELETE FROM `creature_addon` WHERE `guid` = 317119;
DELETE FROM `creature_addon` WHERE `guid` = 317120;
DELETE FROM `creature_addon` WHERE `guid` = 317121;
DELETE FROM `creature_addon` WHERE `guid` = 317122;
DELETE FROM `creature_addon` WHERE `guid` = 317123;
DELETE FROM `creature_addon` WHERE `guid` = 317125;
DELETE FROM `creature_addon` WHERE `guid` = 317128;
DELETE FROM `creature_addon` WHERE `guid` = 317129;
DELETE FROM `creature_addon` WHERE `guid` = 317130;
DELETE FROM `creature_addon` WHERE `guid` = 317131;
DELETE FROM `creature_addon` WHERE `guid` = 317132;
DELETE FROM `creature_addon` WHERE `guid` = 317133;
DELETE FROM `creature_addon` WHERE `guid` = 317134;
DELETE FROM `creature_addon` WHERE `guid` = 317135;
DELETE FROM `creature_addon` WHERE `guid` = 317136;
DELETE FROM `creature_addon` WHERE `guid` = 317137;
DELETE FROM `creature_addon` WHERE `guid` = 317138;
DELETE FROM `creature_addon` WHERE `guid` = 317139;
DELETE FROM `creature_addon` WHERE `guid` = 317141;
DELETE FROM `creature_addon` WHERE `guid` = 317143;
DELETE FROM `creature_addon` WHERE `guid` = 317144;
DELETE FROM `creature_addon` WHERE `guid` = 317145;
DELETE FROM `creature_addon` WHERE `guid` = 317146;
DELETE FROM `creature_addon` WHERE `guid` = 317147;
DELETE FROM `creature_addon` WHERE `guid` = 317149;
DELETE FROM `creature_addon` WHERE `guid` = 317150;
DELETE FROM `creature_addon` WHERE `guid` = 317151;
DELETE FROM `creature_addon` WHERE `guid` = 317152;
DELETE FROM `creature_addon` WHERE `guid` = 317153;
DELETE FROM `creature_addon` WHERE `guid` = 317154;
DELETE FROM `creature_addon` WHERE `guid` = 317155;
DELETE FROM `creature_addon` WHERE `guid` = 317156;
DELETE FROM `creature_addon` WHERE `guid` = 317157;
DELETE FROM `creature_addon` WHERE `guid` = 317158;
DELETE FROM `creature_addon` WHERE `guid` = 317159;
DELETE FROM `creature_addon` WHERE `guid` = 317160;
DELETE FROM `creature_addon` WHERE `guid` = 317161;
DELETE FROM `creature_addon` WHERE `guid` = 317162;
DELETE FROM `creature_addon` WHERE `guid` = 317163;
DELETE FROM `creature_addon` WHERE `guid` = 317164;
DELETE FROM `creature_addon` WHERE `guid` = 317165;
DELETE FROM `creature_addon` WHERE `guid` = 317166;
DELETE FROM `creature_addon` WHERE `guid` = 317167;
DELETE FROM `creature_addon` WHERE `guid` = 317168;
DELETE FROM `creature_addon` WHERE `guid` = 317169;
DELETE FROM `creature_addon` WHERE `guid` = 317170;
DELETE FROM `creature_addon` WHERE `guid` = 317171;
DELETE FROM `creature_addon` WHERE `guid` = 317172;
DELETE FROM `creature_addon` WHERE `guid` = 317173;
DELETE FROM `creature_addon` WHERE `guid` = 317174;
DELETE FROM `creature_addon` WHERE `guid` = 317176;
DELETE FROM `creature_addon` WHERE `guid` = 317178;
DELETE FROM `creature_addon` WHERE `guid` = 317179;
DELETE FROM `creature_addon` WHERE `guid` = 317181;
DELETE FROM `creature_addon` WHERE `guid` = 317182;
DELETE FROM `creature_addon` WHERE `guid` = 317183;
DELETE FROM `creature_addon` WHERE `guid` = 317184;
DELETE FROM `creature_addon` WHERE `guid` = 317185;
DELETE FROM `creature_addon` WHERE `guid` = 317186;
DELETE FROM `creature_addon` WHERE `guid` = 317188;
DELETE FROM `creature_addon` WHERE `guid` = 317189;
DELETE FROM `creature_addon` WHERE `guid` = 317190;
DELETE FROM `creature_addon` WHERE `guid` = 317191;
DELETE FROM `creature_addon` WHERE `guid` = 317192;
DELETE FROM `creature_addon` WHERE `guid` = 317193;
DELETE FROM `creature_addon` WHERE `guid` = 317194;
DELETE FROM `creature_addon` WHERE `guid` = 317195;
DELETE FROM `creature_addon` WHERE `guid` = 317196;
DELETE FROM `creature_addon` WHERE `guid` = 317197;
DELETE FROM `creature_addon` WHERE `guid` = 317198;
DELETE FROM `creature_addon` WHERE `guid` = 317199;
DELETE FROM `creature_addon` WHERE `guid` = 317200;
DELETE FROM `creature_addon` WHERE `guid` = 317201;
DELETE FROM `creature_addon` WHERE `guid` = 317202;
DELETE FROM `creature_addon` WHERE `guid` = 317203;
DELETE FROM `creature_addon` WHERE `guid` = 317204;
DELETE FROM `creature_addon` WHERE `guid` = 317205;
DELETE FROM `creature_addon` WHERE `guid` = 317206;
DELETE FROM `creature_addon` WHERE `guid` = 317207;
DELETE FROM `creature_addon` WHERE `guid` = 317208;
DELETE FROM `creature_addon` WHERE `guid` = 317209;
DELETE FROM `creature_addon` WHERE `guid` = 317210;
DELETE FROM `creature_addon` WHERE `guid` = 317211;
DELETE FROM `creature_addon` WHERE `guid` = 317212;
DELETE FROM `creature_addon` WHERE `guid` = 317213;
DELETE FROM `creature_addon` WHERE `guid` = 317214;
DELETE FROM `creature_addon` WHERE `guid` = 317215;
DELETE FROM `creature_addon` WHERE `guid` = 317216;
DELETE FROM `creature_addon` WHERE `guid` = 317217;
DELETE FROM `creature_addon` WHERE `guid` = 317218;
DELETE FROM `creature_addon` WHERE `guid` = 317219;
DELETE FROM `creature_addon` WHERE `guid` = 317221;
DELETE FROM `creature_addon` WHERE `guid` = 317222;
DELETE FROM `creature_addon` WHERE `guid` = 317223;
DELETE FROM `creature_addon` WHERE `guid` = 317224;
DELETE FROM `creature_addon` WHERE `guid` = 317225;
DELETE FROM `creature_addon` WHERE `guid` = 317226;
DELETE FROM `creature_addon` WHERE `guid` = 317227;
DELETE FROM `creature_addon` WHERE `guid` = 317228;
DELETE FROM `creature_addon` WHERE `guid` = 317229;
DELETE FROM `creature_addon` WHERE `guid` = 317230;
DELETE FROM `creature_addon` WHERE `guid` = 317231;
DELETE FROM `creature_addon` WHERE `guid` = 317232;
DELETE FROM `creature_addon` WHERE `guid` = 317233;
DELETE FROM `creature_addon` WHERE `guid` = 317234;
DELETE FROM `creature_addon` WHERE `guid` = 317235;
DELETE FROM `creature_addon` WHERE `guid` = 317236;
DELETE FROM `creature_addon` WHERE `guid` = 317237;
DELETE FROM `creature_addon` WHERE `guid` = 317238;
DELETE FROM `creature_addon` WHERE `guid` = 317239;
DELETE FROM `creature_addon` WHERE `guid` = 317240;
DELETE FROM `creature_addon` WHERE `guid` = 317241;
DELETE FROM `creature_addon` WHERE `guid` = 317242;
DELETE FROM `creature_addon` WHERE `guid` = 317243;
DELETE FROM `creature_addon` WHERE `guid` = 317244;
DELETE FROM `creature_addon` WHERE `guid` = 317245;
DELETE FROM `creature_addon` WHERE `guid` = 317246;
DELETE FROM `creature_addon` WHERE `guid` = 317247;
DELETE FROM `creature_addon` WHERE `guid` = 317248;
DELETE FROM `creature_addon` WHERE `guid` = 317249;
DELETE FROM `creature_addon` WHERE `guid` = 317250;
DELETE FROM `creature_addon` WHERE `guid` = 317251;
DELETE FROM `creature_addon` WHERE `guid` = 317252;
DELETE FROM `creature_addon` WHERE `guid` = 317253;
DELETE FROM `creature_addon` WHERE `guid` = 317254;
DELETE FROM `creature_addon` WHERE `guid` = 317255;
DELETE FROM `creature_addon` WHERE `guid` = 317256;
DELETE FROM `creature_addon` WHERE `guid` = 317257;
DELETE FROM `creature_addon` WHERE `guid` = 317258;
DELETE FROM `creature_addon` WHERE `guid` = 317259;
DELETE FROM `creature_addon` WHERE `guid` = 317260;
DELETE FROM `creature_addon` WHERE `guid` = 317261;
DELETE FROM `creature_addon` WHERE `guid` = 317262;
DELETE FROM `creature_addon` WHERE `guid` = 317263;
DELETE FROM `creature_addon` WHERE `guid` = 317264;
DELETE FROM `creature_addon` WHERE `guid` = 317265;
DELETE FROM `creature_addon` WHERE `guid` = 317266;
DELETE FROM `creature_addon` WHERE `guid` = 317267;
DELETE FROM `creature_addon` WHERE `guid` = 317270;
DELETE FROM `creature_addon` WHERE `guid` = 317271;
DELETE FROM `creature_addon` WHERE `guid` = 317272;
DELETE FROM `creature_addon` WHERE `guid` = 317273;
DELETE FROM `creature_addon` WHERE `guid` = 317274;
DELETE FROM `creature_addon` WHERE `guid` = 317275;
DELETE FROM `creature_addon` WHERE `guid` = 317276;
DELETE FROM `creature_addon` WHERE `guid` = 317277;
DELETE FROM `creature_addon` WHERE `guid` = 317278;
DELETE FROM `creature_addon` WHERE `guid` = 317279;
DELETE FROM `creature_addon` WHERE `guid` = 317280;
DELETE FROM `creature_addon` WHERE `guid` = 317281;
DELETE FROM `creature_addon` WHERE `guid` = 317282;
DELETE FROM `creature_addon` WHERE `guid` = 317284;
DELETE FROM `creature_addon` WHERE `guid` = 317285;
DELETE FROM `creature_addon` WHERE `guid` = 317286;
DELETE FROM `creature_addon` WHERE `guid` = 317287;
DELETE FROM `creature_addon` WHERE `guid` = 317288;
DELETE FROM `creature_addon` WHERE `guid` = 317289;
DELETE FROM `creature_addon` WHERE `guid` = 317290;
DELETE FROM `creature_addon` WHERE `guid` = 317291;
DELETE FROM `creature_addon` WHERE `guid` = 317292;
DELETE FROM `creature_addon` WHERE `guid` = 317293;
DELETE FROM `creature_addon` WHERE `guid` = 317294;
DELETE FROM `creature_addon` WHERE `guid` = 317295;
DELETE FROM `creature_addon` WHERE `guid` = 317296;
DELETE FROM `creature_addon` WHERE `guid` = 317297;
DELETE FROM `creature_addon` WHERE `guid` = 317298;
DELETE FROM `creature_addon` WHERE `guid` = 317299;
DELETE FROM `creature_addon` WHERE `guid` = 317300;
DELETE FROM `creature_addon` WHERE `guid` = 317302;
DELETE FROM `creature_addon` WHERE `guid` = 317303;
DELETE FROM `creature_addon` WHERE `guid` = 317304;
DELETE FROM `creature_addon` WHERE `guid` = 317305;
DELETE FROM `creature_addon` WHERE `guid` = 317306;
DELETE FROM `creature_addon` WHERE `guid` = 317307;
DELETE FROM `creature_addon` WHERE `guid` = 317308;
DELETE FROM `creature_addon` WHERE `guid` = 317309;
DELETE FROM `creature_addon` WHERE `guid` = 317310;
DELETE FROM `creature_addon` WHERE `guid` = 317311;
DELETE FROM `creature_addon` WHERE `guid` = 317312;
DELETE FROM `creature_addon` WHERE `guid` = 317313;
DELETE FROM `creature_addon` WHERE `guid` = 317314;
DELETE FROM `creature_addon` WHERE `guid` = 317315;
DELETE FROM `creature_addon` WHERE `guid` = 317316;
DELETE FROM `creature_addon` WHERE `guid` = 317317;
DELETE FROM `creature_addon` WHERE `guid` = 317318;
DELETE FROM `creature_addon` WHERE `guid` = 317319;
DELETE FROM `creature_addon` WHERE `guid` = 317320;
DELETE FROM `creature_addon` WHERE `guid` = 317321;
DELETE FROM `creature_addon` WHERE `guid` = 317322;
DELETE FROM `creature_addon` WHERE `guid` = 317323;
DELETE FROM `creature_addon` WHERE `guid` = 317324;
DELETE FROM `creature_addon` WHERE `guid` = 317325;
DELETE FROM `creature_addon` WHERE `guid` = 317326;
DELETE FROM `creature_addon` WHERE `guid` = 317327;
DELETE FROM `creature_addon` WHERE `guid` = 317328;
DELETE FROM `creature_addon` WHERE `guid` = 317329;
DELETE FROM `creature_addon` WHERE `guid` = 317335;
DELETE FROM `creature_addon` WHERE `guid` = 317336;
DELETE FROM `creature_addon` WHERE `guid` = 317337;
DELETE FROM `creature_addon` WHERE `guid` = 317338;
DELETE FROM `creature_addon` WHERE `guid` = 317342;
DELETE FROM `creature_addon` WHERE `guid` = 317343;
DELETE FROM `creature_addon` WHERE `guid` = 317344;
DELETE FROM `creature_addon` WHERE `guid` = 317345;
DELETE FROM `creature_addon` WHERE `guid` = 317346;
DELETE FROM `creature_addon` WHERE `guid` = 317347;
DELETE FROM `creature_addon` WHERE `guid` = 317348;
DELETE FROM `creature_addon` WHERE `guid` = 317349;
DELETE FROM `creature_addon` WHERE `guid` = 317350;
DELETE FROM `creature_addon` WHERE `guid` = 317351;
DELETE FROM `creature_addon` WHERE `guid` = 317353;
DELETE FROM `creature_addon` WHERE `guid` = 317354;
DELETE FROM `creature_addon` WHERE `guid` = 317355;
DELETE FROM `creature_addon` WHERE `guid` = 317356;
DELETE FROM `creature_addon` WHERE `guid` = 317357;
DELETE FROM `creature_addon` WHERE `guid` = 317358;
DELETE FROM `creature_addon` WHERE `guid` = 317359;
DELETE FROM `creature_addon` WHERE `guid` = 317360;
DELETE FROM `creature_addon` WHERE `guid` = 317361;
DELETE FROM `creature_addon` WHERE `guid` = 317362;
DELETE FROM `creature_addon` WHERE `guid` = 317363;
DELETE FROM `creature_addon` WHERE `guid` = 317364;
DELETE FROM `creature_addon` WHERE `guid` = 317365;
DELETE FROM `creature_addon` WHERE `guid` = 317366;
DELETE FROM `creature_addon` WHERE `guid` = 317367;
DELETE FROM `creature_addon` WHERE `guid` = 317368;
DELETE FROM `creature_addon` WHERE `guid` = 317369;
DELETE FROM `creature_addon` WHERE `guid` = 317370;
DELETE FROM `creature_addon` WHERE `guid` = 317371;
DELETE FROM `creature_addon` WHERE `guid` = 317372;
DELETE FROM `creature_addon` WHERE `guid` = 317373;
DELETE FROM `creature_addon` WHERE `guid` = 317377;
DELETE FROM `creature_addon` WHERE `guid` = 317378;
DELETE FROM `creature_addon` WHERE `guid` = 317379;
DELETE FROM `creature_addon` WHERE `guid` = 317380;
DELETE FROM `creature_addon` WHERE `guid` = 317381;
DELETE FROM `creature_addon` WHERE `guid` = 317382;
DELETE FROM `creature_addon` WHERE `guid` = 317383;
DELETE FROM `creature_addon` WHERE `guid` = 317384;
DELETE FROM `creature_addon` WHERE `guid` = 317385;
DELETE FROM `creature_addon` WHERE `guid` = 317386;
DELETE FROM `creature_addon` WHERE `guid` = 317387;
DELETE FROM `creature_addon` WHERE `guid` = 317388;
DELETE FROM `creature_addon` WHERE `guid` = 317389;
DELETE FROM `creature_addon` WHERE `guid` = 317390;
DELETE FROM `creature_addon` WHERE `guid` = 317391;
DELETE FROM `creature_addon` WHERE `guid` = 317392;
DELETE FROM `creature_addon` WHERE `guid` = 317393;
DELETE FROM `creature_addon` WHERE `guid` = 317394;
DELETE FROM `creature_addon` WHERE `guid` = 317395;
DELETE FROM `creature_addon` WHERE `guid` = 317396;
DELETE FROM `creature_addon` WHERE `guid` = 317397;
DELETE FROM `creature_addon` WHERE `guid` = 317398;
DELETE FROM `creature_addon` WHERE `guid` = 317399;
DELETE FROM `creature_addon` WHERE `guid` = 317400;
DELETE FROM `creature_addon` WHERE `guid` = 317401;
DELETE FROM `creature_addon` WHERE `guid` = 317402;
DELETE FROM `creature_addon` WHERE `guid` = 317403;
DELETE FROM `creature_addon` WHERE `guid` = 317404;
DELETE FROM `creature_addon` WHERE `guid` = 317405;
DELETE FROM `creature_addon` WHERE `guid` = 15428094;
DELETE FROM `creature_addon` WHERE `guid` = 15428095;
DELETE FROM `creature_addon` WHERE `guid` = 15428096;
DELETE FROM `creature_addon` WHERE `guid` = 15428097;
 
Last edited:
Titesusy

Titesusy

Veteran Member
134
2016
4
Location
France
Thanks you mastermind, but these scripts (1 to all 7 parts) have already been posted months ago ... => http://www.emucoach.com/showthread.php?2237-Event-Scripts&p=23249#post23249

-- Date of the version : 12/11/ 2016

-- Remove warnings in worldserver.exe console like :
-- Creature (GUID: 178647) does not exist but has a record in 'creature_addon'
-- If the guid from 'creature' doesn't exist, we can remove it from 'creature_addon'

DELETE FROM
creature_addon
WHERE
creature_addon.guid NOT IN (SELECT creature.guid
FROM
creature);
Click to expand...
 
Last edited:
mastermind

mastermind

Silver Supporter
Senior User
188
2017
13
Location
PA, USA
No problem. Saw the errors in the log for the latest repack and did not see the post you linked in the Unofficial SQL forum so I I just did it. Did it the long way without the using joins or NOT IN as they seem to scare folks off that are not really up on SQL.

Wonder why your fix was not in the latest repack (7.0.2)?

Not matter. Hopefully they get cleaned up in the next one.
 
Titesusy

Titesusy

Veteran Member
134
2016
4
Location
France
i didn't used joins because i don't know use them :) i'm learning myself sql, when i have time to,... so :)
the code has been tested with "navicat premium", i don't know about other if they support "not in". But the idea was to have a list of all spawned creatures, and to remove into the creature_addon all "guid" unknown in that previous list. If it's possible in joins, please do :)

about your question, i can't answer, i don't compile the repack :)
 
Last edited:
mastermind

mastermind

Silver Supporter
Senior User
188
2017
13
Location
PA, USA
I have been working in SQL (MS-SQl, MySQL and Oracle) for many years and your SQL looks very good and works perfectly. If I was doing this for myself only I would have taken your approach but since it is for the masses I did the row by row option just to keep it simple. Nice thing about SQL (any flavor) is there is more than one way to get the same end result.
 
ExO

ExO

Admin
5,119
2014
1,639
Good question actually, errors might've come up again by re-guid. Either way, I've executed the poll etc ones now :)
 
You must log in or register to reply here.
Top