moonwell-core-vanilla/sql/migrations/20230625114319_world.sql

DROP PROCEDURE IF EXISTS add_migration;
delimiter ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20230625114319');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230625114319');
-- Add your query below.


SET @OGUID = 56274;
SET @PTEMPLATE = 2928;

-- Stranglethorn Vale
DELETE FROM `gameobject` WHERE `guid` IN (11145, 11146, 11147, 11148, 11149, 11153, 11645, 11650, 11661, 11662, 11663, 11668, 11688, 11689, 11700, 11701, 11703, 11804, 11968, 11986, 12053, 12059, 12060, 12062, 12074, 12075, 12076, 12077, 18146, 18147, 18148, 18149, 32090, 32091, 47318, 47319, 47320, 47321, 47322, 47323, 47324, 47325, 47326, 47327, 47328, 47329, 47330, 47331, 47332, 47333, 47334, 47335, 47336, 47337, 47338, 47339, 47340, 47341, 47342, 47343, 47344, 47345, 47346, 47348, 47349, 47407, 47408, 47409, 47410, 47412, 47414, 47415, 47419, 47420, 47421, 47422, 47428, 47429, 47430, 47433, 47434, 47435, 47436, 47437, 47439, 47441, 47442, 47443, 47446, 47448, 47453, 47463, 47464, 47466, 47467, 47469, 47470, 47471, 47472, 47474, 47475, 47476, 47477, 47478, 47479, 47505, 47506, 47507, 47508, 47509, 47510, 47511, 47512, 47513, 47528, 47529, 47530, 47531, 47536, 47537, 47539, 47540, 47541, 47543, 47544, 47545, 47546, 47547, 47548, 47549, 47550, 47551, 50315, 50316, 50317, 50318, 50319, 50320, 50321, 50344, 50346, 64623, 64627);
DELETE FROM `pool_gameobject` WHERE `guid` IN (11145, 11146, 11147, 11148, 11149, 11153, 11645, 11650, 11661, 11662, 11663, 11668, 11688, 11689, 11700, 11701, 11703, 11804, 11968, 11986, 12053, 12059, 12060, 12062, 12074, 12075, 12076, 12077, 18146, 18147, 18148, 18149, 32090, 32091, 47318, 47319, 47320, 47321, 47322, 47323, 47324, 47325, 47326, 47327, 47328, 47329, 47330, 47331, 47332, 47333, 47334, 47335, 47336, 47337, 47338, 47339, 47340, 47341, 47342, 47343, 47344, 47345, 47346, 47348, 47349, 47407, 47408, 47409, 47410, 47412, 47414, 47415, 47419, 47420, 47421, 47422, 47428, 47429, 47430, 47433, 47434, 47435, 47436, 47437, 47439, 47441, 47442, 47443, 47446, 47448, 47453, 47463, 47464, 47466, 47467, 47469, 47470, 47471, 47472, 47474, 47475, 47476, 47477, 47478, 47479, 47505, 47506, 47507, 47508, 47509, 47510, 47511, 47512, 47513, 47528, 47529, 47530, 47531, 47536, 47537, 47539, 47540, 47541, 47543, 47544, 47545, 47546, 47547, 47548, 47549, 47550, 47551, 50315, 50316, 50317, 50318, 50319, 50320, 50321, 50344, 50346, 64623, 64627);
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (11145, 11146, 11147, 11148, 11149, 11153, 11645, 11650, 11661, 11662, 11663, 11668, 11688, 11689, 11700, 11701, 11703, 11804, 11968, 11986, 12053, 12059, 12060, 12062, 12074, 12075, 12076, 12077, 18146, 18147, 18148, 18149, 32090, 32091, 47318, 47319, 47320, 47321, 47322, 47323, 47324, 47325, 47326, 47327, 47328, 47329, 47330, 47331, 47332, 47333, 47334, 47335, 47336, 47337, 47338, 47339, 47340, 47341, 47342, 47343, 47344, 47345, 47346, 47348, 47349, 47407, 47408, 47409, 47410, 47412, 47414, 47415, 47419, 47420, 47421, 47422, 47428, 47429, 47430, 47433, 47434, 47435, 47436, 47437, 47439, 47441, 47442, 47443, 47446, 47448, 47453, 47463, 47464, 47466, 47467, 47469, 47470, 47471, 47472, 47474, 47475, 47476, 47477, 47478, 47479, 47505, 47506, 47507, 47508, 47509, 47510, 47511, 47512, 47513, 47528, 47529, 47530, 47531, 47536, 47537, 47539, 47540, 47541, 47543, 47544, 47545, 47546, 47547, 47548, 47549, 47550, 47551, 50315, 50316, 50317, 50318, 50319, 50320, 50321, 50344, 50346, 64623, 64627));

INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, 180901, 0, -14773.3, 532.5, 0, 4.36332, 0, 0, -0.819152, 0.573577, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+2, 180901, 0, -14726, 353.928, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+3, 180901, 0, -14708.2, 262.638, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+4, 180901, 0, -14678.3, 553.845, 0, 2.54818, 0, 0, 0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+5, 180901, 0, -14659.1, 196.393, 0, 5.37562, 0, 0, -0.438371, 0.898794, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+6, 180901, 0, -14597.8, 143.019, 0, 1.46608, 0, 0, 0.66913, 0.743145, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+7, 180901, 0, -14488.5, 67.7705, 0, 2.70526, 0, 0, 0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+8, 180901, 0, -14424.6, 465.557, 0, 3.12412, 0, 0, 0.999962, 0.00873464, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+9, 180901, 0, -14401.4, 438.454, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+10, 180901, 0, -14347.4, 54.1188, 0, 6.03884, 0, 0, -0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+11, 180901, 0, -14345, 481.232, 0, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+12, 180901, 0, -14320.4, 529.485, 0, 3.61284, 0, 0, -0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+13, 180901, 0, -14144.4, -102.984, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+14, 180901, 0, -14141.9, 517.923, 0, 2.72271, 0, 0, 0.978148, 0.207912, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+15, 180901, 0, -14012.5, 599.186, 0, 3.07177, 0, 0, 0.999391, 0.0349061, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+16, 180901, 0, -13952.5, 695.664, 0, 5.20108, 0, 0, -0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+17, 180901, 0, -13853.3, 707.847, 0, 0.436332, 0, 0, 0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+18, 180901, 0, -13842.1, -236.72, 0, 3.97935, 0, 0, -0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+19, 180901, 0, -13779.9, 703.536, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+20, 180901, 0, -13696, -419.378, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+21, 180901, 0, -13693.8, 670.814, 0, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+22, 180901, 0, -13646.9, 547.157, 0, 1.95477, 0, 0, 0.829038, 0.559193, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+23, 180901, 0, -13629.8, -437.232, 0, 5.18363, 0, 0, -0.522498, 0.85264, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+24, 180901, 0, -13568.4, 766.911, 0, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+25, 180901, 0, -13516.4, 808.229, 0, 5.39307, 0, 0, -0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+26, 180901, 0, -13414.4, 783.912, 0, 2.04204, 0, 0, 0.85264, 0.522499, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+27, 180901, 0, -13341.5, 808.699, 0, 5.74214, 0, 0, -0.267238, 0.963631, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+28, 180901, 0, -13290.2, 651.097, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+29, 180901, 0, -13244, 775.253, 0, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+30, 180901, 0, -13235.1, 558.615, 0, 3.28124, 0, 0, -0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+31, 180901, 0, -13185.8, 700.266, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+32, 180901, 0, -13150, 482.661, 0, 4.29351, 0, 0, -0.83867, 0.54464, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+33, 180901, 0, -13059.8, 506.689, 0, 1.67551, 0, 0, 0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+34, 180901, 0, -12968.7, 489.778, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+35, 180901, 0, -12909.3, 506.528, 0, 4.67748, 0, 0, -0.719339, 0.694659, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+36, 180901, 0, -12829.6, 440.834, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+37, 180901, 0, -12771.4, 378.642, 0, 5.75959, 0, 0, -0.258819, 0.965926, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+38, 180901, 0, -12749.4, 343.818, 0, 3.7001, 0, 0, -0.961261, 0.27564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+39, 180901, 0, -12727.5, 39.1558, 0, 5.95157, 0, 0, -0.165047, 0.986286, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+40, 180901, 0, -12722.4, 193.757, 0, 1.22173, 0, 0, 0.573576, 0.819152, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+41, 180901, 0, -12701.7, -21.263, 0, 4.17134, 0, 0, -0.870356, 0.492424, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+42, 180901, 0, -12679.1, 154.718, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+43, 180901, 0, -12624.6, 7.92567, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+44, 180901, 0, -13744.5, -402.947, 0, -1.76278, 0, 0, 0.771625, -0.636078, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+45, 180901, 0, -14720, 448.409, 0, 1.69297, 0, 0, 0.748956, 0.66262, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+46, 180712, 0, -14773.3, 532.5, 0, 4.36332, 0, 0, -0.819152, 0.573577, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+47, 180712, 0, -14726, 353.928, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+48, 180712, 0, -14708.2, 262.638, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+49, 180712, 0, -14678.3, 553.845, 0, 2.54818, 0, 0, 0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+50, 180712, 0, -14659.1, 196.393, 0, 5.37562, 0, 0, -0.438371, 0.898794, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+51, 180712, 0, -14597.8, 143.019, 0, 1.46608, 0, 0, 0.66913, 0.743145, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+52, 180712, 0, -14488.5, 67.7705, 0, 2.70526, 0, 0, 0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+53, 180712, 0, -14424.6, 465.557, 0, 3.12412, 0, 0, 0.999962, 0.00873464, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+54, 180712, 0, -14401.4, 438.454, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+55, 180712, 0, -14347.4, 54.1188, 0, 6.03884, 0, 0, -0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+56, 180712, 0, -14345, 481.232, 0, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+57, 180712, 0, -14320.4, 529.485, 0, 3.61284, 0, 0, -0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+58, 180712, 0, -14144.4, -102.984, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+59, 180712, 0, -14141.9, 517.923, 0, 2.72271, 0, 0, 0.978148, 0.207912, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+60, 180712, 0, -14012.5, 599.186, 0, 3.07177, 0, 0, 0.999391, 0.0349061, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+61, 180712, 0, -13952.5, 695.664, 0, 5.20108, 0, 0, -0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+62, 180712, 0, -13853.3, 707.847, 0, 0.436332, 0, 0, 0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+63, 180712, 0, -13842.1, -236.72, 0, 3.97935, 0, 0, -0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+64, 180712, 0, -13779.9, 703.536, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+65, 180712, 0, -13696, -419.378, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+66, 180712, 0, -13693.8, 670.814, 0, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+67, 180712, 0, -13646.9, 547.157, 0, 1.95477, 0, 0, 0.829038, 0.559193, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+68, 180712, 0, -13629.8, -437.232, 0, 5.18363, 0, 0, -0.522498, 0.85264, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+69, 180712, 0, -13568.4, 766.911, 0, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+70, 180712, 0, -13516.4, 808.229, 0, 5.39307, 0, 0, -0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+71, 180712, 0, -13414.4, 783.912, 0, 2.04204, 0, 0, 0.85264, 0.522499, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+72, 180712, 0, -13341.5, 808.699, 0, 5.74214, 0, 0, -0.267238, 0.963631, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+73, 180712, 0, -13290.2, 651.097, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+74, 180712, 0, -13244, 775.253, 0, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+75, 180712, 0, -13235.1, 558.615, 0, 3.28124, 0, 0, -0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+76, 180712, 0, -13185.8, 700.266, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+77, 180712, 0, -13150, 482.661, 0, 4.29351, 0, 0, -0.83867, 0.54464, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+78, 180712, 0, -13059.8, 506.689, 0, 1.67551, 0, 0, 0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+79, 180712, 0, -12968.7, 489.778, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+80, 180712, 0, -12909.3, 506.528, 0, 4.67748, 0, 0, -0.719339, 0.694659, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+81, 180712, 0, -12829.6, 440.834, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+82, 180712, 0, -12771.4, 378.642, 0, 5.75959, 0, 0, -0.258819, 0.965926, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+83, 180712, 0, -12749.4, 343.818, 0, 3.7001, 0, 0, -0.961261, 0.27564, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+84, 180712, 0, -12727.5, 39.1558, 0, 5.95157, 0, 0, -0.165047, 0.986286, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+85, 180712, 0, -12722.4, 193.757, 0, 1.22173, 0, 0, 0.573576, 0.819152, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+86, 180712, 0, -12701.7, -21.263, 0, 4.17134, 0, 0, -0.870356, 0.492424, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+87, 180712, 0, -12679.1, 154.718, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+88, 180712, 0, -12624.6, 7.92567, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+89, 180712, 0, -13744.5, -402.947, 0, -1.76278, 0, 0, 0.771625, -0.636078, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+90, 180712, 0, -14720, 448.409, 0, 1.69297, 0, 0, 0.748956, 0.66262, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+91, 180902, 0, -14773.3, 532.5, 0, 4.36332, 0, 0, -0.819152, 0.573577, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+92, 180902, 0, -14726, 353.928, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+93, 180902, 0, -14708.2, 262.638, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+94, 180902, 0, -14678.3, 553.845, 0, 2.54818, 0, 0, 0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+95, 180902, 0, -14659.1, 196.393, 0, 5.37562, 0, 0, -0.438371, 0.898794, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+96, 180902, 0, -14597.8, 143.019, 0, 1.46608, 0, 0, 0.66913, 0.743145, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+97, 180902, 0, -14488.5, 67.7705, 0, 2.70526, 0, 0, 0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+98, 180902, 0, -14424.6, 465.557, 0, 3.12412, 0, 0, 0.999962, 0.00873464, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+99, 180902, 0, -14401.4, 438.454, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+100, 180902, 0, -14347.4, 54.1188, 0, 6.03884, 0, 0, -0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+101, 180902, 0, -14345, 481.232, 0, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+102, 180902, 0, -14320.4, 529.485, 0, 3.61284, 0, 0, -0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+103, 180902, 0, -14144.4, -102.984, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+104, 180902, 0, -14141.9, 517.923, 0, 2.72271, 0, 0, 0.978148, 0.207912, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+105, 180902, 0, -14012.5, 599.186, 0, 3.07177, 0, 0, 0.999391, 0.0349061, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+106, 180902, 0, -13952.5, 695.664, 0, 5.20108, 0, 0, -0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+107, 180902, 0, -13853.3, 707.847, 0, 0.436332, 0, 0, 0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+108, 180902, 0, -13842.1, -236.72, 0, 3.97935, 0, 0, -0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+109, 180902, 0, -13779.9, 703.536, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+110, 180902, 0, -13696, -419.378, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+111, 180902, 0, -13693.8, 670.814, 0, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+112, 180902, 0, -13646.9, 547.157, 0, 1.95477, 0, 0, 0.829038, 0.559193, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+113, 180902, 0, -13629.8, -437.232, 0, 5.18363, 0, 0, -0.522498, 0.85264, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+114, 180902, 0, -13568.4, 766.911, 0, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+115, 180902, 0, -13516.4, 808.229, 0, 5.39307, 0, 0, -0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+116, 180902, 0, -13414.4, 783.912, 0, 2.04204, 0, 0, 0.85264, 0.522499, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+117, 180902, 0, -13341.5, 808.699, 0, 5.74214, 0, 0, -0.267238, 0.963631, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+118, 180902, 0, -13290.2, 651.097, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+119, 180902, 0, -13244, 775.253, 0, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+120, 180902, 0, -13235.1, 558.615, 0, 3.28124, 0, 0, -0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+121, 180902, 0, -13185.8, 700.266, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+122, 180902, 0, -13150, 482.661, 0, 4.29351, 0, 0, -0.83867, 0.54464, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+123, 180902, 0, -13059.8, 506.689, 0, 1.67551, 0, 0, 0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+124, 180902, 0, -12968.7, 489.778, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+125, 180902, 0, -12909.3, 506.528, 0, 4.67748, 0, 0, -0.719339, 0.694659, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+126, 180902, 0, -12829.6, 440.834, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+127, 180902, 0, -12771.4, 378.642, 0, 5.75959, 0, 0, -0.258819, 0.965926, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+128, 180902, 0, -12749.4, 343.818, 0, 3.7001, 0, 0, -0.961261, 0.27564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+129, 180902, 0, -12727.5, 39.1558, 0, 5.95157, 0, 0, -0.165047, 0.986286, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+130, 180902, 0, -12722.4, 193.757, 0, 1.22173, 0, 0, 0.573576, 0.819152, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+131, 180902, 0, -12701.7, -21.263, 0, 4.17134, 0, 0, -0.870356, 0.492424, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+132, 180902, 0, -12679.1, 154.718, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+133, 180902, 0, -12624.6, 7.92567, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+134, 180902, 0, -13744.5, -402.947, 0, -1.76278, 0, 0, 0.771625, -0.636078, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+135, 180902, 0, -14720, 448.409, 0, 1.69297, 0, 0, 0.748956, 0.66262, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+136, 180900, 0, -14773.3, 532.5, 0, 4.36332, 0, 0, -0.819152, 0.573577, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+137, 180900, 0, -14726, 353.928, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+138, 180900, 0, -14708.2, 262.638, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+139, 180900, 0, -14678.3, 553.845, 0, 2.54818, 0, 0, 0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+140, 180900, 0, -14659.1, 196.393, 0, 5.37562, 0, 0, -0.438371, 0.898794, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+141, 180900, 0, -14597.8, 143.019, 0, 1.46608, 0, 0, 0.66913, 0.743145, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+142, 180900, 0, -14488.5, 67.7705, 0, 2.70526, 0, 0, 0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+143, 180900, 0, -14424.6, 465.557, 0, 3.12412, 0, 0, 0.999962, 0.00873464, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+144, 180900, 0, -14401.4, 438.454, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+145, 180900, 0, -14347.4, 54.1188, 0, 6.03884, 0, 0, -0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+146, 180900, 0, -14345, 481.232, 0, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+147, 180900, 0, -14320.4, 529.485, 0, 3.61284, 0, 0, -0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+148, 180900, 0, -14144.4, -102.984, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+149, 180900, 0, -14141.9, 517.923, 0, 2.72271, 0, 0, 0.978148, 0.207912, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+150, 180900, 0, -14012.5, 599.186, 0, 3.07177, 0, 0, 0.999391, 0.0349061, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+151, 180900, 0, -13952.5, 695.664, 0, 5.20108, 0, 0, -0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+152, 180900, 0, -13853.3, 707.847, 0, 0.436332, 0, 0, 0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+153, 180900, 0, -13842.1, -236.72, 0, 3.97935, 0, 0, -0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+154, 180900, 0, -13779.9, 703.536, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+155, 180900, 0, -13696, -419.378, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+156, 180900, 0, -13693.8, 670.814, 0, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+157, 180900, 0, -13646.9, 547.157, 0, 1.95477, 0, 0, 0.829038, 0.559193, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+158, 180900, 0, -13629.8, -437.232, 0, 5.18363, 0, 0, -0.522498, 0.85264, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+159, 180900, 0, -13568.4, 766.911, 0, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+160, 180900, 0, -13516.4, 808.229, 0, 5.39307, 0, 0, -0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+161, 180900, 0, -13414.4, 783.912, 0, 2.04204, 0, 0, 0.85264, 0.522499, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+162, 180900, 0, -13341.5, 808.699, 0, 5.74214, 0, 0, -0.267238, 0.963631, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+163, 180900, 0, -13290.2, 651.097, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+164, 180900, 0, -13244, 775.253, 0, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+165, 180900, 0, -13235.1, 558.615, 0, 3.28124, 0, 0, -0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+166, 180900, 0, -13185.8, 700.266, 0, 2.63544, 0, 0, 0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+167, 180900, 0, -13150, 482.661, 0, 4.29351, 0, 0, -0.83867, 0.54464, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+168, 180900, 0, -13059.8, 506.689, 0, 1.67551, 0, 0, 0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+169, 180900, 0, -12968.7, 489.778, 0, 5.14872, 0, 0, -0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+170, 180900, 0, -12909.3, 506.528, 0, 4.67748, 0, 0, -0.719339, 0.694659, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+171, 180900, 0, -12829.6, 440.834, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+172, 180900, 0, -12771.4, 378.642, 0, 5.75959, 0, 0, -0.258819, 0.965926, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+173, 180900, 0, -12749.4, 343.818, 0, 3.7001, 0, 0, -0.961261, 0.27564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+174, 180900, 0, -12727.5, 39.1558, 0, 5.95157, 0, 0, -0.165047, 0.986286, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+175, 180900, 0, -12722.4, 193.757, 0, 1.22173, 0, 0, 0.573576, 0.819152, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+176, 180900, 0, -12701.7, -21.263, 0, 4.17134, 0, 0, -0.870356, 0.492424, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+177, 180900, 0, -12679.1, 154.718, 0, 3.31614, 0, 0, -0.996194, 0.087165, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+178, 180900, 0, -12624.6, 7.92567, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+179, 180900, 0, -13744.5, -402.947, 0, -1.76278, 0, 0, 0.771625, -0.636078, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+180, 180900, 0, -14720, 448.409, 0, 1.69297, 0, 0, 0.748956, 0.66262, 180, 180, 100, 1, 0, 0, 7, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+2, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+3, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+4, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+5, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+6, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+7, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+8, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+9, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+10, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+11, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+12, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+13, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+14, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+15, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+16, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+17, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+18, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+19, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+20, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+21, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+22, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+23, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+24, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+25, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+26, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+27, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+28, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+29, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+30, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+31, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+32, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+33, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+34, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+35, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+36, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+37, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+38, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+39, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+40, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+41, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+42, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+43, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+44, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@PTEMPLATE+45, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10);

INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES 
(@OGUID+1, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+2, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+3, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+4, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+5, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+6, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+7, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+8, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+9, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+10, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+11, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+12, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+13, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+14, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+15, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+16, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+17, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+18, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+19, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+20, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+21, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+22, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+23, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+24, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+25, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+26, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+27, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+28, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+29, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+30, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+31, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+32, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+33, @PTEMPLATE+33, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+34, @PTEMPLATE+34, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+35, @PTEMPLATE+35, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+36, @PTEMPLATE+36, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+37, @PTEMPLATE+37, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+38, @PTEMPLATE+38, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+39, @PTEMPLATE+39, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+40, @PTEMPLATE+40, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+41, @PTEMPLATE+41, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+42, @PTEMPLATE+42, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+43, @PTEMPLATE+43, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+44, @PTEMPLATE+44, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+45, @PTEMPLATE+45, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+46, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+47, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+48, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+49, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+50, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+51, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+52, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+53, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+54, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+55, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+56, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+57, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+58, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+59, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+60, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+61, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+62, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+63, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+64, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+65, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+66, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+67, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+68, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+69, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+70, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+71, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+72, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+73, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+74, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+75, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+76, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+77, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+78, @PTEMPLATE+33, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+79, @PTEMPLATE+34, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+80, @PTEMPLATE+35, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+81, @PTEMPLATE+36, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+82, @PTEMPLATE+37, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+83, @PTEMPLATE+38, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+84, @PTEMPLATE+39, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+85, @PTEMPLATE+40, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+86, @PTEMPLATE+41, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+87, @PTEMPLATE+42, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+88, @PTEMPLATE+43, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+89, @PTEMPLATE+44, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+90, @PTEMPLATE+45, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 9, 10),
(@OGUID+91, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+92, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+93, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+94, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+95, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+96, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+97, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+98, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+99, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+100, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+101, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+102, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+103, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+104, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+105, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+106, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+107, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+108, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+109, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+110, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+111, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+112, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+113, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+114, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+115, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+116, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+117, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+118, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+119, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+120, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+121, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+122, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+123, @PTEMPLATE+33, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+124, @PTEMPLATE+34, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+125, @PTEMPLATE+35, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+126, @PTEMPLATE+36, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+127, @PTEMPLATE+37, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+128, @PTEMPLATE+38, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+129, @PTEMPLATE+39, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+130, @PTEMPLATE+40, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+131, @PTEMPLATE+41, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+132, @PTEMPLATE+42, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+133, @PTEMPLATE+43, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+134, @PTEMPLATE+44, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+135, @PTEMPLATE+45, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+136, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+137, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+138, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+139, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+140, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+141, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+142, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+143, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+144, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+145, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+146, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+147, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+148, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+149, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+150, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+151, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+152, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+153, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+154, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+155, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+156, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+157, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+158, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+159, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+160, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+161, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+162, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+163, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+164, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+165, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+166, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+167, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+168, @PTEMPLATE+33, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+169, @PTEMPLATE+34, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+170, @PTEMPLATE+35, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+171, @PTEMPLATE+36, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+172, @PTEMPLATE+37, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+173, @PTEMPLATE+38, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+174, @PTEMPLATE+39, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+175, @PTEMPLATE+40, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+176, @PTEMPLATE+41, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+177, @PTEMPLATE+42, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+178, @PTEMPLATE+43, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+179, @PTEMPLATE+44, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10),
(@OGUID+180, @PTEMPLATE+45, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 7, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+46, 20, 'Stranglethorn - Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School (Master Pool)', 0, 0, 7, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+2, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+3, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+4, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+5, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+6, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+7, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+8, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+9, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+10, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+11, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+12, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+13, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+14, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+15, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+16, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+17, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+18, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+19, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+20, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+21, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+22, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+23, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+24, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+25, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+26, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+27, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+28, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+29, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+30, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+31, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+32, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+33, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+34, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+35, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+36, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+37, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+38, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+39, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+40, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+41, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+42, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+43, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+44, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0),
(@PTEMPLATE+45, @PTEMPLATE+46, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn', 0);

UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180712);
UPDATE `pool_gameobject` SET `chance` = 30 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180900);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180901);
UPDATE `pool_gameobject` SET `chance` = 30 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180902);

