-- Add 14 missing Battered Chest ID: 106318 with pooling in Dun Morogh
SET @OGUID := XXXXX; -- 14 required
SET @POOLID := XXXXX; -- 7 required
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+13;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@OGUID+XX, 106318, 0, 1, 134, 1, 1, -5825.66162109375, -1594.9251708984375, 361.824310302734375, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 360, 255, 1, 42917), -- Gol'Bolar Quarry
(@OGUID+XX, 106318, 0, 1, 134, 1, 1, -5632.2060546875, -1793.3677978515625, 358.769439697265625, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 360, 255, 1, 42917), -- Gol'Bolar Quarry Mine
(@OGUID+XX, 106318, 0, 1, 135, 1, 1, -5581.7119140625, 731.79241943359375, 391.769195556640625, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 360, 255, 1, 42873), -- Frostmane Hold
(@OGUID+XX, 106318, 0, 1, 0, 1, 1, -5423.45361328125, -307.8590087890625, 358.593780517578125, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 360, 255, 1, 42083), -- The Grizzled Den
(@OGUID+XX, 106318, 0, 1, 802, 1, 1, -5299.7451171875, -105.226783752441406, 403.3951416015625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 360, 255, 1, 42083), -- Iceflow Lake
(@OGUID+XX, 106318, 0, 1, 0, 1, 1, -5335.97021484375, -238.182785034179687, 440.33062744140625, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 360, 255, 1, 42083), -- Shimmer Ridge
(@OGUID+XX, 106318, 0, 1, 134, 1, 1, -5867.875, -1521.5382080078125, 379.034820556640625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 360, 255, 1, 42083), -- Gol'Bolar Quarry
(@OGUID+XX, 106318, 0, 1, 136, 1, 1, -5454.0654296875, -170.441360473632812, 349.799285888671875, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 360, 255, 1, 42083), -- The Grizzled Den
(@OGUID+XX, 106318, 0, 1, 135, 1, 1, -5658.513671875, 657.26531982421875, 383.4482421875, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 360, 255, 1, 42083), -- Frostmane Hold
(@OGUID+XX, 106318, 0, 1, 802, 1, 1, -5055.85009765625, -264.971588134765625, 442.078887939453125, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 360, 255, 1, 42083), -- Shimmer Ridge
-- 4 from Mangos DB
(@OGUID+XX, 106318, 0, 1, 0, 1, 1, -5906.34, -1873.73, 404.95, 5.91667, 0, 0, -0.182235, 0.983255, 360, 255, 1, 0), -- Ironbands Compound
(@OGUID+XX, 106318, 0, 1, 0, 1, 1, -5786.93, -1941.07, 402.297, -1.53589, 0, 0, 0, 0, 360, 255, 1, 0), -- Helm's Bed Lake
(@OGUID+XX, 106318, 0, 1, 0, 1, 1, -5533.53, -1703.44, 342.487, -2.04204, 0, 0, 0, 0, 360, 255, 1, 0), -- Gol'Bolar Quarry Mine
(@OGUID+XX, 106318, 0, 1, 0, 1, 1, -5480.54, -214.69, 354.253, 3.85718, 0, 0, -0.936671, 0.35021, 360, 255, 1, 0); -- The Grizzled Den