-- mauglar
update creature_loot_template set questchanceorgroup = "-1" where item in (28797,28799,28796,28801,28795,28800) and entry = 18831;
update creature_loot_template set questchanceorgroup = "-2" where item in (29763,29764,29762) and entry = 18831;
-- gruul
update creature_loot_template set questchanceorgroup = "-1" where item in (28804,28803,28828,28827,28810,28824,28822,28823,28830) and entry = 19044;
update creature_loot_template set questchanceorgroup = "-2" where item in (29766,29767,29765) and entry = 19044;
-- magethoridan
update creature_loot_template set questchanceorgroup = "-1" where item in (28777,28780,28776,28778,28775,28779,28789,28781) and entry = 17257;
update creature_loot_template set questchanceorgroup = "-2" where item in (28774,28782,29458,28783) and entry = 17257;
update creature_loot_template set questchanceorgroup = "-3" where item in (29754,29753,29755) and entry = 17257;
-- Hydross
update creature_loot_template set questchanceorgroup = "-1" where item in (30056,32516,30050,30055,30047,30054,30048,30053) and entry = 21216;
update creature_loot_template set questchanceorgroup = "-2" where item in (28774,28782,29458,28783) and entry = 21216;
-- Lurker
update creature_loot_template set questchanceorgroup = "-1" where item in (30064,30067,30062,30060,30066,30065,30057) and entry = 21217;
update creature_loot_template set questchanceorgroup = "-2" where item in (30059,30061,33054,30665,30063,30058) and entry = 21217;
-- Leotheras
update creature_loot_template set questchanceorgroup = "-1" where item in (30092,30097,30091,30096,30627,30095) and entry = 21215;
update creature_loot_template set questchanceorgroup = "-2" where item in (30239,30240,30241) and entry = 21215;
-- Karathess
update creature_loot_template set questchanceorgroup = "-1" where item in (30100,30101,30099,30663,30626,30090) and entry = 21214;
update creature_loot_template set questchanceorgroup = "-2" where item in (30245,30246,30247) and entry = 21214;
-- Morogrim
update creature_loot_template set questchanceorgroup = "-1" where item in (30098,30079,30075,30085,30068,30084,30081) and entry = 21213;
update creature_loot_template set questchanceorgroup = "-2" where item in (30008,30083,33058,30720,30082,30080) and entry = 21213;
-- Vashj
update creature_loot_template set questchanceorgroup = "-1" where item in (30107,30111,30106,30104,30102,30112,30109,30110,30621,30103,30108,30105) and entry = 21212;
update creature_loot_template set questchanceorgroup = "-2" where item in (30242,30243,30244) and entry = 21212;
-- Al'ar
update creature_loot_template set questchanceorgroup = "-1" where item in (29925,29918,29947,29921,29922,29920,30448,30447,29923) and entry = 19514;
update creature_loot_template set questchanceorgroup = "-2" where item in (32944,29948,29924,29949) and entry = 19514;
-- Void Reaver
update creature_loot_template set questchanceorgroup = "-1" where item in (29986,29984,29985,29983,32515,30619,30450) and entry = 19516;
update creature_loot_template set questchanceorgroup = "-2" where item in (30248,30249,30250) and entry = 19516;
-- Solarian
update creature_loot_template set questchanceorgroup = "-1" where item in (29977,29972,29966,29976,29951,29965,29950,32267) and entry = 18805;
update creature_loot_template set questchanceorgroup = "-2" where item in (30446,30449,29962,29981,29982) and entry = 18805;
-- Thelas
update creature_loot_template set questchanceorgroup = "-1" where item in (29992,29989,29994,29990,29987,29995,29991,29998,29997,29993,29996,29988) and entry = 19622;
update creature_loot_template set questchanceorgroup = "-2" where item in (30236,30237,30238) and entry = 19622;
-- mauglar
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (28797,28799,28796,28801,28795,28800) and entry = 18831;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (29763,29764,29762) and entry = 18831;
-- gruul
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (28804,28803,28828,28827,28810,28824,28822,28823,28830) and entry = 19044;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (29766,29767,29765) and entry = 19044;
-- magethoridan
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (28777,28780,28776,28778,28775,28779,28789,28781) and entry = 17257;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (28774,28782,29458,28783) and entry = 17257;
update creature_loot_template_copy set questchanceorgroup = "-3" where item in (29754,29753,29755) and entry = 17257;
-- Hydross
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (30056,32516,30050,30055,30047,30054,30048,30053) and entry = 21216;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (28774,28782,29458,28783) and entry = 21216;
-- Lurker
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (30064,30067,30062,30060,30066,30065,30057) and entry = 21217;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30059,30061,33054,30665,30063,30058) and entry = 21217;
-- Leotheras
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (30092,30097,30091,30096,30627,30095) and entry = 21215;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30239,30240,30241) and entry = 21215;
-- Karathess
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (30100,30101,30099,30663,30626,30090) and entry = 21214;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30245,30246,30247) and entry = 21214;
-- Morogrim
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (30098,30079,30075,30085,30068,30084,30081) and entry = 21213;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30008,30083,33058,30720,30082,30080) and entry = 21213;
-- Vashj
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (30107,30111,30106,30104,30102,30112,30109,30110,30621,30103,30108,30105) and entry = 21212;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30242,30243,30244) and entry = 21212;
-- Al'ar
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (29925,29918,29947,29921,29922,29920,30448,30447,29923) and entry = 19514;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (32944,29948,29924,29949) and entry = 19514;
-- Void Reaver
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (29986,29984,29985,29983,32515,30619,30450) and entry = 19516;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30248,30249,30250) and entry = 19516;
-- Solarian
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (29977,29972,29966,29976,29951,29965,29950,32267) and entry = 18805;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30446,30449,29962,29981,29982) and entry = 18805;
-- Thelas
update creature_loot_template_copy set questchanceorgroup = "-1" where item in (29992,29989,29994,29990,29987,29995,29991,29998,29997,29993,29996,29988) and entry = 19622;
update creature_loot_template_copy set questchanceorgroup = "-2" where item in (30236,30237,30238) and entry = 19622;
-- chances
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 18331)) WHERE `entry` = 18331 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 18331)) WHERE `entry` = 18331 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 19044)) WHERE `entry` = 19044 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 19044)) WHERE `entry` = 19044 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 17257)) WHERE `entry` = 17257 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 17257)) WHERE `entry` = 17257 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -3 AND `entry` = 17257)) WHERE `entry` = 17257 AND `chanceorref` != 0 and `questchanceorgroup` = -3;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 21216)) WHERE `entry` = 21216 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 21216)) WHERE `entry` = 21216 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 21217)) WHERE `entry` = 21217 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 21217)) WHERE `entry` = 21217 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 21215)) WHERE `entry` = 21215 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 21215)) WHERE `entry` = 21215 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 21214)) WHERE `entry` = 21214 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 21214)) WHERE `entry` = 21214 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 21213)) WHERE `entry` = 17257 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 21213)) WHERE `entry` = 17257 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 21212)) WHERE `entry` = 21212 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 21212)) WHERE `entry` = 21212 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 19514)) WHERE `entry` = 19514 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 19514)) WHERE `entry` = 19514 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 19516)) WHERE `entry` = 19516 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 19516)) WHERE `entry` = 19516 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 18805)) WHERE `entry` = 18805 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 18805)) WHERE `entry` = 18805 AND `chanceorref` != 0 and `questchanceorgroup` = -2;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -1 AND `entry` = 19622)) WHERE `entry` = 19622 AND `chanceorref` != 0 and `questchanceorgroup` = -1;
UPDATE `creature_loot_template` SET `chanceorref` = (100/(SELECT COUNT(*) FROM `creature_loot_template_copy` WHERE `questchanceorgroup` = -2 AND `entry` = 19622)) WHERE `entry` = 19622 AND `chanceorref` != 0 and `questchanceorgroup` = -2;