SET @OGUID = 50741;
SET @PTEMPLATE = 3165;

INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, 180682, 0, -12560.9, 47.653, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+2, 180682, 0, -12508.2, 122.857, 0, 2.82743, 0, 0, 0.987688, 0.156436, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+3, 180682, 0, -12397.3, 290.482, 0, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+4, 180682, 0, -12349.4, 342.822, 0, 2.26893, 0, 0, 0.906307, 0.422619, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+5, 180682, 0, -12346, 304.463, 0, 2.05949, 0, 0, 0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+6, 180682, 0, -12259.6, 344.519, 0, 1.90241, 0, 0, 0.814116, 0.580703, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+7, 180682, 0, -12202.2, 351.023, 0, 4.60767, 0, 0, -0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+8, 180682, 0, -12131.3, 369.493, 0, 5.34071, 0, 0, -0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+9, 180682, 0, -12080.1, 459.363, 0, 2.14675, 0, 0, 0.878817, 0.47716, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+10, 180682, 0, -12067.7, 871.853, 0, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+11, 180682, 0, -12043.2, 541.762, 0, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+12, 180682, 0, -12035, 804.831, 0, 2.46091, 0, 0, 0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+13, 180682, 0, -12031.4, 593.977, 0, 5.60251, 0, 0, -0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+14, 180682, 0, -12015.2, 532.893, -0.255422, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+15, 180682, 0, -12011.6, 759.599, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+16, 180682, 0, -12001.6, 651.077, 0, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+17, 180682, 0, -11993.8, 649.109, -0.949605, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+18, 180682, 0, -11975.9, 684.698, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+19, 180682, 0, -11958.1, 738.97, 0, 2.9496, 0, 0, 0.995396, 0.0958512, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+20, 180682, 0, -11950.8, 847.183, 0, 2.77507, 0, 0, 0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+21, 180682, 0, -11882, 876.11, 0, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+22, 180682, 0, -11844.9, 908.972, 0, 4.62512, 0, 0, -0.737277, 0.675591, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+23, 180682, 0, -11833.4, 1198.48, 0, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+24, 180682, 0, -11801.6, 961.14, 0, 5.84685, 0, 0, -0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+25, 180682, 0, -11749.2, 998.85, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+26, 180682, 0, -11707.8, 1092.1, 0, 0.261798, 0, 0, 0.130526, 0.991445, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+27, 180682, 0, -11642.5, 1102.82, 0, 3.45576, 0, 0, -0.987688, 0.156436, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+28, 180683, 0, -12560.9, 47.653, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+29, 180683, 0, -12508.2, 122.857, 0, 2.82743, 0, 0, 0.987688, 0.156436, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+30, 180683, 0, -12397.3, 290.482, 0, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+31, 180683, 0, -12349.4, 342.822, 0, 2.26893, 0, 0, 0.906307, 0.422619, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+32, 180683, 0, -12346, 304.463, 0, 2.05949, 0, 0, 0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+33, 180683, 0, -12259.6, 344.519, 0, 1.90241, 0, 0, 0.814116, 0.580703, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+34, 180683, 0, -12202.2, 351.023, 0, 4.60767, 0, 0, -0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+35, 180683, 0, -12131.3, 369.493, 0, 5.34071, 0, 0, -0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+36, 180683, 0, -12080.1, 459.363, 0, 2.14675, 0, 0, 0.878817, 0.47716, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+37, 180683, 0, -12067.7, 871.853, 0, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+38, 180683, 0, -12043.2, 541.762, 0, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+39, 180683, 0, -12035, 804.831, 0, 2.46091, 0, 0, 0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+40, 180683, 0, -12031.4, 593.977, 0, 5.60251, 0, 0, -0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+41, 180683, 0, -12015.2, 532.893, -0.255422, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+42, 180683, 0, -12011.6, 759.599, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+43, 180683, 0, -12001.6, 651.077, 0, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+44, 180683, 0, -11993.8, 649.109, -0.949605, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+45, 180683, 0, -11975.9, 684.698, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+46, 180683, 0, -11958.1, 738.97, 0, 2.9496, 0, 0, 0.995396, 0.0958512, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+47, 180683, 0, -11950.8, 847.183, 0, 2.77507, 0, 0, 0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+48, 180683, 0, -11882, 876.11, 0, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+49, 180683, 0, -11844.9, 908.972, 0, 4.62512, 0, 0, -0.737277, 0.675591, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+50, 180683, 0, -11833.4, 1198.48, 0, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+51, 180683, 0, -11801.6, 961.14, 0, 5.84685, 0, 0, -0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+52, 180683, 0, -11749.2, 998.85, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+53, 180683, 0, -11707.8, 1092.1, 0, 0.261798, 0, 0, 0.130526, 0.991445, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+54, 180683, 0, -11642.5, 1102.82, 0, 3.45576, 0, 0, -0.987688, 0.156436, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+55, 180685, 0, -12560.9, 47.653, 0, 2.75761, 0, 0, 0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+56, 180685, 0, -12508.2, 122.857, 0, 2.82743, 0, 0, 0.987688, 0.156436, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+57, 180685, 0, -12397.3, 290.482, 0, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+58, 180685, 0, -12349.4, 342.822, 0, 2.26893, 0, 0, 0.906307, 0.422619, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+59, 180685, 0, -12346, 304.463, 0, 2.05949, 0, 0, 0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+60, 180685, 0, -12259.6, 344.519, 0, 1.90241, 0, 0, 0.814116, 0.580703, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+61, 180685, 0, -12202.2, 351.023, 0, 4.60767, 0, 0, -0.743144, 0.669131, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+62, 180685, 0, -12131.3, 369.493, 0, 5.34071, 0, 0, -0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+63, 180685, 0, -12080.1, 459.363, 0, 2.14675, 0, 0, 0.878817, 0.47716, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+64, 180685, 0, -12067.7, 871.853, 0, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+65, 180685, 0, -12043.2, 541.762, 0, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+66, 180685, 0, -12035, 804.831, 0, 2.46091, 0, 0, 0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+67, 180685, 0, -12031.4, 593.977, 0, 5.60251, 0, 0, -0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+68, 180685, 0, -12015.2, 532.893, -0.255422, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+69, 180685, 0, -12011.6, 759.599, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+70, 180685, 0, -12001.6, 651.077, 0, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+71, 180685, 0, -11993.8, 649.109, -0.949605, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+72, 180685, 0, -11975.9, 684.698, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+73, 180685, 0, -11958.1, 738.97, 0, 2.9496, 0, 0, 0.995396, 0.0958512, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+74, 180685, 0, -11950.8, 847.183, 0, 2.77507, 0, 0, 0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+75, 180685, 0, -11882, 876.11, 0, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+76, 180685, 0, -11844.9, 908.972, 0, 4.62512, 0, 0, -0.737277, 0.675591, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+77, 180685, 0, -11833.4, 1198.48, 0, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+78, 180685, 0, -11801.6, 961.14, 0, 5.84685, 0, 0, -0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+79, 180685, 0, -11749.2, 998.85, 0, 4.99164, 0, 0, -0.601814, 0.798636, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+80, 180685, 0, -11707.8, 1092.1, 0, 0.261798, 0, 0, 0.130526, 0.991445, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+81, 180685, 0, -11642.5, 1102.82, 0, 3.45576, 0, 0, -0.987688, 0.156436, 180, 180, 100, 1, 0, 0, 7, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+2, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+3, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+4, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+5, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+6, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+7, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+8, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+9, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+10, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+11, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+12, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+13, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+14, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+15, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+16, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+17, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+18, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+19, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+20, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+21, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+22, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+23, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+24, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+25, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+26, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+27, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10);

INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES 
(@OGUID+1, @PTEMPLATE+1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+2, @PTEMPLATE+2, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+3, @PTEMPLATE+3, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+4, @PTEMPLATE+4, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+5, @PTEMPLATE+5, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+6, @PTEMPLATE+6, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+7, @PTEMPLATE+7, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+8, @PTEMPLATE+8, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+9, @PTEMPLATE+9, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+10, @PTEMPLATE+10, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+11, @PTEMPLATE+11, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+12, @PTEMPLATE+12, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+13, @PTEMPLATE+13, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+14, @PTEMPLATE+14, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+15, @PTEMPLATE+15, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+16, @PTEMPLATE+16, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+17, @PTEMPLATE+17, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+18, @PTEMPLATE+18, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+19, @PTEMPLATE+19, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+20, @PTEMPLATE+20, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+21, @PTEMPLATE+21, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+22, @PTEMPLATE+22, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+23, @PTEMPLATE+23, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+24, @PTEMPLATE+24, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+25, @PTEMPLATE+25, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+26, @PTEMPLATE+26, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+27, @PTEMPLATE+27, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+28, @PTEMPLATE+1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+29, @PTEMPLATE+2, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+30, @PTEMPLATE+3, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+31, @PTEMPLATE+4, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+32, @PTEMPLATE+5, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+33, @PTEMPLATE+6, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+34, @PTEMPLATE+7, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+35, @PTEMPLATE+8, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+36, @PTEMPLATE+9, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+37, @PTEMPLATE+10, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+38, @PTEMPLATE+11, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+39, @PTEMPLATE+12, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+40, @PTEMPLATE+13, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+41, @PTEMPLATE+14, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+42, @PTEMPLATE+15, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+43, @PTEMPLATE+16, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+44, @PTEMPLATE+17, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+45, @PTEMPLATE+18, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+46, @PTEMPLATE+19, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+47, @PTEMPLATE+20, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+48, @PTEMPLATE+21, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+49, @PTEMPLATE+22, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+50, @PTEMPLATE+23, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+51, @PTEMPLATE+24, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+52, @PTEMPLATE+25, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+53, @PTEMPLATE+26, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+54, @PTEMPLATE+27, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+55, @PTEMPLATE+1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+56, @PTEMPLATE+2, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+57, @PTEMPLATE+3, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+58, @PTEMPLATE+4, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+59, @PTEMPLATE+5, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+60, @PTEMPLATE+6, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+61, @PTEMPLATE+7, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+62, @PTEMPLATE+8, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+63, @PTEMPLATE+9, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+64, @PTEMPLATE+10, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+65, @PTEMPLATE+11, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+66, @PTEMPLATE+12, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+67, @PTEMPLATE+13, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+68, @PTEMPLATE+14, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+69, @PTEMPLATE+15, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+70, @PTEMPLATE+16, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+71, @PTEMPLATE+17, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+72, @PTEMPLATE+18, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+73, @PTEMPLATE+19, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+74, @PTEMPLATE+20, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+75, @PTEMPLATE+21, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+76, @PTEMPLATE+22, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+77, @PTEMPLATE+23, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+78, @PTEMPLATE+24, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+79, @PTEMPLATE+25, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+80, @PTEMPLATE+26, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+81, @PTEMPLATE+27, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 7, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+28, 11, 'Stranglethorn - Oily Blackmouth School / Firefin Snapper School / Floating Wreckage (Master Pool)', 0, 0, 7, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+2, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+3, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+4, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+5, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+6, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+7, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+8, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+9, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+10, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+11, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+12, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+13, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+14, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+15, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+16, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+17, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+18, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+19, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+20, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+21, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+22, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+23, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+24, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+25, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+26, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+27, @PTEMPLATE+28, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn', 0);

UPDATE `pool_gameobject` SET `chance` = 30 WHERE `description` = "Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180682);
UPDATE `pool_gameobject` SET `chance` = 40 WHERE `description` = "Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180683);
UPDATE `pool_gameobject` SET `chance` = 30 WHERE `description` = "Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180685);

SET @OGUID = 24463;
SET @PTEMPLATE = 3614;

INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, 180684, 0, -12578.5, -108.159, 10.0699, 4.17134, 0, 0, -0.870356, 0.492424, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+2, 180684, 0, -12508.8, -249.623, 10.0699, 4.32842, 0, 0, -0.829037, 0.559194, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+3, 180684, 0, -12477.8, -243.562, 10.0699, 5.70723, 0, 0, -0.284015, 0.95882, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+4, 180684, 0, -12472.4, -289.304, 10.1106, 3.63029, 0, 0, -0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+5, 180684, 0, -12424.2, -303.625, 10.1363, 3.63029, 0, 0, -0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+6, 180684, 0, -12365.6, -294.952, 10.0699, 2.37364, 0, 0, 0.927183, 0.374608, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+7, 180684, 0, -12313.4, -311.831, 10.0699, 1.79769, 0, 0, 0.782608, 0.622515, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+8, 180684, 0, -12298, -297.684, 10.0699, 2.16421, 0, 0, 0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+9, 180684, 0, -12239.5, -335.31, 10.0699, 0.698131, 0, 0, 0.34202, 0.939693, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+10, 180684, 0, -12120.5, -352.027, 10.0699, 1.5708, 0, 0, 0.707107, 0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+11, 180684, 0, -12110.8, -321.975, 10.0699, 2.91469, 0, 0, 0.993571, 0.113208, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+12, 180684, 0, -12067.4, -457.138, 10.0699, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+13, 180684, 0, -12036.6, -500.827, 10.0699, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+14, 180684, 0, -11925.3, -322.532, 10.085, 3.38594, 0, 0, -0.992546, 0.12187, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+15, 180684, 0, -11886.7, -455.329, 10.0699, 1.6057, 0, 0, 0.719339, 0.694659, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+16, 180684, 0, -11856.7, -427.904, 10.0699, 0.977383, 0, 0, 0.469471, 0.882948, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+17, 180684, 0, -11820.9, -347.99, 10.0699, 4.86947, 0, 0, -0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+18, 180684, 0, -11751.5, -359.684, 10.0699, 2.07694, 0, 0, 0.861629, 0.507539, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+19, 180684, 0, -11701.4, -331.587, 10.0699, 3.4034, 0, 0, -0.991445, 0.130528, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+20, 180684, 0, -11668.9, -262.907, 10.0699, 2.77507, 0, 0, 0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+21, 180684, 0, -11614.3, -192.641, 10.0699, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+22, 180684, 0, -11596.9, -3.87077, 10.0699, 1.48353, 0, 0, 0.67559, 0.737278, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+23, 180684, 0, -11595.8, -30.9914, 10.0699, 2.70526, 0, 0, 0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+24, 180684, 0, -11594.2, -161.316, 10.0699, 5.72468, 0, 0, -0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+25, 180684, 0, -11576.1, -28.4349, 10.0699, 2.14675, 0, 0, 0.878817, 0.47716, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+26, 180684, 0, -11568.2, -64.7165, 10.0699, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+27, 180684, 0, -11542.9, 43.4788, 10.0699, 1.72787, 0, 0, 0.760406, 0.649449, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+28, 180684, 0, -11538.7, -52.8923, 10.0699, 4.53786, 0, 0, -0.766044, 0.642789, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+29, 180684, 0, -11517.9, 141.394, 10.0699, 1.36136, 0, 0, 0.62932, 0.777146, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+30, 180684, 0, -11498.4, 91.6261, 10.0699, 2.05949, 0, 0, 0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+31, 180684, 0, -11483.7, 187.406, 10.0699, 3.94445, 0, 0, -0.920505, 0.390732, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+32, 180684, 0, -11447.1, 254.103, 10.0699, 5.39307, 0, 0, -0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+33, 180685, 0, -12578.5, -108.159, 10.0699, 4.17134, 0, 0, -0.870356, 0.492424, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+34, 180685, 0, -12508.8, -249.623, 10.0699, 4.32842, 0, 0, -0.829037, 0.559194, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+35, 180685, 0, -12477.8, -243.562, 10.0699, 5.70723, 0, 0, -0.284015, 0.95882, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+36, 180685, 0, -12472.4, -289.304, 10.1106, 3.63029, 0, 0, -0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+37, 180685, 0, -12424.2, -303.625, 10.1363, 3.63029, 0, 0, -0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+38, 180685, 0, -12365.6, -294.952, 10.0699, 2.37364, 0, 0, 0.927183, 0.374608, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+39, 180685, 0, -12313.4, -311.831, 10.0699, 1.79769, 0, 0, 0.782608, 0.622515, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+40, 180685, 0, -12298, -297.684, 10.0699, 2.16421, 0, 0, 0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+41, 180685, 0, -12239.5, -335.31, 10.0699, 0.698131, 0, 0, 0.34202, 0.939693, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+42, 180685, 0, -12120.5, -352.027, 10.0699, 1.5708, 0, 0, 0.707107, 0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+43, 180685, 0, -12110.8, -321.975, 10.0699, 2.91469, 0, 0, 0.993571, 0.113208, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+44, 180685, 0, -12067.4, -457.138, 10.0699, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+45, 180685, 0, -12036.6, -500.827, 10.0699, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+46, 180685, 0, -11925.3, -322.532, 10.085, 3.38594, 0, 0, -0.992546, 0.12187, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+47, 180685, 0, -11886.7, -455.329, 10.0699, 1.6057, 0, 0, 0.719339, 0.694659, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+48, 180685, 0, -11856.7, -427.904, 10.0699, 0.977383, 0, 0, 0.469471, 0.882948, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+49, 180685, 0, -11820.9, -347.99, 10.0699, 4.86947, 0, 0, -0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+50, 180685, 0, -11751.5, -359.684, 10.0699, 2.07694, 0, 0, 0.861629, 0.507539, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+51, 180685, 0, -11701.4, -331.587, 10.0699, 3.4034, 0, 0, -0.991445, 0.130528, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+52, 180685, 0, -11668.9, -262.907, 10.0699, 2.77507, 0, 0, 0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+53, 180685, 0, -11614.3, -192.641, 10.0699, 4.11898, 0, 0, -0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+54, 180685, 0, -11596.9, -3.87077, 10.0699, 1.48353, 0, 0, 0.67559, 0.737278, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+55, 180685, 0, -11595.8, -30.9914, 10.0699, 2.70526, 0, 0, 0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+56, 180685, 0, -11594.2, -161.316, 10.0699, 5.72468, 0, 0, -0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+57, 180685, 0, -11576.1, -28.4349, 10.0699, 2.14675, 0, 0, 0.878817, 0.47716, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+58, 180685, 0, -11568.2, -64.7165, 10.0699, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+59, 180685, 0, -11542.9, 43.4788, 10.0699, 1.72787, 0, 0, 0.760406, 0.649449, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+60, 180685, 0, -11538.7, -52.8923, 10.0699, 4.53786, 0, 0, -0.766044, 0.642789, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+61, 180685, 0, -11517.9, 141.394, 10.0699, 1.36136, 0, 0, 0.62932, 0.777146, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+62, 180685, 0, -11498.4, 91.6261, 10.0699, 2.05949, 0, 0, 0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+63, 180685, 0, -11483.7, 187.406, 10.0699, 3.94445, 0, 0, -0.920505, 0.390732, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+64, 180685, 0, -11447.1, 254.103, 10.0699, 5.39307, 0, 0, -0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 7, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+2, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+3, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+4, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+5, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+6, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+7, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+8, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+9, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+10, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+11, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+12, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+13, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+14, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+15, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+16, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+17, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+18, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+19, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+20, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+21, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+22, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+23, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+24, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+25, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+26, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+27, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+28, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+29, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+30, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+31, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@PTEMPLATE+32, 1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10);

INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES 
(@OGUID+1, @PTEMPLATE+1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+2, @PTEMPLATE+2, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+3, @PTEMPLATE+3, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+4, @PTEMPLATE+4, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+5, @PTEMPLATE+5, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+6, @PTEMPLATE+6, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+7, @PTEMPLATE+7, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+8, @PTEMPLATE+8, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+9, @PTEMPLATE+9, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+10, @PTEMPLATE+10, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+11, @PTEMPLATE+11, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+12, @PTEMPLATE+12, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+13, @PTEMPLATE+13, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+14, @PTEMPLATE+14, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+15, @PTEMPLATE+15, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+16, @PTEMPLATE+16, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+17, @PTEMPLATE+17, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+18, @PTEMPLATE+18, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+19, @PTEMPLATE+19, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+20, @PTEMPLATE+20, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+21, @PTEMPLATE+21, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+22, @PTEMPLATE+22, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+23, @PTEMPLATE+23, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+24, @PTEMPLATE+24, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+25, @PTEMPLATE+25, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+26, @PTEMPLATE+26, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+27, @PTEMPLATE+27, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+28, @PTEMPLATE+28, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+29, @PTEMPLATE+29, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+30, @PTEMPLATE+30, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+31, @PTEMPLATE+31, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+32, @PTEMPLATE+32, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+33, @PTEMPLATE+1, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+34, @PTEMPLATE+2, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+35, @PTEMPLATE+3, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+36, @PTEMPLATE+4, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+37, @PTEMPLATE+5, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+38, @PTEMPLATE+6, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+39, @PTEMPLATE+7, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+40, @PTEMPLATE+8, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+41, @PTEMPLATE+9, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+42, @PTEMPLATE+10, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+43, @PTEMPLATE+11, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+44, @PTEMPLATE+12, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+45, @PTEMPLATE+13, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+46, @PTEMPLATE+14, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+47, @PTEMPLATE+15, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+48, @PTEMPLATE+16, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+49, @PTEMPLATE+17, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+50, @PTEMPLATE+18, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+51, @PTEMPLATE+19, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+52, @PTEMPLATE+20, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+53, @PTEMPLATE+21, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+54, @PTEMPLATE+22, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+55, @PTEMPLATE+23, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+56, @PTEMPLATE+24, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+57, @PTEMPLATE+25, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+58, @PTEMPLATE+26, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+59, @PTEMPLATE+27, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+60, @PTEMPLATE+28, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+61, @PTEMPLATE+29, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+62, @PTEMPLATE+30, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+63, @PTEMPLATE+31, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10),
(@OGUID+64, @PTEMPLATE+32, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 7, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+33, 14, 'Wetlands - Greater Sagefish School / Floating Wreckage (Master Pool)', 0, 0, 7, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+2, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+3, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+4, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+5, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+6, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+7, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+8, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+9, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+10, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+11, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+12, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+13, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+14, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+15, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+16, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+17, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+18, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+19, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+20, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+21, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+22, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+23, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+24, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+25, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+26, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+27, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+28, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+29, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+30, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+31, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0),
(@PTEMPLATE+32, @PTEMPLATE+33, 0, 'Greater Sagefish School / Floating Wreckage - Stranglethorn', 0);

