-- Creature Spawns
DELETE FROM creature WHERE guid IN (280001923, 280001925, 280001924, 280001916,
 280001921, 280001914, 280002906, 280001910,
 280001915, 280001911, 280001870, 280001872,
 280001874, 280001888, 280001878, 280001906,
 280001883, 280001882, 280001886, 280001865,
 280001868, 210347925, 280001920, 280001867,
 280002959, 210300116, 280001905, 280001890,
 280001904, 210334902, 210314493, 210320965,
 280001900, 280001895, 280001893, 280001899,
 280001901, 280001902, 210320912, 280001903,
 280002907, 280002791, 210310240, 280001935,
 280002935, 280002779, );
INSERT INTO `creature` VALUES
-- Kul Tiran Executioner
(280001923, 140936, 1643, 8567, 8568, '0', 0, 0, 0, -1, 0, 0, 1094.4, -375.39, 7.36587, 6.02932, 300, 0, 0, 20479, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Harbor Guard 1
(280001925, 136633, 1643, 8567, 8568, '0', 0, 0, 0, -1, 0, 1, 1086.74, -413.203, 20.6408, 6.06496, 300, 0, 0, 457500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Harbor Guard 2
(280001924, 136633, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1064.97, -433.749, 20.1612, 1.32165, 300, 0, 0, 457500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Tradewinds Laborer
(280001916, 142180, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1135.05, -571.172, 17.3094, 0.470747, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Dockwarden Finnson
(280001921, 142077, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1165.47, -516.365, 28.8115, 5.64926, 300, 0, 0, 152500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Jake Howard
(280001886, 143251, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1101.67, -636.371, 17.5431, 0.200004, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Victor Esquivias
(280001914, 143244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1118.12, -596.758, 17.3002, 5.40692, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Matt Fieler
(280002906, 143243, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1147.29, -624.783, 29.0328, 5.32408, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Matilda Clark
(280001910, 124180, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1119.43, -567.472, 17.3603, 5.33995, 300, 0, 0, 14680, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001865, 124180, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1047.07, -604.651, 9.72598, 0.0121453, 300, 0, 0, 14680, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Constable Astley
(210347925, 142371, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1062.74, -589.792, 9.4163, 2.88294, 120, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 27481),
-- Scott Trujillo
(280002907, 143263, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1134.48, -621.224, 28.69, 0.305433, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Boralus Citizen
(280001915, 123642, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1144.82, -577.145, 20.4963, 0.472323, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001911, 123642, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1122.04, -595.287, 17.2938, 4.51683, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001888, 135509, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1091.28, -645.658, 17.5367, 1.73305, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280002935, 123642, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1272.03, -545.495, 33.4008, 0.0335789, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Harbor Guard Cadet
(280001870, 140313, 1643, 8717, 10018, '0', 0, 0, 0, -1, 0, 1, 1126.02, -620.716, 17.5333, 3.20694, 300, 0, 0, 152500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001872, 140313, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1097.02, -603.723, 17.5394, 3.36688, 300, 0, 0, 152500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001874, 140313, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1088.66, -648.019, 17.5323, 2.72909, 300, 0, 0, 152500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001883, 140313, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1096.13, -644.471, 17.5397, 0.610869, 300, 0, 0, 152500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001882, 140313, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1098.18, -642.942, 17.5397, 3.73283, 300, 0, 0, 152500, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Tradewinds Trader
(280001878, 133282, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1091.63, -637.277, 17.5481, 6.25473, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Stormsong Trader
(280001906, 133282, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1092.7, -639.113, 17.5439, 0.800316, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Boralus Sailor
(280001868, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1055.27, -586.957, 9.75008, 1.58197, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001920, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1051.41, -638.177, 12.0483, 1.46858, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001867, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1050.37, -635.847, 9.98347, 4.99564, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001890, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1058.66, -606.29, 0.596997, 5.53633, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001904, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1092.54, -609.958, 1.51319, 2.44121, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(210334902, 123244, 1643, 8567, 8717, '0', 0, 0, 0, -1, 0, 0, 1150.33, -596.08, 1.55258, 0.473284, 120, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 27481),
(280001900, 123244, 1643, 8567, 8717, '0', 0, 0, 0, -1, 0, 1, 1152.58, -582.346, 1.50848, 1.44768, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001899, 123244, 1643, 8567, 8717, '0', 0, 0, 0, -1, 0, 1, 1126.56, -574.885, 1.78386, 3.37948, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001901, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1090.49, -568.307, 0.388785, 4.26098, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001902, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1095.91, -571.376, 0.899645, 1.6189, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
(280001903, 123244, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1100.13, -525.316, 1.51135, 2.97764, 300, 0, 0, 30500, 0, 0, 0, 0, 0, 0, 0, '', 0),
-- Tradewinds Tailor
(280002959, 142346, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1194.54, -647.526, 29.0589, 2.27965, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Tradewinds Dockworker
(210300116, 142166, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1064.33, -597.439, 0.667496, 0.229578, 120, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 27481),
(280001905, 142166, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1053.66, -622.014, 0.589554, 1.64843, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(210314493, 142166, 1643, 8567, 8717, '0', 0, 0, 0, -1, 0, 0, 1140.09, -575.075, 1.36962, 2.5585, 120, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 27481),
(210320965, 142166, 1643, 8567, 8717, '0', 0, 0, 0, -1, 0, 0, 1144.45, -577.951, 1.36346, 5.74778, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 27481),
(280001895, 142166, 1643, 8567, 8717, '0', 0, 0, 0, -1, 0, 1, 1143.92, -560.759, 1.50981, 5.44191, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001893, 142166, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1111.36, -516.641, 1.99738, 5.1273, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
(280001935, 142166, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1203.64, -641.883, 29.0757, 5.14467, 300, 0, 0, 30500, 0, 2, 0, 0, 0, 0, 0, '', 0),
-- Roko
(280002791, 129940, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1214.24, -522.833, 29.1551, 3.55505, 300, 0, 0, 30500, 1, 2, 0, 0, 0, 0, 0, '', 0),
-- Harbor Guard
(210310240, 136633, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 0, 1182.25, -536.473, 28.6292, 3.07129, 120, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 27481),
-- Grix "Ironfists" Barlow
(280002779, 133536, 1643, 8717, 8718, '0', 0, 0, 0, -1, 0, 1, 1231.59, -583.704, 25.4334, 4.6435, 300, 0, 0, 305000, 0, 0, 0, 0, 0, 0, 0, '', 0),