DB/Spawns: Added missing Event Commoner spawns and fixed event assignment

Closes #28447

1 files changed, 1178 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_11_07_01_world.sql b/sql/updates/world/master/2022_11_07_01_world.sql
new file mode 100644
index 00000000000..47a253907c2
--- /dev/null
+++ b/sql/updates/world/master/2022_11_07_01_world.sql
@@ -0,0 +1,1178 @@
+SET @CGUID := 396087;
+
+-- Creature templates
+UPDATE `creature_template` SET `gossip_menu_id`=8939 WHERE `entry`=20102; -- Goblin Commoner
+
+DELETE FROM `creature_template_addon` WHERE `entry`=20102;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(20102, 0, 0, 0, 1, 0, 0, 0, 0, 0, '33209 33207 33208');
+
+-- Quests
+DELETE FROM `creature_queststarter` WHERE (`id`=20102 AND `quest` IN (29400, 29074));
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(20102, 29074, 46366), -- A Season for Celebration offered Goblin Commoner
+(20102, 29400, 46366); -- A Season for Celebration offered Goblin Commoner
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=20102 AND `quest` IN (29400, 29074);
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN 134906 AND 134918;
+DELETE FROM `creature` WHERE `guid` BETWEEN 134919 AND 134934;
+DELETE FROM `creature` WHERE `guid` BETWEEN 134881 AND 134884;
+DELETE FROM `creature` WHERE `guid` BETWEEN 134895 AND 134898;
+DELETE FROM `creature` WHERE `guid` IN (86732, 86733, 134848, 134961, 134963, 134965, 134966, 134988, 134989, 134994);
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 134906 AND 134918;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 134919 AND 134934;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 134881 AND 134884;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 134895 AND 134898;
+DELETE FROM `game_event_creature` WHERE `guid` IN (86732, 86733, 134848, 134961, 134963, 134965, 134966, 134988, 134989, 134994);
+
+-- Creature spawns
+UPDATE `creature` SET `equipment_id`=0 WHERE `guid` IN (850253, 850255, 850257, 850259, 850262);
+
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+61;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+-- Ratchet
+(@CGUID+0, 20102, 1, 17, 392, '0', 0, 0, 0, 0, -924.09893798828125, -3718.003173828125, 9.185143470764160156, 1.692969322204589843, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Ratchet - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+1, 20102, 1, 17, 392, '0', 0, 0, 0, 0, -924.65625, -3715.908935546875, 9.131733894348144531, 5.06145477294921875, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Ratchet - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+2, 20102, 1, 17, 392, '0', 0, 0, 0, 0, -898.02410888671875, -3765.58935546875, 11.86798286437988281, 1.256637096405029296, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Ratchet - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+3, 20102, 1, 17, 392, '0', 0, 0, 0, 0, -897.12384033203125, -3763.225830078125, 11.98815059661865234, 4.328416347503662109, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Ratchet - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+4, 20102, 1, 17, 392, '0', 0, 0, 0, 0, -1030.970703125, -3678.40576171875, 23.24793434143066406, 1.623156189918518066, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Ratchet - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+5, 20102, 1, 17, 392, '0', 0, 0, 0, 0, -1031.02783203125, -3676.19873046875, 23.18507194519042968, 4.694935798645019531, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Ratchet - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+-- Gadgetzan
+(@CGUID+6, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7053.0048828125, -3779.90283203125, 10.14777183532714843, 1.535889744758605957, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+7, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7053.61865234375, -3777.210205078125, 10.20470237731933593, 5.25344085693359375, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+8, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7147.06396484375, -3830.216064453125, 8.5139617919921875, 6.056292533874511718, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+9, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7144.11572265625, -3830.954345703125, 8.505434989929199218, 3.263765573501586914, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+10, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7182.970703125, -3811.807373046875, 8.785478591918945312, 1.780235767364501953, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+11, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7183.51025390625, -3808.498291015625, 8.619421005249023437, 4.817108631134033203, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+12, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7217.572265625, -3735.163330078125, 8.453137397766113281, 2.286381244659423828, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+13, 20102, 1, 440, 976, '0', 0, 0, 0, 0, -7219.65966796875, -3731.911376953125, 8.463495254516601562, 5.131268024444580078, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Gadgetzan - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+-- Everlook
+(@CGUID+14, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6755.4677734375, -4666.119140625, 724.32305908203125, 5.585053443908691406, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0)
+(@CGUID+15, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6707.43115234375, -4675.7412109375, 721.14764404296875, 1.797689080238342285, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+16, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6808.54541015625, -4604.900390625, 710.5283203125, 0.314159274101257324, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+17, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6812.02490234375, -4603.5087890625, 710.75250244140625, 3.630284786224365234, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+18, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6757.30322265625, -4667.43505859375, 724.2777099609375, 2.617993831634521484, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0)
+(@CGUID+19, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6706.6865234375, -4673.666015625, 721.51214599609375, 5.183627605438232421, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+20, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6791.34375, -4747.0087890625, 701.61676025390625, 2.216568231582641601, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+21, 20102, 1, 618, 2255, '0', 0, 0, 0, 0, 6789.40380859375, -4744.7900390625, 701.61572265625, 5.497786998748779296, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Everlook - Difficulty: 0) (Auras: 65525 - Gossip NPC Appearance - Hallow's End, 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+-- Booty Bay
+(@CGUID+22, 20102, 0, 5287, 35, '0', 0, 0, 0, 0, -14468.7001953125, 463.641998291015625, 36.92413330078125, 4.136430263519287109, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Booty Bay - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+23, 20102, 0, 5287, 35, '0', 0, 0, 0, 0, -14469.599609375, 462.22198486328125, 36.92483139038085937, 0.279252678155899047, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Booty Bay - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+24, 20102, 0, 5287, 35, '0', 0, 0, 0, 0, -14440.125, 509.03472900390625, 26.27169609069824218, 1.343903541564941406, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Booty Bay - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+25, 20102, 0, 5287, 35, '0', 0, 0, 0, 0, -14440.2255859375, 510.30035400390625, 26.26188850402832031, 5.078907966613769531, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Booty Bay - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+26, 20102, 0, 5287, 35, '0', 0, 0, 0, 0, -14313.53515625, 508.852447509765625, 8.691331863403320312, 4.276056766510009765, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Booty Bay - Difficulty: 0)
+(@CGUID+27, 20102, 0, 5287, 35, '0', 0, 0, 0, 0, -14313.9658203125, 507.109375, 8.688276290893554687, 1.221730470657348632, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Booty Bay - Difficulty: 0)
+-- Shattrath
+(@CGUID+28, 20102, 530, 3703, 3703, '0', 0, 0, 0, 0, -1884.1431884765625, 5766.55029296875, 129.641204833984375, 1.308996915817260742, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Shattrath City - Difficulty: 0)
+(@CGUID+29, 20102, 530, 3703, 3703, '0', 0, 0, 0, 0, -1883.611572265625, 5769.2822265625, 129.641204833984375, 4.15388345718383789, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Shattrath City - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+30, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1748.0755615234375, 5493.85791015625, -12.3448047637939453, 4.258603572845458984, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+31, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1747.9027099609375, 5492.11279296875, -12.3448047637939453, 1.343903541564941406, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+32, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1809.9249267578125, 5418.63720703125, -12.3448457717895507, 5.550147056579589843, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+33, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1808.356201171875, 5417.01025390625, -12.3448410034179687, 2.321287870407104492, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+34, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1920.16845703125, 5443.51806640625, -12.3448352813720703, 5.864306449890136718, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+35, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1917.8135986328125, 5441.85009765625, -12.3448438644409179, 2.356194496154785156, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+36, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1980.7156982421875, 5364.884765625, -12.322549819946289, 0.226892799139022827, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+37, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1978.8189697265625, 5365.20654296875, -12.3448047637939453, 3.630284786224365234, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+38, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -2174.136962890625, 5413.0625, 50.31124496459960937, 2.565634012222290039, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0)
+(@CGUID+39, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -2175.761962890625, 5414.6220703125, 50.31124114990234375, 5.602506637573242187, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0)
+(@CGUID+40, 20102, 530, 3703, 3898, '0', 0, 0, 0, 0, -1875.05517578125, 5378.03515625, -12.3447751998901367, 4.363323211669921875, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Scryer's Tier - Difficulty: 0)
+(@CGUID+41, 20102, 530, 3703, 3898, '0', 0, 0, 0, 0, -1875.9344482421875, 5376.2021484375, -12.3447761535644531, 0.820304751396179199, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Scryer's Tier - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+42, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1821.1177978515625, 5303.34521484375, -12.3448057174682617, 0.767944872379302978, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+43, 20102, 530, 3703, 0, '0', 0, 0, 0, 0, -1818.9884033203125, 5305.673828125, -12.3448057174682617, 4.031710624694824218, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+-- Area 52
+(@CGUID+44, 20102, 530, 3523, 3712, '0', 0, 0, 0, 0, 3073.896484375, 3597.2158203125, 144.14971923828125, 4.537856101989746093, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Area 52 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+45, 20102, 530, 3523, 3712, '0', 0, 0, 0, 0, 3073.345947265625, 3595.1220703125, 144.14971923828125, 1.274090290069580078, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Area 52 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+46, 20102, 530, 3523, 3712, '0', 0, 0, 0, 0, 3049.17529296875, 3680.830322265625, 142.7080841064453125, 2.146754980087280273, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Area 52 - Difficulty: 0)
+(@CGUID+47, 20102, 530, 3523, 3712, '0', 0, 0, 0, 0, 3047.91015625, 3683.240478515625, 142.588531494140625, 5.183627605438232421, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Area 52 - Difficulty: 0)
+(@CGUID+48, 20102, 530, 3523, 3712, '0', 0, 0, 0, 0, 2977.159912109375, 3648.09033203125, 143.5688934326171875, 1.93731546401977539, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Area 52 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+49, 20102, 530, 3523, 3712, '0', 0, 0, 0, 0, 2975.743896484375, 3650.292236328125, 143.17138671875, 5.235987663269042968, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: Area 52 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+-- K3
+(@CGUID+50, 20102, 571, 67, 4418, '0', 0, 0, 0, 0, 6191.5458984375, -1058.80908203125, 409.8868408203125, 0.383972436189651489, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: K3 - Difficulty: 0)
+(@CGUID+51, 20102, 571, 67, 4418, '0', 0, 0, 0, 0, 6193.6259765625, -1057.967041015625, 409.848846435546875, 3.700098037719726562, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: K3 - Difficulty: 0)
+-- Dalaran
+(@CGUID+52, 18927, 571, 4395, 4568, '0', 0, 0, 0, 0, 5664.3662109375, 668.046875, 652.05072021484375, 4.904375076293945312, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Human Commoner (Area: The Eventide - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+53, 18927, 571, 4395, 4568, '0', 0, 0, 0, 0, 5740.70947265625, 686.12152099609375, 643.89654541015625, 3.822271108627319335, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Human Commoner (Area: The Eventide - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+54, 18927, 571, 4395, 4568, '0', 0, 0, 0, 0, 5664.31005859375, 666.2725830078125, 652.06396484375, 1.396263360977172851, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Human Commoner (Area: The Eventide - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+55, 18927, 571, 4395, 4568, '0', 0, 0, 0, 0, 5739.3583984375, 684.62152099609375, 644.19134521484375, 0.872664630413055419, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Human Commoner (Area: The Eventide - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+56, 19169, 571, 4395, 0, '0', 0, 0, 0, 0, 5942.9462890625, 629.234375, 650.66796875, 1.570796370506286621, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Blood Elf Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+57, 19169, 571, 4395, 0, '0', 0, 0, 0, 0, 5943.16845703125, 630.89410400390625, 650.6661376953125, 4.904375076293945312, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Blood Elf Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+58, 19169, 571, 4395, 0, '0', 0, 0, 0, 0, 5899.0390625, 532.765625, 640.9793701171875, 4.904375076293945312, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Blood Elf Commoner (Area: 0 - Difficulty: 0)
+(@CGUID+59, 19169, 571, 4395, 0, '0', 0, 0, 0, 0, 5899.09619140625, 530.8975830078125, 641.05621337890625, 1.675516128540039062, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Blood Elf Commoner (Area: 0 - Difficulty: 0)
+(@CGUID+60, 20102, 571, 4395, 0, '0', 0, 0, 0, 0, 5779.501953125, 729.07293701171875, 618.6434326171875, 3.228859186172485351, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+(@CGUID+61, 20102, 571, 4395, 0, '0', 0, 0, 0, 0, 5777.6494140625, 728.8992919921875, 618.63555908203125, 0.139626339077949523, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366); -- Goblin Commoner (Area: 0 - Difficulty: 0) (Auras: 65529 - Gossip NPC Appearance - Day of the Dead (DotD), 33209 - Gossip NPC Periodic - Despawn, 33207 - Gossip NPC Periodic - Fidget, 33208 - Gossip NPC Periodic - Talk)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 850253 AND 850262;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 850277 AND 850280;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 396026 AND 396027;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 396076 AND 396085;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 850376 AND 850387;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 396023 AND 396024;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 395872 AND 395875;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 395932 AND 395943;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+61;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+( 1, 850253), -- Human
+( 2, 850253),
+( 7, 850253),
+( 9, 850253),
+(12, 850253),
+(24, 850253),
+(26, 850253),
+(50, 850253),
+(51, 850253),
+( 1, 850254),
+( 2, 850254),
+( 7, 850254),
+( 9, 850254),
+(12, 850254),
+(24, 850254),
+(26, 850254),
+(50, 850254),
+(51, 850254),
+( 1, 850255),
+( 2, 850255),
+( 7, 850255),
+( 9, 850255),
+(12, 850255),
+(24, 850255),
+(26, 850255),
+(50, 850255),
+(51, 850255),
+( 1, 850256),
+( 2, 850256),
+( 7, 850256),
+( 9, 850256),
+(12, 850256),
+(24, 850256),
+(26, 850256),
+(50, 850256),
+(51, 850256),
+( 1, 850257),
+( 2, 850257),
+( 7, 850257),
+( 9, 850257),
+(12, 850257),
+(24, 850257),
+(26, 850257),
+(50, 850257),
+(51, 850257),
+( 1, 850258),
+( 2, 850258),
+( 7, 850258),
+( 9, 850258),
+(12, 850258),
+(24, 850258),
+(26, 850258),
+(50, 850258),
+(51, 850258),
+( 1, 850259),
+( 2, 850259),
+( 7, 850259),
+( 9, 850259),
+(12, 850259),
+(24, 850259),
+(26, 850259),
+(50, 850259),
+(51, 850259),
+( 1, 850260),
+( 2, 850260),
+( 7, 850260),
+( 9, 850260),
+(12, 850260),
+(24, 850260),
+(26, 850260),
+(50, 850260),
+(51, 850260),
+( 1, 850261),
+( 2, 850261),
+( 7, 850261),
+( 9, 850261),
+(12, 850261),
+(24, 850261),
+(26, 850261),
+(50, 850261),
+(51, 850261),
+( 1, 850262),
+( 2, 850262),
+( 7, 850262),
+( 9, 850262),
+(12, 850262),
+(24, 850262),
+(26, 850262),
+(50, 850262),
+(51, 850262),
+( 1, 850277), -- Dwarf
+( 2, 850277),
+( 7, 850277),
+( 9, 850277),
+(12, 850277),
+(24, 850277),
+(26, 850277),
+(50, 850277),
+(51, 850277),
+( 1, 850278),
+( 2, 850278),
+( 7, 850278),
+( 9, 850278),
+(12, 850278),
+(24, 850278),
+(26, 850278),
+(50, 850278),
+(51, 850278),
+( 1, 850279), -- Gnome
+( 2, 850279),
+( 7, 850279),
+( 9, 850279),
+(12, 850279),
+(24, 850279),
+(26, 850279),
+(50, 850279),
+(51, 850279),
+( 1, 850280),
+( 2, 850280),
+( 7, 850280),
+( 9, 850280),
+(12, 850280),
+(24, 850280),
+(26, 850280),
+(50, 850280),
+(51, 850280),
+( 1, 396026), -- Night Elf
+( 2, 396026),
+( 7, 396026),
+( 9, 396026),
+(12, 396026),
+(24, 396026),
+(26, 396026),
+(50, 396026),
+(51, 396026),
+( 1, 396027),
+( 2, 396027),
+( 7, 396027),
+( 9, 396027),
+(12, 396027),
+(24, 396027),
+(26, 396027),
+(50, 396027),
+(51, 396027),
+( 1, 396076), -- Draenei
+( 2, 396076),
+( 7, 396076),
+( 9, 396076),
+(12, 396076),
+(24, 396076),
+(26, 396076),
+(50, 396076),
+(51, 396076),
+( 1, 396077),
+( 2, 396077),
+( 7, 396077),
+( 9, 396077),
+(12, 396077),
+(24, 396077),
+(26, 396077),
+(50, 396077),
+(51, 396077),
+( 1, 396078),
+( 2, 396078),
+( 7, 396078),
+( 9, 396078),
+(12, 396078),
+(24, 396078),
+(26, 396078),
+(50, 396078),
+(51, 396078),
+( 1, 396079),
+( 2, 396079),
+( 7, 396079),
+( 9, 396079),
+(12, 396079),
+(24, 396079),
+(26, 396079),
+(50, 396079),
+(51, 396079),
+( 1, 396080),
+( 2, 396080),
+( 7, 396080),
+( 9, 396080),
+(12, 396080),
+(24, 396080),
+(26, 396080),
+(50, 396080),
+(51, 396080),
+( 1, 396081),
+( 2, 396081),
+( 7, 396081),
+( 9, 396081),
+(12, 396081),
+(24, 396081),
+(26, 396081),
+(50, 396081),
+(51, 396081),
+( 1, 396082),
+( 2, 396082),
+( 7, 396082),
+( 9, 396082),
+(12, 396082),
+(24, 396082),
+(26, 396082),
+(50, 396082),
+(51, 396082),
+( 1, 396083),
+( 2, 396083),
+( 7, 396083),
+( 9, 396083),
+(12, 396083),
+(24, 396083),
+(26, 396083),
+(50, 396083),
+(51, 396083),
+( 1, 396084),
+( 2, 396084),
+( 7, 396084),
+( 9, 396084),
+(12, 396084),
+(24, 396084),
+(26, 396084),
+(50, 396084),
+(51, 396084),
+( 1, 396085),
+( 2, 396085),
+( 7, 396085),
+( 9, 396085),
+(12, 396085),
+(24, 396085),
+(26, 396085),
+(50, 396085),
+(51, 396085),
+( 1, 850376), -- Orc
+( 2, 850376),
+( 7, 850376),
+( 9, 850376),
+(12, 850376),
+(24, 850376),
+(26, 850376),
+(50, 850376),
+(51, 850376),
+( 1, 850377),
+( 2, 850377),
+( 7, 850377),
+( 9, 850377),
+(12, 850377),
+(24, 850377),
+(26, 850377),
+(50, 850377),
+(51, 850377),
+( 1, 850378),
+( 2, 850378),
+( 7, 850378),
+( 9, 850378),
+(12, 850378),
+(24, 850378),
+(26, 850378),
+(50, 850378),
+(51, 850378),
+( 1, 850379),
+( 2, 850379),
+( 7, 850379),
+( 9, 850379),
+(12, 850379),
+(24, 850379),
+(26, 850379),
+(50, 850379),
+(51, 850379),
+( 1, 850380), -- Troll
+( 2, 850380),
+( 7, 850380),
+( 9, 850380),
+(12, 850380),
+(24, 850380),
+(26, 850380),
+(50, 850380),
+(51, 850380),
+( 1, 850381),
+( 2, 850381),
+( 7, 850381),
+( 9, 850381),
+(12, 850381),
+(24, 850381),
+(26, 850381),
+(50, 850381),
+(51, 850381),
+( 1, 850384),
+( 2, 850384),
+( 7, 850384),
+( 9, 850384),
+(12, 850384),
+(24, 850384),
+(26, 850384),
+(50, 850384),
+(51, 850384),
+( 1, 850386),
+( 2, 850386),
+( 7, 850386),
+( 9, 850386),
+(12, 850386),
+(24, 850386),
+(26, 850386),
+(50, 850386),
+(51, 850386),
+( 1, 850387),
+( 2, 850387),
+( 7, 850387),
+( 9, 850387),
+(12, 850387),
+(24, 850387),
+(26, 850387),
+(50, 850387),
+(51, 850387),
+( 1, 850382), -- Tauren
+( 2, 850382),
+( 7, 850382),
+( 9, 850382),
+(12, 850382),
+(24, 850382),
+(26, 850382),
+(50, 850382),
+(51, 850382),
+( 1, 850383),
+( 2, 850383),
+( 7, 850383),
+( 9, 850383),
+(12, 850383),
+(24, 850383),
+(26, 850383),
+(50, 850383),
+(51, 850383),
+( 1, 850385),
+( 2, 850385),
+( 7, 850385),
+( 9, 850385),
+(12, 850385),
+(24, 850385),
+(26, 850385),
+(50, 850385),
+(51, 850385),
+( 1, 396023),
+( 2, 396023),
+( 7, 396023),
+( 9, 396023),
+(12, 396023),
+(24, 396023),
+(26, 396023),
+(50, 396023),
+(51, 396023),
+( 1, 396024),
+( 2, 396024),
+( 7, 396024),
+( 9, 396024),
+(12, 396024),
+(24, 396024),
+(26, 396024),
+(50, 396024),
+(51, 396024),
+( 1, 395872), -- Forsaken
+( 2, 395872),
+( 7, 395872),
+( 9, 395872),
+(12, 395872),
+(24, 395872),
+(26, 395872),
+(50, 395872),
+(51, 395872),
+( 1, 395873),
+( 2, 395873),
+( 7, 395873),
+( 9, 395873),
+(12, 395873),
+(24, 395873),
+(26, 395873),
+(50, 395873),
+(51, 395873),
+( 1, 395874),
+( 2, 395874),
+( 7, 395874),
+( 9, 395874),
+(12, 395874),
+(24, 395874),
+(26, 395874),
+(50, 395874),
+(51, 395874),
+( 1, 395875),
+( 2, 395875),
+( 7, 395875),
+( 9, 395875),
+(12, 395875),
+(24, 395875),
+(26, 395875),
+(50, 395875),
+(51, 395875),
+( 1, 395932), -- Blood Elf
+( 2, 395932),
+( 7, 395932),
+( 9, 395932),
+(12, 395932),
+(24, 395932),
+(26, 395932),
+(50, 395932),
+(51, 395932),
+( 1, 395933),
+( 2, 395933),
+( 7, 395933),
+( 9, 395933),
+(12, 395933),
+(24, 395933),
+(26, 395933),
+(50, 395933),
+(51, 395933),
+( 1, 395934),
+( 2, 395934),
+( 7, 395934),
+( 9, 395934),
+(12, 395934),
+(24, 395934),
+(26, 395934),
+(50, 395934),
+(51, 395934),
+( 1, 395935),
+( 2, 395935),
+( 7, 395935),
+( 9, 395935),
+(12, 395935),
+(24, 395935),
+(26, 395935),
+(50, 395935),
+(51, 395935),
+( 1, 395936),
+( 2, 395936),
+( 7, 395936),
+( 9, 395936),
+(12, 395936),
+(24, 395936),
+(26, 395936),
+(50, 395936),
+(51, 395936),
+( 1, 395937),
+( 2, 395937),
+( 7, 395937),
+( 9, 395937),
+(12, 395937),
+(24, 395937),
+(26, 395937),
+(50, 395937),
+(51, 395937),
+( 1, 395938),
+( 2, 395938),
+( 7, 395938),
+( 9, 395938),
+(12, 395938),
+(24, 395938),
+(26, 395938),
+(50, 395938),
+(51, 395938),
+( 1, 395939),
+( 2, 395939),
+( 7, 395939),
+( 9, 395939),
+(12, 395939),
+(24, 395939),
+(26, 395939),
+(50, 395939),
+(51, 395939),
+( 1, 395940),
+( 2, 395940),
+( 7, 395940),
+( 9, 395940),
+(12, 395940),
+(24, 395940),
+(26, 395940),
+(50, 395940),
+(51, 395940),
+( 1, 395941),
+( 2, 395941),
+( 7, 395941),
+( 9, 395941),
+(12, 395941),
+(24, 395941),
+(26, 395941),
+(50, 395941),
+(51, 395941),
+( 1, 395942),
+( 2, 395942),
+( 7, 395942),
+( 9, 395942),
+(12, 395942),
+(24, 395942),
+(26, 395942),
+(50, 395942),
+(51, 395942),
+( 1, 395943),
+( 2, 395943),
+( 7, 395943),
+( 9, 395943),
+(12, 395943),
+(24, 395943),
+(26, 395943),
+(50, 395943),
+(51, 395943),
+( 1, @CGUID+0), -- New spawns
+( 2, @CGUID+0),
+( 7, @CGUID+0),
+( 9, @CGUID+0),
+(12, @CGUID+0),
+(24, @CGUID+0),
+(26, @CGUID+0),
+(50, @CGUID+0),
+(51, @CGUID+0),
+( 1, @CGUID+1),
+( 2, @CGUID+1),
+( 7, @CGUID+1),
+( 9, @CGUID+1),
+(12, @CGUID+1),
+(24, @CGUID+1),
+(26, @CGUID+1),
+(50, @CGUID+1),
+(51, @CGUID+1),
+( 1, @CGUID+2),
+( 2, @CGUID+2),
+( 7, @CGUID+2),
+( 9, @CGUID+2),
+(12, @CGUID+2),
+(24, @CGUID+2),
+(26, @CGUID+2),
+(50, @CGUID+2),
+(51, @CGUID+2),
+( 1, @CGUID+3),
+( 2, @CGUID+3),
+( 7, @CGUID+3),
+( 9, @CGUID+3),
+(12, @CGUID+3),
+(24, @CGUID+3),
+(26, @CGUID+3),
+(50, @CGUID+3),
+(51, @CGUID+3),
+( 1, @CGUID+4),
+( 2, @CGUID+4),
+( 7, @CGUID+4),
+( 9, @CGUID+4),
+(12, @CGUID+4),
+(24, @CGUID+4),
+(26, @CGUID+4),
+(50, @CGUID+4),
+(51, @CGUID+4),
+( 1, @CGUID+5),
+( 2, @CGUID+5),
+( 7, @CGUID+5),
+( 9, @CGUID+5),
+(12, @CGUID+5),
+(24, @CGUID+5),
+(26, @CGUID+5),
+(50, @CGUID+5),
+(51, @CGUID+5),
+( 1, @CGUID+6),
+( 2, @CGUID+6),
+( 7, @CGUID+6),
+( 9, @CGUID+6),
+(12, @CGUID+6),
+(24, @CGUID+6),
+(26, @CGUID+6),
+(50, @CGUID+6),
+(51, @CGUID+6),
+( 1, @CGUID+7),
+( 2, @CGUID+7),
+( 7, @CGUID+7),
+( 9, @CGUID+7),
+(12, @CGUID+7),
+(24, @CGUID+7),
+(26, @CGUID+7),
+(50, @CGUID+7),
+(51, @CGUID+7),
+( 1, @CGUID+8),
+( 2, @CGUID+8),
+( 7, @CGUID+8),
+( 9, @CGUID+8),
+(12, @CGUID+8),
+(24, @CGUID+8),
+(26, @CGUID+8),
+(50, @CGUID+8),
+(51, @CGUID+8),
+( 1, @CGUID+9),
+( 2, @CGUID+9),
+( 7, @CGUID+9),
+( 9, @CGUID+9),
+(12, @CGUID+9),
+(24, @CGUID+9),
+(26, @CGUID+9),
+(50, @CGUID+9),
+(51, @CGUID+9),
+( 1, @CGUID+10),
+( 2, @CGUID+10),
+( 7, @CGUID+10),
+( 9, @CGUID+10),
+(12, @CGUID+10),
+(24, @CGUID+10),
+(26, @CGUID+10),
+(50, @CGUID+10),
+(51, @CGUID+10),
+( 1, @CGUID+11),
+( 2, @CGUID+11),
+( 7, @CGUID+11),
+( 9, @CGUID+11),
+(12, @CGUID+11),
+(24, @CGUID+11),
+(26, @CGUID+11),
+(50, @CGUID+11),
+(51, @CGUID+11),
+( 1, @CGUID+12),
+( 2, @CGUID+12),
+( 7, @CGUID+12),
+( 9, @CGUID+12),
+(12, @CGUID+12),
+(24, @CGUID+12),
+(26, @CGUID+12),
+(50, @CGUID+12),
+(51, @CGUID+12),
+( 1, @CGUID+13),
+( 2, @CGUID+13),
+( 7, @CGUID+13),
+( 9, @CGUID+13),
+(12, @CGUID+13),
+(24, @CGUID+13),
+(26, @CGUID+13),
+(50, @CGUID+13),
+(51, @CGUID+13),
+( 1, @CGUID+14),
+( 2, @CGUID+14),
+( 7, @CGUID+14),
+( 9, @CGUID+14),
+(12, @CGUID+14),
+(24, @CGUID+14),
+(26, @CGUID+14),
+(50, @CGUID+14),
+(51, @CGUID+14),
+( 1, @CGUID+15),
+( 2, @CGUID+15),
+( 7, @CGUID+15),
+( 9, @CGUID+15),
+(12, @CGUID+15),
+(24, @CGUID+15),
+(26, @CGUID+15),
+(50, @CGUID+15),
+(51, @CGUID+15),
+( 1, @CGUID+16),
+( 2, @CGUID+16),
+( 7, @CGUID+16),
+( 9, @CGUID+16),
+(12, @CGUID+16),
+(24, @CGUID+16),
+(26, @CGUID+16),
+(50, @CGUID+16),
+(51, @CGUID+16),
+( 1, @CGUID+17),
+( 2, @CGUID+17),
+( 7, @CGUID+17),
+( 9, @CGUID+17),
+(12, @CGUID+17),
+(24, @CGUID+17),
+(26, @CGUID+17),
+(50, @CGUID+17),
+(51, @CGUID+17),
+( 1, @CGUID+18),
+( 2, @CGUID+18),
+( 7, @CGUID+18),
+( 9, @CGUID+18),
+(12, @CGUID+18),
+(24, @CGUID+18),
+(26, @CGUID+18),
+(50, @CGUID+18),
+(51, @CGUID+18),
+( 1, @CGUID+19),
+( 2, @CGUID+19),
+( 7, @CGUID+19),
+( 9, @CGUID+19),
+(12, @CGUID+19),
+(24, @CGUID+19),
+(26, @CGUID+19),
+(50, @CGUID+19),
+(51, @CGUID+19),
+( 1, @CGUID+20),
+( 2, @CGUID+20),
+( 7, @CGUID+20),
+( 9, @CGUID+20),
+(12, @CGUID+20),
+(24, @CGUID+20),
+(26, @CGUID+20),
+(50, @CGUID+20),
+(51, @CGUID+20),
+( 1, @CGUID+21),
+( 2, @CGUID+21),
+( 7, @CGUID+21),
+( 9, @CGUID+21),
+(12, @CGUID+21),
+(24, @CGUID+21),
+(26, @CGUID+21),
+(50, @CGUID+21),
+(51, @CGUID+21),
+( 1, @CGUID+22),
+( 2, @CGUID+22),
+( 7, @CGUID+22),
+( 9, @CGUID+22),
+(12, @CGUID+22),
+(24, @CGUID+22),
+(26, @CGUID+22),
+(50, @CGUID+22),
+(51, @CGUID+22),
+( 1, @CGUID+23),
+( 2, @CGUID+23),
+( 7, @CGUID+23),
+( 9, @CGUID+23),
+(12, @CGUID+23),
+(24, @CGUID+23),
+(26, @CGUID+23),
+(50, @CGUID+23),
+(51, @CGUID+23),
+( 1, @CGUID+24),
+( 2, @CGUID+24),
+( 7, @CGUID+24),
+( 9, @CGUID+24),
+(12, @CGUID+24),
+(24, @CGUID+24),
+(26, @CGUID+24),
+(50, @CGUID+24),
+(51, @CGUID+24),
+( 1, @CGUID+25),
+( 2, @CGUID+25),
+( 7, @CGUID+25),
+( 9, @CGUID+25),
+(12, @CGUID+25),
+(24, @CGUID+25),
+(26, @CGUID+25),
+(50, @CGUID+25),
+(51, @CGUID+25),
+( 1, @CGUID+26),
+( 2, @CGUID+26),
+( 7, @CGUID+26),
+( 9, @CGUID+26),
+(12, @CGUID+26),
+(24, @CGUID+26),
+(26, @CGUID+26),
+(50, @CGUID+26),
+(51, @CGUID+26),
+( 1, @CGUID+27),
+( 2, @CGUID+27),
+( 7, @CGUID+27),
+( 9, @CGUID+27),
+(12, @CGUID+27),
+(24, @CGUID+27),
+(26, @CGUID+27),
+(50, @CGUID+27),
+(51, @CGUID+27),
+( 1, @CGUID+28),
+( 2, @CGUID+28),
+( 7, @CGUID+28),
+( 9, @CGUID+28),
+(12, @CGUID+28),
+(24, @CGUID+28),
+(26, @CGUID+28),
+(50, @CGUID+28),
+(51, @CGUID+28),
+( 1, @CGUID+29),
+( 2, @CGUID+29),
+( 7, @CGUID+29),
+( 9, @CGUID+29),
+(12, @CGUID+29),
+(24, @CGUID+29),
+(26, @CGUID+29),
+(50, @CGUID+29),
+(51, @CGUID+29),
+( 1, @CGUID+30),
+( 2, @CGUID+30),
+( 7, @CGUID+30),
+( 9, @CGUID+30),
+(12, @CGUID+30),
+(24, @CGUID+30),
+(26, @CGUID+30),
+(50, @CGUID+30),
+(51, @CGUID+30),
+( 1, @CGUID+31),
+( 2, @CGUID+31),
+( 7, @CGUID+31),
+( 9, @CGUID+31),
+(12, @CGUID+31),
+(24, @CGUID+31),
+(26, @CGUID+31),
+(50, @CGUID+31),
+(51, @CGUID+31),
+( 1, @CGUID+32),
+( 2, @CGUID+32),
+( 7, @CGUID+32),
+( 9, @CGUID+32),
+(12, @CGUID+32),
+(24, @CGUID+32),
+(26, @CGUID+32),
+(50, @CGUID+32),
+(51, @CGUID+32),
+( 1, @CGUID+33),
+( 2, @CGUID+33),
+( 7, @CGUID+33),
+( 9, @CGUID+33),
+(12, @CGUID+33),
+(24, @CGUID+33),
+(26, @CGUID+33),
+(50, @CGUID+33),
+(51, @CGUID+33),
+( 1, @CGUID+34),
+( 2, @CGUID+34),
+( 7, @CGUID+34),
+( 9, @CGUID+34),
+(12, @CGUID+34),
+(24, @CGUID+34),
+(26, @CGUID+34),
+(50, @CGUID+34),
+(51, @CGUID+34),
+( 1, @CGUID+35),
+( 2, @CGUID+35),
+( 7, @CGUID+35),
+( 9, @CGUID+35),
+(12, @CGUID+35),
+(24, @CGUID+35),
+(26, @CGUID+35),
+(50, @CGUID+35),
+(51, @CGUID+35),
+( 1, @CGUID+36),
+( 2, @CGUID+36),
+( 7, @CGUID+36),
+( 9, @CGUID+36),
+(12, @CGUID+36),
+(24, @CGUID+36),
+(26, @CGUID+36),
+(50, @CGUID+36),
+(51, @CGUID+36),
+( 1, @CGUID+37),
+( 2, @CGUID+37),
+( 7, @CGUID+37),
+( 9, @CGUID+37),
+(12, @CGUID+37),
+(24, @CGUID+37),
+(26, @CGUID+37),
+(50, @CGUID+37),
+(51, @CGUID+37),
+( 1, @CGUID+38),
+( 2, @CGUID+38),
+( 7, @CGUID+38),
+( 9, @CGUID+38),
+(12, @CGUID+38),
+(24, @CGUID+38),
+(26, @CGUID+38),
+(50, @CGUID+38),
+(51, @CGUID+38),
+( 1, @CGUID+39),
+( 2, @CGUID+39),
+( 7, @CGUID+39),
+( 9, @CGUID+39),
+(12, @CGUID+39),
+(24, @CGUID+39),
+(26, @CGUID+39),
+(50, @CGUID+39),
+(51, @CGUID+39),
+( 1, @CGUID+40),
+( 2, @CGUID+40),
+( 7, @CGUID+40),
+( 9, @CGUID+40),
+(12, @CGUID+40),
+(24, @CGUID+40),
+(26, @CGUID+40),
+(50, @CGUID+40),
+(51, @CGUID+40),
+( 1, @CGUID+41),
+( 2, @CGUID+41),
+( 7, @CGUID+41),
+( 9, @CGUID+41),
+(12, @CGUID+41),
+(24, @CGUID+41),
+(26, @CGUID+41),
+(50, @CGUID+41),
+(51, @CGUID+41),
+( 1, @CGUID+42),
+( 2, @CGUID+42),
+( 7, @CGUID+42),
+( 9, @CGUID+42),
+(12, @CGUID+42),
+(24, @CGUID+42),
+(26, @CGUID+42),
+(50, @CGUID+42),
+(51, @CGUID+42),
+( 1, @CGUID+43),
+( 2, @CGUID+43),
+( 7, @CGUID+43),
+( 9, @CGUID+43),
+(12, @CGUID+43),
+(24, @CGUID+43),
+(26, @CGUID+43),
+(50, @CGUID+43),
+(51, @CGUID+43),
+( 1, @CGUID+44),
+( 2, @CGUID+44),
+( 7, @CGUID+44),
+( 9, @CGUID+44),
+(12, @CGUID+44),
+(24, @CGUID+44),
+(26, @CGUID+44),
+(50, @CGUID+44),
+(51, @CGUID+44),
+( 1, @CGUID+45),
+( 2, @CGUID+45),
+( 7, @CGUID+45),
+( 9, @CGUID+45),
+(12, @CGUID+45),
+(24, @CGUID+45),
+(26, @CGUID+45),
+(50, @CGUID+45),
+(51, @CGUID+45),
+( 1, @CGUID+46),
+( 2, @CGUID+46),
+( 7, @CGUID+46),
+( 9, @CGUID+46),
+(12, @CGUID+46),
+(24, @CGUID+46),
+(26, @CGUID+46),
+(50, @CGUID+46),
+(51, @CGUID+46),
+( 1, @CGUID+47),
+( 2, @CGUID+47),
+( 7, @CGUID+47),
+( 9, @CGUID+47),
+(12, @CGUID+47),
+(24, @CGUID+47),
+(26, @CGUID+47),
+(50, @CGUID+47),
+(51, @CGUID+47),
+( 1, @CGUID+48),
+( 2, @CGUID+48),
+( 7, @CGUID+48),
+( 9, @CGUID+48),
+(12, @CGUID+48),
+(24, @CGUID+48),
+(26, @CGUID+48),
+(50, @CGUID+48),
+(51, @CGUID+48),
+( 1, @CGUID+49),
+( 2, @CGUID+49),
+( 7, @CGUID+49),
+( 9, @CGUID+49),
+(12, @CGUID+49),
+(24, @CGUID+49),
+(26, @CGUID+49),
+(50, @CGUID+49),
+(51, @CGUID+49),
+( 1, @CGUID+50),
+( 2, @CGUID+50),
+( 7, @CGUID+50),
+( 9, @CGUID+50),
+(12, @CGUID+50),
+(24, @CGUID+50),
+(26, @CGUID+50),
+(50, @CGUID+50),
+(51, @CGUID+50),
+( 1, @CGUID+51),
+( 2, @CGUID+51),
+( 7, @CGUID+51),
+( 9, @CGUID+51),
+(12, @CGUID+51),
+(24, @CGUID+51),
+(26, @CGUID+51),
+(50, @CGUID+51),
+(51, @CGUID+51),
+( 1, @CGUID+52),
+( 2, @CGUID+52),
+( 7, @CGUID+52),
+( 9, @CGUID+52),
+(12, @CGUID+52),
+(24, @CGUID+52),
+(26, @CGUID+52),
+(50, @CGUID+52),
+(51, @CGUID+52),
+( 1, @CGUID+53),
+( 2, @CGUID+53),
+( 7, @CGUID+53),
+( 9, @CGUID+53),
+(12, @CGUID+53),
+(24, @CGUID+53),
+(26, @CGUID+53),
+(50, @CGUID+53),
+(51, @CGUID+53),
+( 1, @CGUID+54),
+( 2, @CGUID+54),
+( 7, @CGUID+54),
+( 9, @CGUID+54),
+(12, @CGUID+54),
+(24, @CGUID+54),
+(26, @CGUID+54),
+(50, @CGUID+54),
+(51, @CGUID+54),
+( 1, @CGUID+55),
+( 2, @CGUID+55),
+( 7, @CGUID+55),
+( 9, @CGUID+55),
+(12, @CGUID+55),
+(24, @CGUID+55),
+(26, @CGUID+55),
+(50, @CGUID+55),
+(51, @CGUID+55),
+( 1, @CGUID+56),
+( 2, @CGUID+56),
+( 7, @CGUID+56),
+( 9, @CGUID+56),
+(12, @CGUID+56),
+(24, @CGUID+56),
+(26, @CGUID+56),
+(50, @CGUID+56),
+(51, @CGUID+56),
+( 1, @CGUID+57),
+( 2, @CGUID+57),
+( 7, @CGUID+57),
+( 9, @CGUID+57),
+(12, @CGUID+57),
+(24, @CGUID+57),
+(26, @CGUID+57),
+(50, @CGUID+57),
+(51, @CGUID+57),
+( 1, @CGUID+58),
+( 2, @CGUID+58),
+( 7, @CGUID+58),
+( 9, @CGUID+58),
+(12, @CGUID+58),
+(24, @CGUID+58),
+(26, @CGUID+58),
+(50, @CGUID+58),
+(51, @CGUID+58),
+( 1, @CGUID+59),
+( 2, @CGUID+59),
+( 7, @CGUID+59),
+( 9, @CGUID+59),
+(12, @CGUID+59),
+(24, @CGUID+59),
+(26, @CGUID+59),
+(50, @CGUID+59),
+(51, @CGUID+59),
+( 1, @CGUID+60),
+( 2, @CGUID+60),
+( 7, @CGUID+60),
+( 9, @CGUID+60),
+(12, @CGUID+60),
+(24, @CGUID+60),
+(26, @CGUID+60),
+(50, @CGUID+60),
+(51, @CGUID+60),
+( 1, @CGUID+61),
+( 2, @CGUID+61),
+( 7, @CGUID+61),
+( 9, @CGUID+61),
+(12, @CGUID+61),
+(24, @CGUID+61),
+(26, @CGUID+61),
+(50, @CGUID+61),
+(51, @CGUID+61);