UPDATE `pool_gameobject` SET `chance` = 60 WHERE `description` = "Greater Sagefish School / Floating Wreckage - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180684);
UPDATE `pool_gameobject` SET `chance` = 40 WHERE `description` = "Greater Sagefish School / Floating Wreckage - Stranglethorn" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180685);

-- School of Tastyfish
UPDATE `pool_template` SET `description`='School of Tastyfish in Strangelthorn' WHERE  `entry`=4000;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `state`, `animprogress`, `patch_min`, `patch_max`) VALUES
(@OGUID+65, 180248, 0, -12366.6, 304.226, -0.764385, 5.41052, 0, 0, -0.422618, 0.906308, 180, 180, 1, 100, 5, 10),
(@OGUID+66, 180248, 0, -12333.7, 299.923, -1.18764, 0.366518, 0, 0, 0.182235, 0.983255, 180, 180, 1, 100, 5, 10);

INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `flags`, `patch_min`, `patch_max`) VALUES
(@OGUID+65, 4000, 0, 'School of Tastyfish', 0, 5, 10),
(@OGUID+66, 4000, 0, 'School of Tastyfish', 0, 5, 10);

INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES
(@OGUID+65, 15),
(@OGUID+66, 15);


-- End of migration.
END IF;
END??
delimiter ; 
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;