update `creature_template` set `subname`='General Goods' where `entry`='227';
update `creature_template` set `subname`='Blacksmithing & Mining Supplies' where `entry`='790';
update `creature_template` set `subname`='Alchemy Supplies & Reagents' where `entry`='1257';
update `creature_template` set `subname`='Reagents' where `entry`='1275';
update `creature_template` set `subname`='General Goods' where `entry`='1285';
update `creature_template` set `subname`='Trade Supplies' where `entry`='1286';
update `creature_template` set `subname`='Herbalism Supplies' where `entry`='1303';
update `creature_template` set `subname`='Reagents' where `entry`='1308';
update `creature_template` set `subname`='Poison Supplies' where `entry`='1326';
update `creature_template` set `subname`='Reagents' where `entry`='1351';
update `creature_template` set `subname`='Engineering Supplies & General Goods' where `entry`='1448';
update `creature_template` set `subname`='Reagents' where `entry`='1463';
update `creature_template` set `subname`='Reagents' where `entry`='1673';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='1678';
update `creature_template` set `subname`='Ale & Wine' where `entry`='1697';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='2383';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='2626';
update `creature_template` set `subname`='Food & Drink' where `entry`='2832';
update `creature_template` set `subname`='Cloth Armor & Accessories' where `entry`='2849';
update `creature_template` set `subname`='Armorer & Shieldcrafter' where `entry`='3075';
update `creature_template` set `subname`='Armorer & Shieldcrafter' where `entry`='3080';
update `creature_template` set `subname`='Poison Supplies' where `entry`='3090';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='3178';
update `creature_template` set `subname`='Engineering Supplies' where `entry`='3495';
update `creature_template` set `subname`='Trade Supplies' where `entry`='3556';
update `creature_template` set `subname`='Poison Supplies' where `entry`='3561';
update `creature_template` set `subname`='Reagents' where `entry`='3562';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='3572';
update `creature_template` set `subname`='Reagents' where `entry`='3700';
update `creature_template` set `subname`='Trade Supplies' where `entry`='3779';
update `creature_template` set `subname`='General Goods' where `entry`='4170';
update `creature_template` set `subname`='Herbalism Supplies' where `entry`='4216';
update `creature_template` set `subname`='Reagents' where `entry`='4220';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='4222';
update `creature_template` set `subname`='Cooking Supplies' where `entry`='4223';
update `creature_template` set `subname`='Trade Supplies' where `entry`='4229';
update `creature_template` set `subname`='General Goods' where `entry`='4241';
update `creature_template` set `subname`='Food & Drink' where `entry`='4255';
update `creature_template` set `subname`='Mining Supplies' where `entry`='4256';
update `creature_template` set `subname`='Trade Supplies' where `entry`='5100';
update `creature_template` set `subname`='General Goods' where `entry`='5101';
update `creature_template` set `subname`='Reagents' where `entry`='5110';
update `creature_template` set `subname`='Herbalism Supplies' where `entry`='5138';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='5139';
update `creature_template` set `subname`='Reagents' where `entry`='5151';
update `creature_template` set `subname`='Cooking Supplies' where `entry`='5160';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='5162';
update `creature_template` set `subname`='Trade Supplies' where `entry`='5163';
update `creature_template` set `subname`='Cooking Supplies' where `entry`='5483';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='5494';
update `creature_template` set `subname`='Herbalism Supplies' where `entry`='5503';
update `creature_template` set `subname`='Armorer' where `entry`='5508';
update `creature_template` set `subname`='Mining Supplies' where `entry`='5514';
update `creature_template` set `subname`='Engineering Supplies' where `entry`='5519';
update `creature_template` set `subname`='Food & Drink' where `entry`='5620';
update `creature_template` set `subname`='Mining Supplies' where `entry`='6298';
update `creature_template` set `subname`='Trade Supplies' where `entry`='6301';
update `creature_template` set `subname`='Poison Supplies' where `entry`='6779';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='8508';
update `creature_template` set `subname`='Engineering Supplies' where `entry`='8678';
update `creature_template` set `subname`='Trade Supplies' where `entry`='8934';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='10364';
update `creature_template` set `subname`='Food & Drink' where `entry`='10367';
update `creature_template` set `subname`='Trade Supplies' where `entry`='11189';
update `creature_template` set `subname`='Trade Supplies' where `entry`='12957';
update `creature_template` set `subname`='General Goods' where `entry`='12959';
update `creature_template` set `subname`='Zandalar Supplies & Repair' where `entry`='14921';
update `creature_template` set `subname`='Cloth & Leather Merchant' where `entry`='16186';
update `creature_template` set `subname`='General Goods' where `entry`='16259';
update `creature_template` set `subname`='General Goods' where `entry`='16260';
update `creature_template` set `subname`='Trade Supplies' where `entry`='16261';
update `creature_template` set `subname`='Poison Supplies' where `entry`='16268';
update `creature_template` set `subname`='Reagents' where `entry`='16611';
update `creature_template` set `subname`='Alchemy Supplies & Reagents' where `entry`='16612';
update `creature_template` set `subname`='Jewelcrafting Supplies' where `entry`='16624';
update `creature_template` set `subname`='Enchanting Supplies' where `entry`='16635';
update `creature_template` set `subname`='Tailoring Supplies' where `entry`='16638';
update `creature_template` set `subname`='Alchemy Supplies' where `entry`='16641';
update `creature_template` set `subname`='Engineering Supplies' where `entry`='16657';
update `creature_template` set `subname`='Blacksmithing Supplies' where `entry`='16670';
update `creature_template` set `subname`='Cooking Supplies' where `entry`='16677';
update `creature_template` set `subname`='Poison Supplies' where `entry`='16683';
update `creature_template` set `subname`='Leatherworking Supplies' where `entry`='16689';
update `creature_template` set `subname`='Alchemy Supplies' where `entry`='16705';
update `creature_template` set `subname`='Alchemy Supplies & Reagents' where `entry`='16706';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='16708';
update `creature_template` set `subname`='Blacksmithing Supplies' where `entry`='16713';
update `creature_template` set `subname`='Cooking Supplies' where `entry`='16718';
update `creature_template` set `subname`='Enchanting Supplies' where `entry`='16722';
update `creature_template` set `subname`='General Goods' where `entry`='16732';
update `creature_template` set `subname`='Leatherworking Supplies' where `entry`='16748';
update `creature_template` set `subname`='Reagents' where `entry`='16757';
update `creature_template` set `subname`='Tailoring Supplies' where `entry`='16767';
update `creature_template` set `subname`='Engineering Supplies' where `entry`='16782';
update `creature_template` set `subname`='Reagents' where `entry`='16829';
update `creature_template` set `subname`='General Goods' where `entry`='17489';
update `creature_template` set `subname`='Trade Supplies' where `entry`='17490';
update `creature_template` set `subname`='Jewelcrafting Supplies' where `entry`='17512';
update `creature_template` set `subname`='Weapons & Armor Merchant' where `entry`='17930';
update `creature_template` set `subname`='Reagents' where `entry`='18017';
update `creature_template` set `subname`='Engineering Supplies' where `entry`='18278';
update `creature_template` set `subname`='Fishing Supplies' where `entry`='18347';
update `creature_template` set `subname`='Trade Supplies' where `entry`='18426';
update `creature_template` set `subname`='General Goods' where `entry`='18810';
update `creature_template` set `subname`='Reagents' where `entry`='19004';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='19013';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='19014';
update `creature_template` set `subname`='Food & Drink' where `entry`='19050';
update `creature_template` set `subname`='Blacksmithing Supplies' where `entry`='19342';
update `creature_template` set `subname`='Guns & Ammunition' where `entry`='19351';
update `creature_template` set `subname`='Fruit & Fungus' where `entry`='19471';
update `creature_template` set `subname`='Armorer' where `entry`='19517';
update `creature_template` set `subname`='Food & Drink' where `entry`='19518';
update `creature_template` set `subname`='Blacksmithing Supplies' where `entry`='19520';
update `creature_template` set `subname`='Tailoring Supplies' where `entry`='19521';
update `creature_template` set `subname`='Blacksmithing Supplies' where `entry`='19530';
update `creature_template` set `subname`='Gems & Jewelcrafting Supplies' where `entry`='19538';
update `creature_template` set `subname`='General Goods' where `entry`='19625';
update `creature_template` set `subname`='General Goods' where `entry`='19649';
update `creature_template` set `subname`='Arena Vendor' where `entry`='19857';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='20081';
update `creature_template` set `subname`='Poison Supplies' where `entry`='20121';
update `creature_template` set `subname`='General Goods & Repairs' where `entry`='20231';
update `creature_template` set `subname`='Speciality Meat & Slop' where `entry`='20378';
update `creature_template` set `subname`='Reagents' where `entry`='20915';
update `creature_template` set `subname`='Food & Drink' where `entry`='20916';
update `creature_template` set `subname`='Food & Drink' where `entry`='21484';
update `creature_template` set `subname`='Food & Drink' where `entry`='21487';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='22479';
update `creature_template` set `subname`='Woodcrafting Supplies' where `entry`='841';
update `creature_template` set `subname`='Poison Supplies' where `entry`='3559';
update `creature_template` set `subname`='Reagents' where `entry`='3564';
update `creature_template` set `subname`='Cartography Supplies' where `entry`='4224';
update `creature_template` set `subname`='General Goods' where `entry`='16614';
update `creature_template` set `subname`='Herbalism Supplies' where `entry`='16630';
update `creature_template` set `subname`='Herbalism Supplies' where `entry`='16737';
update `creature_template` set `subname`='Poison Supplies' where `entry`='16754';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='21642';
update `creature_template` set `subname`='Food & Drink' where `entry`='22646';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='22652';
update `creature_template` set `subname`='Food & Drink' where `entry`='22655';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='22660';
update `creature_template` set `subname`='Reagents' where `entry`='23112';
update `creature_template` set `subname`='Reagents' where `entry`='23157';
update `creature_template` set `subname`='Guild Banker' where `entry`='2424';
update `creature_template` set `subname`='Reagents & Poison Supplies' where `entry`='23145';
update `creature_template` set `subname`='Reagents' where `entry`='24409';

update `creature_template` set `type`='10' where `entry`='16852';
update `creature_template` set `type`='10' where `entry`='17508';
update `creature_template` set `type`='3' where `entry`='19218';
update `creature_template` set `type`='3' where `entry`='19710';
update `creature_template` set `type`='10' where `entry`='22054';
update `creature_template` set `type`='10' where `entry`='309';
update `creature_template` set `type`='10' where `entry`='24441';
update `creature_template` set `type`='10' where `entry`='24443';

update `creature_template` set `name`='Guild Banker' where `entry`='2424';
update `creature_template` set `name`='Clockwork Rocket Bot' where `entry`='24968';

update `creature_template` set `family`='0' where `entry`='23020';

update `creature_template` set `flag1`='4096' where `entry`='7774';
update `creature_template` set `flag1`='9216' where `entry`='7863';
update `creature_template` set `flag1`='0' where `entry`='23020';