Index: guild_shops.sql
===================================================================
--- guild_shops.sql	(revision 4026)
+++ guild_shops.sql	(working copy)
@@ -23,8 +23,9 @@
   `itemid` smallint(5) unsigned NOT NULL,
   `min_price` int(10) unsigned NOT NULL DEFAULT '0',
   `max_price` int(10) unsigned NOT NULL DEFAULT '0',
-  `quantity` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `daily_increase` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `max_quantity` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `daily_increase` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `initial_quantity` smallint(5) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guildid`,`itemid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -31,743 +32,1900 @@
 -- ----------------------------
 -- Records of guild_shops
 -- ----------------------------
-INSERT INTO `guild_shops` VALUES ('5131', '688', '15', '28', '240', '3');
-INSERT INTO `guild_shops` VALUES ('5131', '689', '27', '37', '240', '2');
-INSERT INTO `guild_shops` VALUES ('5131', '691', '45', '276', '240', '40');
-INSERT INTO `guild_shops` VALUES ('5131', '698', '72', '349', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5131', '695', '120', '132', '240', '2');
-INSERT INTO `guild_shops` VALUES ('5131', '697', '528', '549', '240', '4');
-INSERT INTO `guild_shops` VALUES ('5131', '696', '330', '699', '180', '65');
-INSERT INTO `guild_shops` VALUES ('5131', '690', '1378', '10938', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5131', '693', '640', '3586', '60', '45');
-INSERT INTO `guild_shops` VALUES ('5131', '694', '2119', '2811', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5131', '699', '4740', '24016', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5131', '701', '6615', '8555', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5131', '700', '9075', '9075', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5131', '702', '9600', '11520', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5131', '704', '96', '149', '240', '10');
-INSERT INTO `guild_shops` VALUES ('5131', '721', '448', '800', '240', '65');
-INSERT INTO `guild_shops` VALUES ('5131', '705', '7', '18', '240', '2');
-INSERT INTO `guild_shops` VALUES ('5131', '706', '27', '165', '240', '30');
-INSERT INTO `guild_shops` VALUES ('5131', '708', '45', '276', '240', '40');
-INSERT INTO `guild_shops` VALUES ('5131', '715', '72', '441', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5131', '712', '120', '120', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5131', '714', '606', '1036', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5131', '713', '330', '1672', '240', '225');
-INSERT INTO `guild_shops` VALUES ('5131', '707', '1723', '9651', '240', '150');
-INSERT INTO `guild_shops` VALUES ('513', '710', '2119', '3843', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '716', '4740', '24016', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '711', '2537', '4489', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '719', '45568', '62464', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '720', '2687', '20962', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '12984', '111', '292', '240', '50');
-INSERT INTO `guild_shops` VALUES ('513', '12289', '41', '249', '240', '40');
-INSERT INTO `guild_shops` VALUES ('513', '12293', '15132', '15132', '240', '1');
-INSERT INTO `guild_shops` VALUES ('513', '22', '282', '1639', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '97', '227', '5508', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '102', '291', '582', '240', '50');
-INSERT INTO `guild_shops` VALUES ('513', '23', '829', '1858', '240', '175');
-INSERT INTO `guild_shops` VALUES ('513', '92', '738', '3621', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '17024', '48', '351', '240', '55');
-INSERT INTO `guild_shops` VALUES ('513', '17027', '9771', '44478', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '17030', '14766', '81107', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '17050', '247', '1406', '240', '200');
-INSERT INTO `guild_shops` VALUES ('513', '17051', '1049', '2630', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '17088', '113', '286', '240', '30');
-INSERT INTO `guild_shops` VALUES ('513', '17095', '281', '1932', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '17424', '18900', '49980', '240', '255');
-INSERT INTO `guild_shops` VALUES ('513', '17217', '11492', '11492', '240', '1');
-INSERT INTO `guild_shops` VALUES ('513', '17318', '13', '13', '240', '1');
-INSERT INTO `guild_shops` VALUES ('514', '880', '57', '349', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '881', '1941', '13398', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '882', '150', '190', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '884', '4850', '12384', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '885', '25584', '69888', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '888', '84', '114', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '889', '298', '1495', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '893', '760', '4141', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '894', '968', '2952', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '896', '2044', '12166', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '897', '1228', '7993', '240', '150');
-INSERT INTO `guild_shops` VALUES ('514', '864', '72', '203', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '833', '15', '22', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '834', '80', '200', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '835', '187', '1000', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '832', '675', '1620', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '839', '137', '870', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '817', '45', '240', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '818', '120', '768', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '819', '750', '4600', '240', '255');
-INSERT INTO `guild_shops` VALUES ('515', '820', '2700', '3312', '240', '100');
-INSERT INTO `guild_shops` VALUES ('515', '816', '596', '3540', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '822', '600', '4480', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '823', '18240', '18240', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '821', '144144', '144144', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '824', '240', '588', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '825', '480', '2944', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '826', '8040', '8040', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '827', '53568', '53568', '240', '150');
-INSERT INTO `guild_shops` VALUES ('515', '841', '36', '200', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '833', '15', '22', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '835', '187', '1000', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '832', '675', '1620', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '839', '137', '870', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '817', '45', '240', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '818', '120', '768', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '819', '750', '4600', '240', '255');
-INSERT INTO `guild_shops` VALUES ('516', '820', '2700', '3312', '240', '100');
-INSERT INTO `guild_shops` VALUES ('516', '816', '596', '3540', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '822', '600', '4480', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '823', '18240', '18240', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '824', '240', '588', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '825', '480', '2944', '240', '150');
-INSERT INTO `guild_shops` VALUES ('516', '847', '10', '40', '240', '8');
-INSERT INTO `guild_shops` VALUES ('516', '841', '36', '200', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5171', '17396', '3', '4', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17395', '9', '12', '240', '2');
-INSERT INTO `guild_shops` VALUES ('5171', '16996', '52', '52', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '16997', '52', '266', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5171', '16998', '30', '184', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5171', '16999', '52', '240', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5171', '17000', '52', '322', '240', '75');
-INSERT INTO `guild_shops` VALUES ('5171', '17392', '213', '433', '240', '75');
-INSERT INTO `guild_shops` VALUES ('5171', '17393', '213', '213', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5171', '17394', '220', '220', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5171', '16992', '52', '238', '240', '75');
-INSERT INTO `guild_shops` VALUES ('5171', '16993', '52', '64', '240', '5');
-INSERT INTO `guild_shops` VALUES ('5171', '16994', '52', '52', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17405', '540', '540', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17407', '270', '364', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17404', '540', '540', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17399', '2394', '2394', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17391', '44', '74', '240', '10');
-INSERT INTO `guild_shops` VALUES ('5171', '17390', '145', '245', '240', '10');
-INSERT INTO `guild_shops` VALUES ('5171', '17389', '332', '561', '240', '75');
-INSERT INTO `guild_shops` VALUES ('5171', '17388', '934', '1667', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5171', '17387', '4077', '4077', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17380', '25740', '25740', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5171', '17383', '1980', '2640', '240', '200');
-INSERT INTO `guild_shops` VALUES ('5171', '17382', '9657', '15398', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4443', '24', '165', '240', '25');
-INSERT INTO `guild_shops` VALUES ('517', '4472', '30', '198', '240', '50');
-INSERT INTO `guild_shops` VALUES ('517', '624', '24', '156', '240', '25');
-INSERT INTO `guild_shops` VALUES ('517', '4484', '1350', '8784', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4426', '195', '665', '240', '100');
-INSERT INTO `guild_shops` VALUES ('517', '4427', '1350', '1350', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4482', '1712', '2000', '240', '100');
-INSERT INTO `guild_shops` VALUES ('517', '4483', '195', '1248', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4428', '45', '396', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4361', '1196', '1289', '240', '25');
-INSERT INTO `guild_shops` VALUES ('517', '4304', '30520', '34720', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4481', '505', '748', '240', '75');
-INSERT INTO `guild_shops` VALUES ('517', '4385', '520', '748', '240', '75');
-INSERT INTO `guild_shops` VALUES ('517', '4402', '8064', '8568', '240', '100');
-INSERT INTO `guild_shops` VALUES ('517', '4383', '3225', '5621', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4399', '1350', '4680', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4485', '13888', '13888', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4290', '1008', '1289', '240', '50');
-INSERT INTO `guild_shops` VALUES ('517', '4451', '5440', '19520', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4461', '4050', '4050', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4384', '5250', '5250', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4514', '60', '396', '240', '50');
-INSERT INTO `guild_shops` VALUES ('517', '4580', '4760', '4760', '240', '1');
-INSERT INTO `guild_shops` VALUES ('517', '4462', '1350', '8064', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4480', '455', '2800', '240', '255');
-INSERT INTO `guild_shops` VALUES ('517', '4479', '7560', '8784', '240', '250');
-INSERT INTO `guild_shops` VALUES ('517', '4471', '11984', '13888', '240', '255');
-INSERT INTO `guild_shops` VALUES ('518', '17388', '766', '1667', '240', '150');
-INSERT INTO `guild_shops` VALUES ('518', '17382', '7081', '15398', '240', '255');
-INSERT INTO `guild_shops` VALUES ('518', '4399', '1350', '4680', '240', '255');
-INSERT INTO `guild_shops` VALUES ('518', '4485', '2100', '13888', '240', '255');
-INSERT INTO `guild_shops` VALUES ('518', '4317', '120', '120', '240', '1');
-INSERT INTO `guild_shops` VALUES ('518', '4484', '1350', '8784', '240', '255');
-INSERT INTO `guild_shops` VALUES ('518', '4385', '115', '748', '240', '110');
-INSERT INTO `guild_shops` VALUES ('518', '5121', '2142', '2142', '240', '1');
-INSERT INTO `guild_shops` VALUES ('518', '4314', '300', '600', '240', '50');
-INSERT INTO `guild_shops` VALUES ('518', '4318', '3375', '3375', '240', '1');
-INSERT INTO `guild_shops` VALUES ('518', '624', '24', '156', '240', '25');
-INSERT INTO `guild_shops` VALUES ('518', '4443', '24', '165', '240', '25');
-INSERT INTO `guild_shops` VALUES ('519', '17395', '9', '12', '240', '2');
-INSERT INTO `guild_shops` VALUES ('519', '17399', '2394', '2394', '240', '1');
-INSERT INTO `guild_shops` VALUES ('519', '17407', '270', '364', '240', '1');
-INSERT INTO `guild_shops` VALUES ('519', '17400', '691', '4000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('519', '17387', '4077', '4077', '240', '1');
-INSERT INTO `guild_shops` VALUES ('519', '4360', '25', '153', '240', '25');
-INSERT INTO `guild_shops` VALUES ('519', '4484', '1350', '8928', '240', '255');
-INSERT INTO `guild_shops` VALUES ('519', '4399', '1350', '8856', '240', '255');
-INSERT INTO `guild_shops` VALUES ('519', '4485', '2100', '13888', '240', '255');
-INSERT INTO `guild_shops` VALUES ('519', '4451', '5440', '19520', '240', '255');
-INSERT INTO `guild_shops` VALUES ('519', '4514', '60', '396', '240', '50');
-INSERT INTO `guild_shops` VALUES ('519', '4480', '455', '2800', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '17399', '2394', '2394', '240', '1');
-INSERT INTO `guild_shops` VALUES ('520', '17387', '4077', '4077', '240', '1');
-INSERT INTO `guild_shops` VALUES ('520', '17383', '1980', '2640', '240', '200');
-INSERT INTO `guild_shops` VALUES ('520', '17388', '934', '1667', '240', '150');
-INSERT INTO `guild_shops` VALUES ('520', '17382', '9657', '15398', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '4472', '30', '198', '240', '50');
-INSERT INTO `guild_shops` VALUES ('520', '624', '24', '156', '240', '25');
-INSERT INTO `guild_shops` VALUES ('520', '4360', '25', '153', '240', '25');
-INSERT INTO `guild_shops` VALUES ('520', '4484', '1350', '8784', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '4385', '520', '775', '240', '75');
-INSERT INTO `guild_shops` VALUES ('520', '4399', '1350', '7920', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '4485', '12208', '13888', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '4451', '3280', '19520', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '4461', '4050', '4995', '240', '175');
-INSERT INTO `guild_shops` VALUES ('520', '4384', '5250', '27160', '240', '255');
-INSERT INTO `guild_shops` VALUES ('520', '4500', '29', '147', '240', '20');
-INSERT INTO `guild_shops` VALUES ('520', '4514', '60', '396', '240', '50');
-INSERT INTO `guild_shops` VALUES ('520', '4480', '455', '2800', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '914', '1125', '5100', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '920', '1084', '5494', '240', '150');
-INSERT INTO `guild_shops` VALUES ('521', '922', '297', '300', '240', '1');
-INSERT INTO `guild_shops` VALUES ('521', '925', '1012', '4017', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '1108', '573', '795', '240', '40');
-INSERT INTO `guild_shops` VALUES ('521', '951', '90', '504', '240', '70');
-INSERT INTO `guild_shops` VALUES ('521', '621', '21', '30', '240', '2');
-INSERT INTO `guild_shops` VALUES ('521', '622', '36', '57', '240', '4');
-INSERT INTO `guild_shops` VALUES ('521', '636', '15', '97', '255', '75');
-INSERT INTO `guild_shops` VALUES ('521', '4165', '984', '5856', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '638', '138', '777', '240', '125');
-INSERT INTO `guild_shops` VALUES ('521', '4443', '24', '165', '240', '25');
-INSERT INTO `guild_shops` VALUES ('521', '933', '600', '3360', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '932', '1020', '5712', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '4154', '6300', '7700', '240', '250');
-INSERT INTO `guild_shops` VALUES ('521', '4157', '800', '2240', '240', '240');
-INSERT INTO `guild_shops` VALUES ('521', '4150', '600', '3584', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '4162', '810', '4284', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '947', '3360', '21862', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '4166', '750', '4480', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '4112', '682', '946', '240', '50');
-INSERT INTO `guild_shops` VALUES ('521', '4116', '3375', '5760', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '4128', '4348', '22227', '240', '255');
-INSERT INTO `guild_shops` VALUES ('521', '2131', '75', '150', '240', '15');
-INSERT INTO `guild_shops` VALUES ('521', '18228', '114', '114', '240', '1');
-INSERT INTO `guild_shops` VALUES ('521', '18232', '114', '114', '240', '1');
-INSERT INTO `guild_shops` VALUES ('521', '18236', '21', '28', '240', '2');
-INSERT INTO `guild_shops` VALUES ('5221', '640', '9', '26', '240', '5');
-INSERT INTO `guild_shops` VALUES ('5221', '736', '315', '705', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '644', '1500', '9800', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '746', '250380', '250380', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5221', '752', '55755', '55755', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5221', '754', '87187', '87187', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5221', '673', '210', '1131', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5221', '681', '10500', '42000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '762', '334800', '334800', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5221', '769', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '770', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '771', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '772', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '773', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '774', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '775', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '776', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '795', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '796', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '799', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '800', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '806', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '807', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '809', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '814', '1396', '1937', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5221', '788', '9000', '16320', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '790', '9000', '16320', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '811', '9000', '16320', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '815', '9000', '16320', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5221', '798', '9000', '16320', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '808', '9000', '16320', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '784', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '803', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '810', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '801', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '791', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '805', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '797', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '802', '23400', '49608', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '785', '48336', '284544', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '786', '48336', '284544', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '804', '48336', '284544', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '794', '48336', '284544', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '13327', '1125', '5850', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '13316', '73416', '73416', '240', '1');
-INSERT INTO `guild_shops` VALUES ('522', '13332', '1186', '1728', '240', '110');
-INSERT INTO `guild_shops` VALUES ('522', '13333', '1186', '1728', '240', '110');
-INSERT INTO `guild_shops` VALUES ('522', '13334', '1186', '1728', '240', '110');
-INSERT INTO `guild_shops` VALUES ('522', '13336', '1186', '1728', '240', '110');
-INSERT INTO `guild_shops` VALUES ('522', '13454', '114', '255', '240', '50');
-INSERT INTO `guild_shops` VALUES ('522', '13446', '21060', '21060', '240', '1');
-INSERT INTO `guild_shops` VALUES ('522', '13444', '1875', '2950', '240', '200');
-INSERT INTO `guild_shops` VALUES ('522', '13471', '1875', '2950', '240', '200');
-INSERT INTO `guild_shops` VALUES ('522', '13472', '1875', '2950', '240', '200');
-INSERT INTO `guild_shops` VALUES ('522', '13474', '1875', '2950', '240', '200');
-INSERT INTO `guild_shops` VALUES ('522', '12496', '117', '117', '240', '1');
-INSERT INTO `guild_shops` VALUES ('522', '12497', '1029', '1080', '240', '10');
-INSERT INTO `guild_shops` VALUES ('522', '12495', '4398', '4896', '240', '100');
-INSERT INTO `guild_shops` VALUES ('522', '16551', '1233', '3631', '240', '255');
-INSERT INTO `guild_shops` VALUES ('522', '16641', '6240', '6240', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '17081', '3229', '3229', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '12449', '7128', '7128', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '12577', '9144', '9144', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '12833', '1750', '1750', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '12961', '985', '985', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '1588', '20400', '20400', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '2143', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5222', '2144', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('523', '640', '9', '26', '240', '5');
-INSERT INTO `guild_shops` VALUES ('523', '736', '315', '705', '240', '100');
-INSERT INTO `guild_shops` VALUES ('523', '769', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '770', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '771', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '772', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '773', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '774', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '775', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '776', '2632', '6328', '240', '255');
-INSERT INTO `guild_shops` VALUES ('523', '2143', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('523', '2144', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5241', '856', '45', '276', '240', '40');
-INSERT INTO `guild_shops` VALUES ('5241', '505', '57', '349', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5241', '858', '483', '2967', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '859', '937', '3250', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '861', '393', '1312', '240', '160');
-INSERT INTO `guild_shops` VALUES ('5241', '863', '2700', '12240', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '851', '4250', '16670', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '506', '5173', '33796', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '853', '2155', '13680', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '854', '2650', '3427', '240', '125');
-INSERT INTO `guild_shops` VALUES ('5241', '834', '675', '3276', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '695', '120', '120', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5241', '4509', '9', '12', '240', '1');
-INSERT INTO `guild_shops` VALUES ('5241', '917', '1821', '2245', '240', '75');
-INSERT INTO `guild_shops` VALUES ('5241', '13594', '132', '246', '240', '25');
-INSERT INTO `guild_shops` VALUES ('5241', '13588', '2484', '3146', '240', '125');
-INSERT INTO `guild_shops` VALUES ('5241', '13571', '7282', '37356', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5241', '13570', '10800', '11304', '240', '100');
-INSERT INTO `guild_shops` VALUES ('5241', '13593', '24000', '24640', '240', '110');
-INSERT INTO `guild_shops` VALUES ('5241', '13203', '2641', '2641', '240', '1');
-INSERT INTO `guild_shops` VALUES ('524', '13200', '13860', '80572', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '13081', '411', '411', '240', '1');
-INSERT INTO `guild_shops` VALUES ('524', '13089', '6384', '15662', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12569', '13514', '33476', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12572', '44460', '163612', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12993', '3366', '7001', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12994', '14352', '54537', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12696', '324', '1425', '240', '200');
-INSERT INTO `guild_shops` VALUES ('524', '12697', '2700', '17136', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12700', '29700', '182160', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12440', '396', '1566', '240', '200');
-INSERT INTO `guild_shops` VALUES ('524', '12442', '13179', '51000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12824', '482', '2615', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12992', '453', '629', '240', '40');
-INSERT INTO `guild_shops` VALUES ('524', '16386', '945', '3780', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '16388', '11970', '41496', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '12294', '25920', '158976', '240', '255');
-INSERT INTO `guild_shops` VALUES ('524', '2129', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('525', '936', '14', '67', '240', '10');
-INSERT INTO `guild_shops` VALUES ('525', '611', '30', '42', '240', '2');
-INSERT INTO `guild_shops` VALUES ('525', '610', '45', '66', '240', '4');
-INSERT INTO `guild_shops` VALUES ('525', '612', '45', '194', '240', '30');
-INSERT INTO `guild_shops` VALUES ('525', '614', '60', '361', '240', '55');
-INSERT INTO `guild_shops` VALUES ('525', '4378', '45', '264', '240', '40');
-INSERT INTO `guild_shops` VALUES ('525', '616', '60', '368', '240', '50');
-INSERT INTO `guild_shops` VALUES ('525', '618', '21', '50', '240', '5');
-INSERT INTO `guild_shops` VALUES ('525', '619', '36', '42', '240', '1');
-INSERT INTO `guild_shops` VALUES ('525', '620', '45', '276', '240', '50');
-INSERT INTO `guild_shops` VALUES ('525', '621', '21', '25', '240', '1');
-INSERT INTO `guild_shops` VALUES ('525', '622', '36', '220', '240', '35');
-INSERT INTO `guild_shops` VALUES ('525', '625', '66', '334', '240', '50');
-INSERT INTO `guild_shops` VALUES ('525', '628', '195', '572', '240', '50');
-INSERT INTO `guild_shops` VALUES ('525', '629', '36', '220', '240', '40');
-INSERT INTO `guild_shops` VALUES ('525', '4358', '139', '163', '240', '5');
-INSERT INTO `guild_shops` VALUES ('525', '4372', '93', '238', '240', '20');
-INSERT INTO `guild_shops` VALUES ('525', '4359', '180', '1200', '240', '150');
-INSERT INTO `guild_shops` VALUES ('525', '4570', '42', '190', '240', '30');
-INSERT INTO `guild_shops` VALUES ('525', '4363', '33', '200', '240', '30');
-INSERT INTO `guild_shops` VALUES ('5251', '4366', '18', '43', '240', '5');
-INSERT INTO `guild_shops` VALUES ('5251', '4571', '75', '460', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5251', '4367', '36', '238', '240', '35');
-INSERT INTO `guild_shops` VALUES ('5251', '4380', '165', '1076', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5251', '4389', '60', '157', '240', '15');
-INSERT INTO `guild_shops` VALUES ('5251', '4390', '39', '198', '240', '30');
-INSERT INTO `guild_shops` VALUES ('5251', '4392', '30', '152', '240', '21');
-INSERT INTO `guild_shops` VALUES ('5251', '4412', '243', '1547', '240', '250');
-INSERT INTO `guild_shops` VALUES ('5251', '4431', '57', '367', '240', '55');
-INSERT INTO `guild_shops` VALUES ('5251', '4432', '45', '261', '240', '40');
-INSERT INTO `guild_shops` VALUES ('5251', '4445', '14', '220', '240', '35');
-INSERT INTO `guild_shops` VALUES ('5251', '4468', '60', '384', '240', '55');
-INSERT INTO `guild_shops` VALUES ('5251', '4472', '147', '198', '240', '10');
-INSERT INTO `guild_shops` VALUES ('5251', '4491', '150', '992', '240', '125');
-INSERT INTO `guild_shops` VALUES ('5251', '4364', '90', '576', '240', '90');
-INSERT INTO `guild_shops` VALUES ('5251', '4391', '18', '274', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5251', '4510', '21', '50', '240', '5');
-INSERT INTO `guild_shops` VALUES ('5251', '4437', '612', '3024', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4376', '90', '364', '240', '50');
-INSERT INTO `guild_shops` VALUES ('5251', '4410', '318', '1706', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4381', '1382', '3600', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4422', '150', '888', '240', '150');
-INSERT INTO `guild_shops` VALUES ('5251', '4423', '225', '876', '240', '115');
-INSERT INTO `guild_shops` VALUES ('5251', '4424', '825', '3875', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4441', '697', '4650', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4442', '300', '1600', '240', '250');
-INSERT INTO `guild_shops` VALUES ('525', '4425', '254', '1446', '240', '200');
-INSERT INTO `guild_shops` VALUES ('525', '4406', '638', '2200', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4436', '240', '1600', '240', '255');
-INSERT INTO `guild_shops` VALUES ('5251', '4490', '955', '2284', '240', '250');
-INSERT INTO `guild_shops` VALUES ('5251', '4492', '540', '3000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('525', '4489', '1950', '5000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('525', '4555', '1692', '7812', '240', '255');
-INSERT INTO `guild_shops` VALUES ('525', '4419', '34440', '34440', '240', '1');
-INSERT INTO `guild_shops` VALUES ('525', '4417', '3151', '16236', '240', '255');
-INSERT INTO `guild_shops` VALUES ('525', '1554', '431', '483', '240', '10');
-INSERT INTO `guild_shops` VALUES ('525', '1555', '1061', '1188', '240', '25');
-INSERT INTO `guild_shops` VALUES ('5251', '1590', '536', '1344', '240', '150');
-INSERT INTO `guild_shops` VALUES ('525', '1840', '1500', '3600', '240', '255');
-INSERT INTO `guild_shops` VALUES ('525', '2112', '530', '540', '240', '2');
-INSERT INTO `guild_shops` VALUES ('526', '640', '9', '15', '240', '1');
-INSERT INTO `guild_shops` VALUES ('526', '641', '30', '106', '240', '15');
-INSERT INTO `guild_shops` VALUES ('526', '643', '675', '3825', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '649', '62', '346', '240', '50');
-INSERT INTO `guild_shops` VALUES ('526', '651', '2700', '2916', '240', '40');
-INSERT INTO `guild_shops` VALUES ('526', '660', '69', '138', '240', '15');
-INSERT INTO `guild_shops` VALUES ('526', '662', '4050', '4050', '240', '1');
-INSERT INTO `guild_shops` VALUES ('526', '672', '81', '106', '240', '5');
-INSERT INTO `guild_shops` VALUES ('526', '674', '4945', '30744', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '676', '7350', '13720', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '680', '5796', '11781', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '16411', '9576', '46986', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '16412', '22320', '49699', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '16448', '240', '761', '240', '100');
-INSERT INTO `guild_shops` VALUES ('526', '16545', '21067', '95504', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '16565', '1395', '8853', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '16650', '18270', '18270', '240', '1');
-INSERT INTO `guild_shops` VALUES ('526', '16651', '66555', '209426', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '13871', '27216', '47355', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '13873', '36960', '195148', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '14001', '42476', '88529', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '14003', '79745', '84198', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '14118', '69400', '69400', '240', '1');
-INSERT INTO `guild_shops` VALUES ('526', '14243', '27945', '92404', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '14245', '52785', '166096', '240', '255');
-INSERT INTO `guild_shops` VALUES ('526', '2143', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('526', '2144', '75', '75', '240', '1');
-INSERT INTO `guild_shops` VALUES ('527', '640', '9', '15', '240', '1');
-INSERT INTO `guild_shops` VALUES ('527', '641', '30', '106', '240', '15');
-INSERT INTO `guild_shops` VALUES ('527', '643', '675', '3825', '240', '255');
-INSERT INTO `guild_shops` VALUES ('527', '660', '69', '138', '240', '15');
-INSERT INTO `guild_shops` VALUES ('527', '652', '3517', '25620', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '640', '9', '15', '240', '1');
-INSERT INTO `guild_shops` VALUES ('528', '641', '30', '106', '240', '15');
-INSERT INTO `guild_shops` VALUES ('528', '643', '675', '3825', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '649', '62', '346', '240', '50');
-INSERT INTO `guild_shops` VALUES ('528', '651', '2700', '2916', '240', '40');
-INSERT INTO `guild_shops` VALUES ('528', '660', '69', '138', '240', '15');
-INSERT INTO `guild_shops` VALUES ('528', '662', '4050', '4050', '240', '1');
-INSERT INTO `guild_shops` VALUES ('528', '672', '81', '106', '240', '5');
-INSERT INTO `guild_shops` VALUES ('528', '16473', '5589', '6458', '240', '150');
-INSERT INTO `guild_shops` VALUES ('528', '16513', '11845', '59229', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '16640', '290', '695', '240', '125');
-INSERT INTO `guild_shops` VALUES ('528', '17044', '6033', '26756', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '12450', '15300', '15552', '240', '75');
-INSERT INTO `guild_shops` VALUES ('528', '12836', '19088', '19514', '240', '75');
-INSERT INTO `guild_shops` VALUES ('528', '12706', '12950', '17971', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '12672', '19440', '26956', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '13080', '13770', '19094', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '12299', '708', '4611', '240', '255');
-INSERT INTO `guild_shops` VALUES ('528', '17298', '294', '332', '240', '10');
-INSERT INTO `guild_shops` VALUES ('60419', '1652', '160', '360', '80', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '4877', '39270', '102480', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4880', '14070', '15750', '0', '1');
-INSERT INTO `guild_shops` VALUES ('60419', '4875', '2250', '2250', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4878', '37800', '102480', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4879', '14070', '15750', '0', '1');
-INSERT INTO `guild_shops` VALUES ('60419', '4874', '40740', '40740', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4876', '41370', '99960', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '704', '96', '149', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '1134', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1555', '1061', '1259', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '1475', '579', '3128', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '4958', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4937', '1561', '1747', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '5164', '2075', '2179', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '1173', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4952', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1590', '536', '700', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '4934', '1561', '1747', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '4931', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4949', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1182', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1185', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4928', '1561', '1747', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '1167', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1191', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4955', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1170', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1176', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4940', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1188', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1179', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1194', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '5236', '224', '224', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '829', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4943', '1561', '1747', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '657', '4690', '22960', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '915', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '4961', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60419', '1164', '30', '65', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '1554', '431', '512', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60419', '1161', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '626', '190', '1111', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '620', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '657', '4690', '10500', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '704', '96', '397', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '829', '35070', '77280', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '915', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1134', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1161', '66', '147', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1164', '30', '190', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1167', '147', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1170', '58', '147', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1173', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1176', '44', '147', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1179', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1182', '445', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1185', '395', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1188', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1191', '112', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1194', '460', '545', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1240', '165', '660', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1415', '55147', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1471', '316', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '1475', '579', '1188', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '1554', '431', '512', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '1555', '1019', '1259', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '1590', '536', '2944', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '1652', '150', '200', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '2702', '1500', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4928', '1561', '6713', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4931', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4934', '1561', '6713', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4937', '1561', '6713', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4940', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4943', '1561', '6713', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4946', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4949', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4952', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4955', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4958', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '4961', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60420', '5164', '1945', '2854', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60420', '5237', '369', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '474', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '475', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '476', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '477', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '478', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '479', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '480', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60418', '481', '21000', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '16962', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16406', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16420', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16407', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13207', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17340', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16405', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17284', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16411', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12585', '4931', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12457', '3272', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12969', '2528', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12841', '3951', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12713', '2713', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '16990', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16413', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13088', '91200', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16974', '224510', '640640', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17322', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17304', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13206', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16421', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12456', '552', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12843', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12587', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13204', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16915', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16924', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16973', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16970', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17320', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16984', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17302', '1190', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13728', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16903', '118496', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16897', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16871', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16975', '13266', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12584', '833', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '17802', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16901', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12715', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16988', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16896', '592', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12968', '424', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '17303', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16967', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17285', '117904', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16412', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17267', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16982', '16004', '39645', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13111', '20510', '146116', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16991', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16987', '14033', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16419', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17309', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17259', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17314', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '13208', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16902', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12588', '72600', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12460', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12844', '94248', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12716', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16919', '22765', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16913', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '17301', '43', '151', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '13205', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12840', '666', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12586', '13266', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12458', '8972', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12970', '11071', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12842', '10805', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '12714', '7428', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '16917', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '16966', '2103', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '17265', '25340', '63742', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12712', '458', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '16960', '3575', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '16900', '1608', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60417', '16964', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60417', '12459', '32436', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '704', '96', '149', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1134', '810', '2095', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '1555', '1061', '1259', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1475', '579', '1188', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1472', '369', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '5164', '1945', '2854', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1173', '40', '147', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1590', '536', '700', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1155', '436', '645', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1182', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '1185', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '1167', '30', '66', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1191', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '1170', '30', '137', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1176', '30', '120', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '5235', '187', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1652', '150', '160', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1188', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '1179', '96', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '1194', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '829', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60421', '657', '4690', '21000', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '915', '2700', '16120', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1164', '30', '65', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1554', '431', '512', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1161', '30', '96', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60421', '1415', '55147', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16962', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '704', '108', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1134', '810', '993', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '13207', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17340', '58', '436', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1555', '1259', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12585', '5520', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12457', '3663', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12969', '2830', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12841', '4423', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12713', '3037', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1475', '579', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16990', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '13088', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16974', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17322', '81', '116', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17304', '57960', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1472', '369', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '13206', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '5164', '1945', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12456', '618', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12843', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12587', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '13204', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16915', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1173', '172', '174', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16924', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1590', '639', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16973', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16970', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17320', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1155', '436', '1422', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16984', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17302', '347', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '13728', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1182', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16903', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16897', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1185', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16871', '404395', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16975', '11583', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1167', '94', '174', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12584', '933', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '17802', '418563', '464059', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16901', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1191', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12715', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16988', '14676', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16896', '517', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12968', '475', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1170', '94', '174', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16967', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1176', '94', '174', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '17285', '220248', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '5235', '187', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '17267', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16982', '4752', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '13111', '29942', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16991', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16987', '12253', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17259', '158976', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17314', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '13208', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1652', '150', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1188', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16902', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '1179', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12588', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12460', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12844', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12716', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16919', '2728', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1194', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '16913', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '17301', '29', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '829', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '13205', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12840', '745', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12586', '14850', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12458', '10044', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12970', '12393', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12842', '12096', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '12714', '8316', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16917', '4226', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16966', '4226', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '657', '4690', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '17265', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12712', '513', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '915', '2700', '6048', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1164', '30', '65', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1554', '512', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16960', '3121', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1161', '160', '174', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '1415', '55147', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16900', '1404', '0', '240', '255');
-INSERT INTO `guild_shops` VALUES ('60422', '16964', '0', '0', '0', '0');
-INSERT INTO `guild_shops` VALUES ('60422', '12459', '0', '0', '0', '0');
+-- To cope with the current 30 item limit, I have added in every single item entry according to Blue Gartyr Wiki
+-- I then chose the 30 most important items I could think of for each vendor, and commented out the rest for now.
+-- I did my best to put all the daily restocks on 1 vendor, and the non-restocks on the other. 
+-- This should leave ~60 items for each guild, for now. I think this will be enough to make most happy. 
+-- When the cap is lifted, all you will have to do is remove the comments and make the (S) vendors the same ID and it will display 100% of the item lists
+
+
+-- Cauzeriste (Northern San d'Oria) Woodworking Guild (S)
+-- INSERT INTO `guild_shops` VALUES ('513', '3', '295500', '295500', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '22', '282', '691', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('513', '23', '829', '2035', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '24', '70200', '408096', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '26', '31500', '31500', '20', '0', '6');
+-- INSERT INTO `guild_shops` VALUES ('513', '92', '738', '2322', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '97', '5508', '13512', '20', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('513', '102', '291', '713', '25', '0', '25');
+INSERT INTO `guild_shops` VALUES ('513', '688', '15', '30', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '689', '27', '59', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '690', '1723', '10295', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '691', '45', '192', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '693', '640', '3928', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '694', '2119', '4182', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '695', '120', '184', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '696', '330', '686', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '697', '528', '930', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '698', '60', '182', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '699', '4740', '24016', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '700', '9075', '19844', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '701', '6615', '37044', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '702', '9600', '23040', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '704', '96', '230', '375', '100', '150');
+INSERT INTO `guild_shops` VALUES ('513', '705', '3', '18', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '706', '27', '151', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '707', '1723', '4136', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '708', '45', '276', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '710', '2119', '4521', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '711', '1015', '3982', '100', '0', '100');
+INSERT INTO `guild_shops` VALUES ('513', '712', '120', '256', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '713', '330', '836', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '714', '607', '2559', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '715', '72', '403', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('513', '716', '4740', '23257', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('513', '719', '23552', '25216', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('513', '12289', '88', '232', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '12290', '847', '1173', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '12984', '176', '280', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '12985', '1625', '1625', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '12986', '6885', '17625', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '12987', '38707', '38707', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '16832', '194', '201', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '16833', '809', '4294', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '16834', '6448', '25376', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '16835', '27165', '34750', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '16845', '31314', '34445', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '17024', '48', '141', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17025', '1165', '5707', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17027', '7525', '21003', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('513', '17030', '14766', '41876', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '17049', '34', '102', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17050', '247', '703', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17051', '1049', '3038', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17052', '3827', '19420', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17088', '46', '126', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17089', '424', '977', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17090', '3371', '7103', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17095', '281', '1260', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17096', '3400', '23349', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17097', '22617', '35932', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17098', '29390', '72633', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '17152', '41', '202', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17153', '1039', '1055', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17154', '5306', '15602', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17154', '21000', '128100', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('513', '17156', '82971', '82971', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '17160', '870', '969', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17162', '14614', '42969', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17163', '28944', '82080', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('513', '17164', '57405', '166219', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('513', '17216', '187', '354', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17218', '10311', '67100', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17280', '1172', '5250', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('513', '17318', '6', '13', '8910', '0', '3564');
+INSERT INTO `guild_shops` VALUES ('513', '17320', '10', '14', '5940', '0', '2376');
+INSERT INTO `guild_shops` VALUES ('513', '17321', '28', '34', '2970', '0', '1188');
+-- INSERT INTO `guild_shops` VALUES ('513', '17345', '69', '163', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17347', '1028', '5060', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17348', '11256', '32592', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17353', '37', '94', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('513', '17354', '4300', '12200', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('513', '17355', '13400', '38800', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('513', '17424', '7717', '20685', '20', '0', '3');
+
+-- Chaupire (Northern San d'Oria) Woodworking Guild (S)
+INSERT INTO `guild_shops` VALUES ('5132', '3', '295500', '295500', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5132', '22', '282', '691', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5132', '23', '829', '2035', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '24', '70200', '408096', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5132', '26', '31500', '31500', '20', '0', '6');
+INSERT INTO `guild_shops` VALUES ('5132', '92', '738', '2322', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5132', '97', '5508', '13512', '20', '0', '12');
+INSERT INTO `guild_shops` VALUES ('5132', '102', '291', '713', '25', '0', '25');
+-- INSERT INTO `guild_shops` VALUES ('5132', '688', '15', '30', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '689', '27', '59', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '690', '1723', '10295', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '691', '45', '192', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '693', '640', '3928', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '694', '2119', '4182', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '695', '120', '184', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '696', '330', '686', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '697', '528', '930', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '698', '60', '182', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '699', '4740', '24016', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '700', '9075', '19844', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '701', '6615', '37044', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '702', '9600', '23040', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '704', '96', '230', '375', '100', '150');
+-- INSERT INTO `guild_shops` VALUES ('5132', '705', '3', '18', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '706', '27', '151', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '707', '1723', '4136', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '708', '45', '276', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '710', '2119', '4521', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '711', '1015', '3982', '100', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '712', '120', '256', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '713', '330', '836', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '714', '607', '2559', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '715', '72', '403', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5132', '716', '4740', '23257', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5132', '719', '23552', '25216', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('5132', '12289', '88', '232', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '12290', '847', '1173', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5132', '12984', '176', '280', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '12985', '1625', '1625', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '12986', '6885', '17625', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '12987', '38707', '38707', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5132', '16832', '194', '201', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '16833', '809', '4294', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '16834', '6448', '25376', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5132', '16835', '27165', '34750', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5132', '16845', '31314', '34445', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5132', '17024', '48', '141', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '17025', '1165', '5707', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5132', '17027', '7525', '21003', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5132', '17030', '14766', '41876', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5132', '17049', '34', '102', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '17050', '247', '703', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '17051', '1049', '3038', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '17052', '3827', '19420', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5132', '17088', '46', '126', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '17089', '424', '977', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5132', '17090', '3371', '7103', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17095', '281', '1260', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17096', '3400', '23349', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17097', '22617', '35932', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17098', '29390', '72633', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17152', '41', '202', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17153', '1039', '1055', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17154', '5306', '15602', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17154', '21000', '128100', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17156', '82971', '82971', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17160', '870', '969', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17162', '14614', '42969', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17163', '28944', '82080', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17164', '57405', '166219', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17216', '187', '354', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17218', '10311', '67100', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17280', '1172', '5250', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17318', '6', '13', '8910', '0', '3564');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17320', '10', '14', '5940', '0', '2376');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17321', '28', '34', '2970', '0', '1188');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17345', '69', '163', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17347', '1028', '5060', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17348', '11256', '32592', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17353', '37', '94', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17354', '4300', '12200', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17355', '13400', '38800', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5132', '17424', '7717', '20685', '20', '0', '3');
+
+-- Shih Tayuun (Bonecraft Guild) Windurst Woods (S)
+INSERT INTO `guild_shops` VALUES ('514', '864', '72', '288', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('514', '880', '70', '349', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('514', '881', '3469', '11306', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('514', '882', '150', '760', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('514', '884', '3741', '12177', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('514', '885', '21840', '74256', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('514', '888', '90', '90', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('514', '889', '380', '510', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('514', '893', '1766', '4669', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('514', '894', '968', '2952', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('514', '895', '3060', '15560', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('514', '896', '2044', '12166', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('514', '897', '1588', '6683', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('514', '898', '163', '163', '375', '0', '150');
+INSERT INTO `guild_shops` VALUES ('514', '2130', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('514', '12414', '11377', '37771', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('514', '12454', '3912', '17525', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('514', '12455', '5728', '32079', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('514', '12505', '336', '389', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('514', '12506', '4500', '16350', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('514', '12507', '12825', '83448', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('514', '12582', '11507', '30011', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('514', '12583', '12246', '49455', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('514', '12710', '2448', '14231', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('514', '12711', '4653', '25312', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('514', '12834', '6588', '11106', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('514', '12835', '16956', '54265', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('514', '12837', '170016', '225456', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('514', '12966', '7722', '14493', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('514', '12967', '18447', '27659', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '13076', '2938', '4464', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '13090', '7188', '8869', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('514', '13090', '7188', '8869', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('514', '13091', '29568', '106260', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13313', '565', '807', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('514', '13313', '565', '807', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('514', '13321', '1359', '7900', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '13323', '15408', '15408', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('514', '13324', '38565', '38565', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13441', '1359', '1395', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '13442', '565', '807', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('514', '13457', '2650', '2721', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('514', '13458', '14175', '61992', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('514', '13459', '7200', '8832', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13461', '11565', '43599', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13711', '29925', '146832', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13712', '43312', '96442', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13713', '23625', '57960', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13715', '37338', '131712', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '13744', '208550', '208550', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('514', '13981', '67439', '72204', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('514', '16405', '213', '519', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('514', '16406', '14428', '35251', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('514', '16407', '1521', '2859', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '16642', '9050', '19053', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '16649', '4887', '22154', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '17026', '4032', '10590', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '17062', '16493', '19859', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '17257', '39568', '19859', '20', '0', '7');
+-- INSERT INTO `guild_shops` VALUES ('514', '17299', '2419', '2419', '198', '0', '99');
+-- INSERT INTO `guild_shops` VALUES ('514', '17319', '3', '21', '8910', '1782', '3564'); 
+-- INSERT INTO `guild_shops` VALUES ('514', '17352', '21645', '47330', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('514', '17610', '22500', '53100', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('514', '17612', '34440', '39606', '20', '0', '10');
+
+-- Retto-Marutto (Bonecraft Guild) Windurst Woods (S)
+-- INSERT INTO `guild_shops` VALUES ('5142', '864', '72', '288', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5142', '880', '70', '349', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5142', '881', '3469', '11306', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5142', '882', '150', '760', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5142', '884', '3741', '12177', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5142', '885', '21840', '74256', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5142', '888', '90', '90', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5142', '889', '380', '510', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5142', '893', '1766', '4669', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5142', '894', '968', '2952', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5142', '895', '3060', '15560', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5142', '896', '2044', '12166', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5142', '897', '1588', '6683', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5142', '898', '163', '163', '375', '0', '150');
+-- INSERT INTO `guild_shops` VALUES ('5142', '2130', '75', '75', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12414', '11377', '37771', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12454', '3912', '17525', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12455', '5728', '32079', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12505', '336', '389', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12506', '4500', '16350', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12507', '12825', '83448', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12582', '11507', '30011', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12583', '12246', '49455', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12710', '2448', '14231', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12711', '4653', '25312', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12834', '6588', '11106', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12835', '16956', '54265', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12837', '170016', '225456', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12966', '7722', '14493', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5142', '12967', '18447', '27659', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '13076', '2938', '4464', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '13090', '7188', '8869', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5142', '13091', '29568', '106260', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13313', '565', '807', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5142', '13321', '1359', '7900', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '13323', '15408', '15408', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5142', '13324', '38565', '38565', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13441', '1359', '1395', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '13442', '565', '807', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5142', '13457', '2650', '2721', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5142', '13458', '14175', '61992', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5142', '13459', '7200', '8832', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13461', '11565', '43599', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13711', '29925', '146832', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13712', '43312', '96442', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13713', '23625', '57960', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13715', '37338', '131712', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '13744', '208550', '208550', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5142', '13981', '67439', '72204', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5142', '16405', '213', '519', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5142', '16406', '14428', '35251', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5142', '16407', '1521', '2859', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '16642', '9050', '19053', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '16649', '4887', '22154', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '17026', '4032', '10590', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '17062', '16493', '19859', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5142', '17257', '39568', '19859', '20', '0', '7');
+INSERT INTO `guild_shops` VALUES ('5142', '17299', '2419', '2419', '198', '0', '99');
+-- INSERT INTO `guild_shops` VALUES ('5142', '17319', '3', '21', '8910', '1782', '3564'); 
+-- INSERT INTO `guild_shops` VALUES ('5142', '17352', '21645', '47330', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5142', '17610', '22500', '53100', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5142', '17612', '34440', '39606', '20', '0', '10');
+
+-- Meriri (Clothcraft Guild) Windurst Woods (S)
+INSERT INTO `guild_shops` VALUES ('515', '816', '592', '3865', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '817', '45', '240', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '818', '144', '768', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '819', '750', '4200', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '820', '2700', '12528', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('515', '822', '585', '4760', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '823', '13338', '109440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('515', '824', '240', '1344', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('515', '825', '480', '2944', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('515', '826', '12840', '12840', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('515', '827', '9180', '48384', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('515', '828', '21851', '31710', '32', '0', '12');
+INSERT INTO `guild_shops` VALUES ('515', '832', '675', '4500', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '833', '15', '18', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('515', '834', '79', '200', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '835', '187', '1000', '375', '75', '100');
+INSERT INTO `guild_shops` VALUES ('515', '838', '9438', '34557', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('515', '839', '137', '870', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('515', '841', '26', '192', '375', '0', '150');
+INSERT INTO `guild_shops` VALUES ('515', '2128', '75', '86', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('515', '2145', '75', '180', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('515', '12464', '2710', '7898', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('515', '12465', '35315', '38882', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('515', '12466', '23200', '39400', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('515', '12499', '14160', '78080', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('515', '12593', '66992', '66992', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('515', '12600', '424', '1171', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('515', '12601', '14684', '14684', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('515', '12720', '2787', '7393', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('515', '12736', '1290', '3196', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('515', '12739', '37862', '172339', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('515', '12851', '135936', '228096', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('515', '12856', '372', '936', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('515', '12976', '1339', '6486', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('515', '12979', '171776', '171776', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('515', '13577', '15190', '42134', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('515', '13583', '318', '1683', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('515', '13584', '10321', '40322', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('515', '13750', '87178', '87178', '20', '0', '10');
+
+-- Kuzah Hpirohpon (Windurst Woods) Clothcraft Guild (S)
+-- INSERT INTO `guild_shops` VALUES ('5152', '816', '592', '3865', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '817', '45', '240', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '818', '144', '768', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '819', '750', '4200', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '820', '2700', '12528', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5152', '822', '585', '4760', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '823', '13338', '109440', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5152', '824', '240', '1344', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5152', '825', '480', '2944', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5152', '826', '12840', '12840', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5152', '827', '9180', '48384', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5152', '828', '21851', '31710', '32', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5152', '832', '675', '4500', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '833', '15', '18', '375', '75', '150');
+-- INSERT INTO `guild_shops` VALUES ('5152', '834', '79', '200', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '835', '187', '1000', '375', '75', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '838', '9438', '34557', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5152', '839', '137', '870', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5152', '841', '26', '192', '375', '0', '150');
+-- INSERT INTO `guild_shops` VALUES ('5152', '2128', '75', '86', '375', '75', '150');
+-- INSERT INTO `guild_shops` VALUES ('5152', '2145', '75', '180', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12464', '2710', '7898', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12465', '35315', '38882', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12466', '23200', '39400', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12499', '14160', '78080', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12593', '66992', '66992', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12600', '424', '1171', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12601', '14684', '14684', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12720', '2787', '7393', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5152', '12736', '1290', '3196', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5152', '12739', '37862', '172339', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5152', '12851', '135936', '228096', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5152', '12856', '372', '936', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5152', '12976', '1339', '6486', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5152', '12979', '171776', '171776', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5152', '13577', '15190', '42134', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5152', '13583', '318', '1683', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5152', '13584', '10321', '40322', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5152', '13750', '87178', '87178', '20', '0', '10');
+
+-- Gibol/Tilala (Clothcraft Guild) Selbina (S)
+INSERT INTO `guild_shops` VALUES ('516', '816', '592', '3865', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('516', '817', '45', '240', '255', '48', '100');  
+INSERT INTO `guild_shops` VALUES ('516', '818', '144', '768', '255', '48', '100'); 
+INSERT INTO `guild_shops` VALUES ('516', '819', '750', '4200', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('516', '820', '2700', '12528', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('516', '822', '585', '4760', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('516', '823', '13338', '109440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('516', '824', '240', '1344', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('516', '825', '480', '2944', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('516', '827', '9180', '48384', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('516', '832', '675', '4500', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('516', '833', '15', '18', '375', '75', '150');   
+INSERT INTO `guild_shops` VALUES ('516', '835', '187', '1000', '375', '75', '100');
+INSERT INTO `guild_shops` VALUES ('516', '838', '9438', '34557', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('516', '841', '26', '192', '375', '0', '150');
+
+-- Babubu (Port Windurst) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('517', '624', '24', '136', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4288', '5572', '13888', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('517', '4290', '1008', '1289', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4291', '582', '634', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4304', '13930', '32200', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('517', '4307', '10746', '24624', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('517', '4354', '120', '624', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4360', '64', '98', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4361', '1216', '1289', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4379', '240', '348', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4383', '1244', '2949', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('517', '4384', '5250', '6720', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('517', '4385', '308', '520', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4399', '1503', '6264', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('517', '4401', '91', '191', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4402', '3546', '8064', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('517', '4403', '108', '160', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4426', '195', '272', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4427', '1350', '2952', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('517', '4428', '60', '352', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4429', '979', '5068', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4443', '28', '134', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4451', '5160', '19520', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('517', '4461', '4050', '18792', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('517', '4462', '1350', '4824', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('517', '4464', '172', '1122', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('517', '4469', '580', '2400', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('517', '4470', '4112', '4186', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('517', '4471', '2100', '13328', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('517', '4472', '30', '65', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4473', '2310', '2833', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('517', '4477', '7400', '7880', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('517', '4479', '1368', '8280', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('517', '4480', '995', '2400', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('517', '4481', '320', '601', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4482', '300', '656', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4483', '195', '1248', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4484', '1350', '3582', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('517', '4485', '2576', '5572', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('517', '4500', '63', '208', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4514', '60', '128', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4515', '158', '274', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '4579', '3062', '8680', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('517', '4580', '1940', '1940', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('517', '16992', '52', '294', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '16993', '52', '294', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '16994', '52', '294', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '16996', '52', '240', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '16997', '52', '240', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '16998', '38', '214', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '16999', '52', '240', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17000', '52', '240', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17380', '25740', '25740', '30', '5', '5');
+-- INSERT INTO `guild_shops` VALUES ('517', '17382', '9657', '9657', '30', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('517', '17383', '1980', '1980', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('517', '17387', '4077', '4077', '30', '5', '15');
+-- INSERT INTO `guild_shops` VALUES ('517', '17388', '934', '934', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('517', '17389', '332', '332', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('517', '17390', '145', '145', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('517', '17391', '44', '44', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('517', '17392', '213', '283', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17393', '213', '283', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17394', '220', '300', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17395', '8', '9', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17396', '3', '8', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('517', '17399', '2394', '2394', '20', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('517', '17404', '540', '540', '20', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('517', '17405', '540', '540', '20', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('517', '17407', '303', '303', '20', '6', '12');
+
+-- Graegham (Selbina) Fishing Guild (S)
+INSERT INTO `guild_shops` VALUES ('518', '624', '58', '172', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4354', '257', '488', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4360', '32', '140', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4379', '134', '214', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4383', '2016', '5989', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('518', '4384', '5250', '13790', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('518', '4385', '261', '489', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4399', '2520', '7560', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('518', '4402', '3546', '8064', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('518', '4403', '30', '390', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4426', '195', '272', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4428', '136', '452', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4443', '64', '154', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4451', '3400', '16000', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('518', '4461', '6048', '20792', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('518', '4469', '770', '2856', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('518', '4470', '1790', '3056', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('518', '4472', '79', '238', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4477', '3000', '5220', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('518', '4479', '1368', '8280', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('518', '4480', '675', '1984', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('518', '4481', '320', '601', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4482', '716', '1056', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4483', '520', '1848', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4484', '1350', '3582', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('518', '4485', '2170', '13440', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('518', '4500', '24', '76', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4514', '60', '329', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '4515', '132', '248', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('518', '17382', '9657', '9657', '30', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('518', '17383', '1980', '1980', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('518', '17387', '4077', '4077', '30', '5', '15');
+-- INSERT INTO `guild_shops` VALUES ('518', '17388', '934', '934', '30', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('518', '17399', '2394', '2394', '20', '6', '12');
+
+-- Mendoline 	(Selbina) Fishing Guild (S)
+-- INSERT INTO `guild_shops` VALUES ('5182', '624', '58', '172', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4354', '257', '488', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4360', '32', '140', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4379', '134', '214', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4383', '2016', '5989', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4384', '5250', '13790', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4385', '261', '489', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4399', '2520', '7560', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4402', '3546', '8064', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4403', '30', '390', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4426', '195', '272', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4428', '136', '452', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4443', '64', '154', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4451', '3400', '16000', '30', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4461', '6048', '20792', '30', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4469', '770', '2856', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4470', '1790', '3056', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4472', '79', '238', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4477', '3000', '5220', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4479', '1368', '8280', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4480', '675', '1984', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4481', '320', '601', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4482', '716', '1056', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4483', '520', '1848', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4484', '1350', '3582', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4485', '2170', '13440', '30', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4500', '24', '76', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4514', '60', '329', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '4515', '132', '248', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5182', '17382', '9657', '9657', '30', '5', '10');
+INSERT INTO `guild_shops` VALUES ('5182', '17383', '1980', '1980', '30', '10', '20');
+INSERT INTO `guild_shops` VALUES ('5182', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('5182', '17388', '934', '934', '30', '10', '20');
+INSERT INTO `guild_shops` VALUES ('5182', '17399', '2394', '2394', '20', '6', '12');
+
+-- Mep Nhapopoluko (Bibiki Bay) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('519', '624', '24', '39', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('519', '4314', '300', '300', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('519', '4317', '120', '237', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('519', '4318', '3375', '3375', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('519', '4385', '115', '546', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('519', '4399', '1350', '5487', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('519', '4443', '9', '32', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('519', '4484', '1350', '1800', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('519', '4485', '2172', '13882', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('519', '17382', '7081', '8369', '30', '5', '10');
+INSERT INTO `guild_shops` VALUES ('519', '17388', '766', '906', '30', '10', '20');
+
+-- Rajmonda (Ship bound for Selbina) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('520', '624', '47', '158', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4360', '41', '153', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4361', '1216', '1289', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4383', '4251', '5529', '165', '0', '65'); 
+INSERT INTO `guild_shops` VALUES ('520', '4384', '5250', '13930', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('520', '4385', '235', '737', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4399', '1350', '5487', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('520', '4403', '155', '398', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4443', '63', '157', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4451', '3400', '18080', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('520', '4461', '4050', '9828', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('520', '4479', '1368', '8280', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('520', '4480', '375', '2000', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('520', '4481', '320', '601', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4482', '736', '752', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4483', '509', '1812', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4484', '3312', '8784', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('520', '4485', '2100', '12544', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('520', '4500', '24', '126', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '4514', '60', '259', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('520', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('520', '17395', '8', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('520', '17399', '2394', '2394', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('520', '17400', '691', '691', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('520', '17407', '303', '303', '20', '6', '12');
+
+-- Lokhong (Ship bound for Mhaura) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('521', '624', '47', '158', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4360', '41', '153', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4361', '1216', '1289', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4383', '4251', '5529', '165', '0', '65'); 
+INSERT INTO `guild_shops` VALUES ('521', '4384', '5250', '13930', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('521', '4385', '235', '737', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4399', '1350', '5487', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('521', '4403', '155', '398', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4443', '63', '157', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4451', '3400', '18080', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('521', '4461', '4050', '9828', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('521', '4479', '1368', '8280', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('521', '4480', '375', '2000', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('521', '4481', '320', '601', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4482', '736', '752', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4483', '509', '1812', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4484', '3312', '8784', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('521', '4485', '2100', '12544', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('521', '4500', '24', '126', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '4514', '60', '259', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('521', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('521', '17395', '8', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('521', '17399', '2394', '2394', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('521', '17400', '691', '691', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('521', '17407', '303', '303', '20', '6', '12');
+
+-- Cehn Teyohngo (Open sea route to Al Zahbi) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('522', '624', '47', '158', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('522', '4360', '41', '153', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('522', '4399', '5487', '8712', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('522', '4403', '155', '398', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('522', '4461', '4050', '26784', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('522', '4480', '564', '2440', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('522', '4484', '3412', '8928', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('522', '4485', '2100', '12544', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('522', '4500', '24', '126', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('522', '4514', '114', '393', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('522', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('522', '17395', '8', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('522', '17399', '2394', '2394', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('522', '17400', '691', '691', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('522', '17407', '270', '270', '20', '6', '12');
+
+-- Pashi Maccaleh (Open sea route to Mhaura) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('523', '624', '47', '158', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('523', '4360', '41', '153', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('523', '4399', '5487', '8712', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('523', '4403', '155', '398', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('523', '4461', '4050', '26784', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('523', '4480', '564', '2440', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('523', '4484', '3412', '8928', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('523', '4485', '2100', '12544', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('523', '4500', '24', '126', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('523', '4514', '114', '393', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('523', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('523', '17395', '8', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('523', '17399', '2394', '2394', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('523', '17400', '691', '691', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('523', '17407', '270', '270', '20', '6', '12');
+
+-- Jidwahn (Silver Sea route to Nashmau) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('524', '2177', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('524', '2180', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('524', '2182', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('524', '2183', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('524', '4399', '8856', '8928', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('524', '4403', '155', '398', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('524', '4480', '2280', '2480', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('524', '4485', '2100', '12544', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('524', '5140', '75504', '69888', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('524', '5448', '8296', '8432', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('524', '5449', '92', '136', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('524', '5452', '5472', '5904', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('524', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('524', '17395', '8', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('524', '17399', '2394', '2394', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('524', '17400', '691', '691', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('524', '17407', '270', '270', '20', '6', '12');
+
+
+-- Yahliq (Silver Sea route to Al Zahbi) Fishing Guild
+INSERT INTO `guild_shops` VALUES ('525', '2177', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('525', '2180', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('525', '2182', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('525', '2183', '36', '224', '8910', '1782', '3564');
+INSERT INTO `guild_shops` VALUES ('525', '4399', '8856', '8928', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('525', '4403', '155', '398', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('525', '4480', '2280', '2480', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('525', '4485', '2100', '12544', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('525', '5140', '75504', '69888', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('525', '5448', '8296', '8432', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('525', '5449', '92', '136', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('525', '5452', '5472', '5904', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('525', '17387', '4077', '4077', '30', '5', '15');
+INSERT INTO `guild_shops` VALUES ('525', '17395', '8', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('525', '17399', '2394', '2394', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('525', '17400', '691', '691', '20', '6', '12');
+INSERT INTO `guild_shops` VALUES ('525', '17407', '270', '270', '20', '6', '12');
+
+
+-- Odaba (Bastok Mines) Alchemist Guild (S)
+INSERT INTO `guild_shops` VALUES ('526', '621', '21', '40', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('526', '622', '36', '155', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('526', '636', '97', '369', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('526', '637', '1640', '4880', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('526', '638', '138', '851', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('526', '912', '192', '360', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('526', '914', '1125', '6300', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('526', '920', '1084', '5899', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('526', '922', '300', '300', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('526', '925', '1312', '3952', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('526', '928', '1014', '2307', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('526', '929', '1875', '6900', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('526', '931', '19520', '19520', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('526', '932', '1020', '1080', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('526', '933', '664', '3168', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('526', '943', '534', '1177', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('526', '947', '3360', '21862', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('526', '951', '90', '350', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('526', '1108', '573', '3213', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('526', '1109', '930', '4563', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('526', '2131', '75', '242', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('526', '4112', '682', '728', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('526', '4116', '3375', '7560', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('526', '4128', '3624', '17201', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('526', '4148', '1200', '1377', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('526', '4150', '1945', '9549', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('526', '4151', '880', '2944', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('526', '4154', '5250', '13300', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('526', '4162', '5250', '13300', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('526', '4164', '1050', '6832', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('526', '4165', '900', '5712', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('526', '4166', '750', '2080', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('526', '4171', '750', '2080', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('526', '4443', '750', '2080', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('526', '4509', '9', '58', '375', '0', '150');
+-- INSERT INTO `guild_shops` VALUES ('526', '16387', '10902', '33886', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('526', '16403', '102009', '102009', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('526', '16454', '1904', '1904', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('526', '16471', '519', '3024', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('526', '16478', '19148', '19148', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('526', '16495', '9906', '9906', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('526', '16581', '33368', '167872', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('526', '17340', '392', '392', '8910', '0', '3564');
+-- INSERT INTO `guild_shops` VALUES ('526', '17341', '392', '392', '2970', '0', '1188');
+-- INSERT INTO `guild_shops` VALUES ('526', '18228', '114', '114', '2970', '594', '1188');
+-- INSERT INTO `guild_shops` VALUES ('526', '18232', '114', '114', '2970', '594', '1188');
+-- INSERT INTO `guild_shops` VALUES ('526', '18236', '21', '21', '2970', '594', '1188');
+
+-- Maymunah (Bastok Mines) Alchemist Guild (S)
+-- INSERT INTO `guild_shops` VALUES ('5262', '621', '21', '40', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '622', '36', '155', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '636', '97', '369', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '637', '1640', '4880', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5262', '638', '138', '851', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '912', '192', '360', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '914', '1125', '6300', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5262', '920', '1084', '5899', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5262', '922', '300', '300', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '925', '1312', '3952', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5262', '928', '1014', '2307', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5262', '929', '1875', '6900', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5262', '931', '19520', '19520', '15', '3', '6');
+-- INSERT INTO `guild_shops` VALUES ('5262', '932', '1020', '1080', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5262', '933', '664', '3168', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5262', '943', '534', '1177', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '947', '3360', '21862', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5262', '951', '90', '350', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '1108', '573', '3213', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '1109', '930', '4563', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '2131', '75', '242', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4112', '682', '728', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4116', '3375', '7560', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4128', '3624', '17201', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4148', '1200', '1377', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4150', '1945', '9549', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4151', '880', '2944', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4154', '5250', '13300', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4162', '5250', '13300', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5262', '4164', '1050', '6832', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5262', '4165', '900', '5712', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5262', '4166', '750', '2080', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5262', '4171', '750', '2080', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5262', '4443', '750', '2080', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5262', '4509', '9', '58', '375', '0', '150');
+INSERT INTO `guild_shops` VALUES ('5262', '16387', '10902', '33886', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5262', '16403', '102009', '102009', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5262', '16454', '1904', '1904', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5262', '16471', '519', '3024', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5262', '16478', '19148', '19148', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5262', '16495', '9906', '9906', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5262', '16581', '33368', '167872', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5262', '17340', '392', '392', '8910', '0', '3564');
+INSERT INTO `guild_shops` VALUES ('5262', '17341', '392', '392', '2970', '0', '1188');
+INSERT INTO `guild_shops` VALUES ('5262', '18228', '114', '114', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('5262', '18232', '114', '114', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('5262', '18236', '21', '21', '2970', '594', '1188');
+
+-- Teerth (Goldsmith Guild) Bastok Markets (S)
+INSERT INTO `guild_shops` VALUES ('527', '640', '9', '36', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('527', '642', '595', '620', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '644', '1500', '9200', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('527', '653', '19900', '36400', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('527', '661', '1171', '1171', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('527', '663', '20240', '45600', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('527', '673', '210', '1108', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('527', '681', '10500', '30800', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('527', '736', '315', '1260', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('527', '738', '58032', '116245', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('527', '744', '4095', '9996', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('527', '760', '29172', '74880', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('527', '769', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '770', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '771', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '772', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '773', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '774', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '775', '1288', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('527', '776', '1288', '7000', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('527', '784', '23400', '124800', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('527', '785', '106400', '116736', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('527', '786', '45600', '116736', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('527', '787', '106400', '116736', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('527', '788', '12000', '56160', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('527', '789', '106400', '116736', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('527', '790', '9000', '3600', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('527', '791', '23400', '136032', '15', '1', '3');
+INSERT INTO `guild_shops` VALUES ('527', '795', '1396', '2794', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('527', '796', '1396', '2794', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '797', '44304', '49608', '15', '3', '6');
+-- INSERT INTO `guild_shops` VALUES ('527', '799', '1396', '2794', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '800', '1396', '2794', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '801', '23400', '136032', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '802', '23400', '146016', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '803', '23400', '146016', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '804', '106400', '116736', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '805', '23400', '83616', '15', '2', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '806', '1396', '2794', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '807', '1396', '2794', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '808', '9000', '24000', '15', '3', '6');
+-- INSERT INTO `guild_shops` VALUES ('527', '809', '1396', '2794', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '810', '23400', '146016', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '811', '9000', '56160', '15', '0', '6');
+-- INSERT INTO `guild_shops` VALUES ('527', '812', '106400', '116736', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '813', '106400', '116736', '15', '3', '3');
+-- INSERT INTO `guild_shops` VALUES ('527', '814', '1396', '2794', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('527', '815', '9000', '56160', '15', '3', '6');
+-- INSERT INTO `guild_shops` VALUES ('527', '1588', '20400', '20400', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('527', '12425', '17100', '43776', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12433', '18176', '30208', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12449', '1503', '6540', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12472', '153', '214', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('527', '12495', '4398', '4398', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '12496', '117', '234', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('527', '12497', '970', '1190', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12561', '14616', '91203', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12689', '8191', '41216', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12705', '1023', '2620', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12833', '3840', '7360', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12945', '11440', '11440', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '12961', '2380', '3720', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13196', '52284', '52284', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13317', '12800', '12800', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13327', '5850', '5850', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13330', '1238', '1238', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13331', '1522', '1522', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13332', '1186', '1238', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('527', '13333', '1186', '1238', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('527', '13334', '1186', '1238', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('527', '13340', '12880', '12880', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13342', '12250', '12250', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13343', '1775', '5000', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13344', '1987', '5000', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '13454', '72', '179', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('527', '13468', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13470', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13471', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13472', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13473', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13474', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('527', '13979', '20088', '20088', '20', '3', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '16391', '2700', '13989', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '16407', '2399', '13554', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '16449', '3422', '15656', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '16551', '3631', '15487', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '16641', '2870', '13845', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '16769', '2245', '13221', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('527', '17043', '1735', '1839', '20', '0', '10');
+
+-- Visala (Goldsmith Guild) Bastok Markets (S)
+-- INSERT INTO `guild_shops` VALUES ('5272', '640', '9', '36', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5272', '642', '595', '620', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '644', '1500', '9200', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '653', '19900', '36400', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5272', '661', '1171', '1171', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5272', '663', '20240', '45600', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5272', '673', '210', '1108', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5272', '681', '10500', '30800', '30', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('5272', '736', '315', '1260', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5272', '738', '58032', '116245', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5272', '744', '4095', '9996', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5272', '760', '29172', '74880', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5272', '769', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '770', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '771', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '772', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '773', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '774', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '775', '1288', '7000', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '776', '1288', '7000', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5272', '784', '23400', '124800', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5272', '785', '106400', '116736', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5272', '786', '45600', '116736', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5272', '787', '106400', '116736', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5272', '788', '12000', '56160', '15', '0', '6');
+-- INSERT INTO `guild_shops` VALUES ('5272', '789', '106400', '116736', '15', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5272', '790', '9000', '3600', '15', '0', '6');
+-- INSERT INTO `guild_shops` VALUES ('5272', '791', '23400', '136032', '15', '1', '3');
+-- INSERT INTO `guild_shops` VALUES ('5272', '795', '1396', '2794', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5272', '796', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '797', '44304', '49608', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('5272', '799', '1396', '2794', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '800', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '801', '23400', '136032', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '802', '23400', '146016', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '803', '23400', '146016', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '804', '106400', '116736', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '805', '23400', '83616', '15', '2', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '806', '1396', '2794', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '807', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '808', '9000', '24000', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('5272', '809', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '810', '23400', '146016', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '811', '9000', '56160', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('5272', '812', '106400', '116736', '15', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '813', '106400', '116736', '15', '3', '3');
+INSERT INTO `guild_shops` VALUES ('5272', '814', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('5272', '815', '9000', '56160', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('5272', '1588', '20400', '20400', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('5272', '12425', '17100', '43776', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12433', '18176', '30208', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12449', '1503', '6540', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12472', '153', '214', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5272', '12495', '4398', '4398', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5272', '12496', '117', '234', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5272', '12497', '970', '1190', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12561', '14616', '91203', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12689', '8191', '41216', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12705', '1023', '2620', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5272', '12833', '3840', '7360', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '12945', '11440', '11440', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '12961', '2380', '3720', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13196', '52284', '52284', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13317', '12800', '12800', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13327', '5850', '5850', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13330', '1238', '1238', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13331', '1522', '1522', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13332', '1186', '1238', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13333', '1186', '1238', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13334', '1186', '1238', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13340', '12880', '12880', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13342', '12250', '12250', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13343', '1775', '5000', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13344', '1987', '5000', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13454', '72', '179', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13468', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13470', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13471', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13472', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13473', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13474', '1875', '2400', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5272', '13979', '20088', '20088', '20', '3', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '16391', '2700', '13989', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '16407', '2399', '13554', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '16449', '3422', '15656', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '16551', '3631', '15487', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '16641', '2870', '13845', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '16769', '2245', '13221', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5272', '17043', '1735', '1839', '20', '0', '10');
+
+-- Yabby Tanmikey / Celestina (Goldsmith Guild) Mhaura (S)
+INSERT INTO `guild_shops` VALUES ('528', '640', '9', '20', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('528', '736', '315', '1831', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('528', '769', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '770', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '771', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '772', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '773', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '774', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '775', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '776', '1288', '6440', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('528', '2143', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('528', '2144', '75', '75', '255', '48', '100');
+
+-- Kueh Igunahmori (Leathercraft Guild) Southern San d'Oria (S)
+INSERT INTO `guild_shops` VALUES ('529', '505', '62', '349', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('529', '506', '7490', '38301', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('529', '695', '120', '184', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('529', '832', '675', '4500', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('529', '848', '2912', '4636', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('529', '850', '390', '390', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('529', '851', '2718', '7139', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('529', '852', '630', '640', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('529', '853', '2155', '12875', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('529', '854', '2650', '3304', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('529', '855', '9077', '10874', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('529', '856', '45', '276', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('529', '857', '1290', '1990', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('529', '858', '483', '1161', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('529', '859', '937', '4750', '80', '33', '32');
+INSERT INTO `guild_shops` VALUES ('529', '861', '1312', '8050', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('529', '863', '2700', '11088', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('529', '917', '481', '963', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('529', '1116', '15504', '27360', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('529', '1117', '8385', '22024', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('529', '2129', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('529', '4509', '9', '23', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('529', '12294', '25920', '68083', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('529', '12440', '330', '1091', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('529', '12441', '3318', '8407', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('529', '12442', '20056', '28222', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('529', '12443', '16380', '43024', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('529', '12444', '88704', '97081', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('529', '12568', '987', '1323', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '12569', '5145', '16189', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '12570', '44232', '44916', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '12571', '32340', '84946', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12572', '44460', '116781', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12696', '318', '1612', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '12697', '2700', '7092', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '12698', '11610', '53625', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '12699', '17052', '44789', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12700', '29700', '150480', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12724', '589', '1055', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '12825', '5819', '10714', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '12826', '32002', '36232', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '12827', '25200', '66192', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12828', '42900', '112684', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12952', '504', '1639', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '12953', '2578', '16777', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '12955', '15624', '41039', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12956', '58027', '72811', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '12992', '453', '1815', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '12993', '3366', '8841', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '12994', '11481', '28273', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '12995', '48960', '76296', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '13081', '211', '1003', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '13089', '6384', '15662', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '13192', '837', '1224', '20', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '13193', '4590', '12420', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '13194', '16896', '20803', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '13195', '2277', '5980', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '13200', '13860', '35112', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '13203', '2277', '5980', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '13469', '937', '2087', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '13570', '10800', '25488', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '13571', '6426', '31530', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '13588', '2484', '14440', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('529', '13592', '2065', '9804', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '13593', '24000', '62080', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('529', '13594', '132', '316', '20', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '13703', '44100', '108192', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('529', '16385', '279', '283', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('529', '16386', '945', '5997', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('529', '16388', '11970', '27700', '20', '0', '5');
+
+-- Cletae (Leathercraft Guild) Southern San d'Oria (S)
+-- INSERT INTO `guild_shops` VALUES ('5292', '505', '62', '349', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '506', '7490', '38301', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5292', '695', '120', '184', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '832', '675', '4500', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5292', '848', '2912', '4636', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5292', '850', '390', '390', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5292', '851', '2718', '7139', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5292', '852', '630', '640', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '853', '2155', '12875', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5292', '854', '2650', '3304', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5292', '854', '2650', '3304', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5292', '855', '9077', '10874', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5292', '856', '45', '276', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '857', '1290', '1990', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '858', '483', '1161', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5292', '859', '937', '4750', '80', '33', '32');
+-- INSERT INTO `guild_shops` VALUES ('5292', '861', '1312', '8050', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5292', '863', '2700', '11088', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5292', '917', '481', '963', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '1116', '15504', '27360', '30', '6', '12');
+-- INSERT INTO `guild_shops` VALUES ('5292', '1117', '8385', '22024', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5292', '2129', '75', '75', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5292', '4509', '9', '23', '375', '75', '150');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12294', '25920', '68083', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12440', '330', '1091', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12441', '3318', '8407', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12442', '20056', '28222', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12443', '16380', '43024', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12444', '88704', '97081', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5292', '12568', '987', '1323', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '12569', '5145', '16189', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '12570', '44232', '44916', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5292', '12571', '32340', '84946', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12572', '44460', '116781', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12696', '318', '1612', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '12697', '2700', '7092', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '12698', '11610', '53625', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5292', '12699', '17052', '44789', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12700', '29700', '150480', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12724', '589', '1055', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '12825', '5819', '10714', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '12826', '32002', '36232', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5292', '12827', '25200', '66192', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12828', '42900', '112684', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12952', '504', '1639', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '12953', '2578', '16777', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '12955', '15624', '41039', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12956', '58027', '72811', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '12992', '453', '1815', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '12993', '3366', '8841', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '12994', '11481', '28273', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5292', '12995', '48960', '76296', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '13081', '211', '1003', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '13089', '6384', '15662', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '13192', '837', '1224', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('5292', '13193', '4590', '12420', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5292', '13194', '16896', '20803', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('5292', '13195', '2277', '5980', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5292', '13200', '13860', '35112', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5292', '13203', '2277', '5980', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13469', '937', '2087', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13570', '10800', '25488', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13571', '6426', '31530', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13588', '2484', '14440', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13592', '2065', '9804', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13593', '24000', '62080', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13594', '132', '316', '20', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('5292', '13703', '44100', '108192', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('5292', '16385', '279', '283', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5292', '16386', '945', '5997', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5292', '16388', '11970', '27700', '20', '0', '5');
+
+-- Kopopo (Windurst Waters) Cooking Guild (S)       
+INSERT INTO `guild_shops` VALUES ('530', '610', '45', '144', '255', '48', '100');    
+INSERT INTO `guild_shops` VALUES ('530', '611', '30', '60', '255', '48', '100');    
+INSERT INTO `guild_shops` VALUES ('530', '612', '45', '114', '255', '48', '100');    
+INSERT INTO `guild_shops` VALUES ('530', '614', '60', '152', '255', '48', '100'); 
+INSERT INTO `guild_shops` VALUES ('530', '615', '45', '119', '255', '0', '100'); 
+INSERT INTO `guild_shops` VALUES ('530', '616', '60', '368', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '618', '21', '42', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '620', '45', '276', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '621', '21', '40', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '622', '36', '94', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '625', '66', '221', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '627', '40', '80', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '628', '195', '494', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '629', '36', '144', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '636', '30', '57', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '1111', '450', '2832', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '1554', '431', '754', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '1555', '1061', '1854', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '1590', '536', '992', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '1840', '1500', '2800', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '2110', '457', '530', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '2111', '525', '530', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '2112', '530', '540', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('530', '4156', '3872', '3936', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('530', '4356', '154', '992', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('530', '4358', '61', '64', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '4359', '180', '475', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '4360', '114', '160', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '4362', '117', '120', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('530', '4363', '33', '183', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4364', '102', '427', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4365', '192', '600', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4366', '18', '100', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4367', '36', '124', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4370', '163', '590', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4371', '252', '743', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4372', '83', '230', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4376', '90', '288', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4378', '45', '268', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4380', '437', '1091', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4381', '1382', '3600', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4382', '58', '64', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4383', '3906', '5760', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4387', '709', '1934', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4389', '43', '153', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4390', '51', '198', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4392', '45', '149', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4394', '9', '55', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4398', '2149', '3256', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4399', '2592', '2700', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4406', '734', '1988', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4408', '105', '250', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4409', '132', '211', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4410', '626', '1962', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4412', '412', '1118', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4413', '240', '1420', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4415', '93', '565', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4416', '2716', '6944', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4417', '2475', '15972', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4419', '12390', '14000', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4420', '13124', '13230', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4422', '150', '328', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4423', '225', '720', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4424', '825', '4488', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4425', '240', '1113', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4431', '72', '376', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4432', '87', '192', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4435', '3520', '3968', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4436', '240', '1113', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4437', '240', '1113', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4438', '2750', '7084', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4441', '753', '3720', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4442', '300', '1504', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4444', '18', '45', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4445', '41', '88', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4455', '968', '984', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4456', '2452', '10620', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4457', '4800', '13920', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4468', '60', '208', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4482', '1408', '1984', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4490', '955', '2284', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4491', '150', '696', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4492', '1182', '2845', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4499', '75', '320', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4537', '967', '2600', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4538', '1628', '4232', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('530', '4556', '10644', '10644', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4560', '2861', '2861', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('530', '4563', '6113', '15360', '15', '0', '6');
+-- INSERT INTO `guild_shops` VALUES ('530', '4570', '47', '245', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4571', '75', '460', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('530', '4572', '1360', '7260', '55', '11', '22');
+
+-- Chomo Jinjahl (Windurst Waters) Cooking Guild (S)  
+-- INSERT INTO `guild_shops` VALUES ('5302', '610', '45', '144', '255', '48', '100');    
+-- INSERT INTO `guild_shops` VALUES ('5302', '611', '30', '60', '255', '48', '100');    
+-- INSERT INTO `guild_shops` VALUES ('5302', '612', '45', '114', '255', '48', '100');    
+-- INSERT INTO `guild_shops` VALUES ('5302', '614', '60', '152', '255', '48', '100'); 
+-- INSERT INTO `guild_shops` VALUES ('5302', '615', '45', '119', '255', '0', '100'); 
+-- INSERT INTO `guild_shops` VALUES ('5302', '616', '60', '368', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '618', '21', '42', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '620', '45', '276', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '621', '21', '40', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '622', '36', '94', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '625', '66', '221', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '627', '40', '80', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '628', '195', '494', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '629', '36', '144', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '636', '30', '57', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '1111', '450', '2832', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '1554', '431', '754', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '1555', '1061', '1854', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '1590', '536', '992', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '1840', '1500', '2800', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '2110', '457', '530', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '2111', '525', '530', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '2112', '530', '540', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4156', '3872', '3936', '55', '0', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4356', '154', '992', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4358', '61', '64', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4359', '180', '475', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4360', '114', '160', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4362', '117', '120', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4363', '33', '183', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4364', '102', '427', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4365', '192', '600', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4366', '18', '100', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4367', '36', '124', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4370', '163', '590', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4371', '252', '743', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('5302', '4372', '83', '230', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4376', '90', '288', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4378', '45', '268', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4380', '437', '1091', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4381', '1382', '3600', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4382', '58', '64', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4383', '3906', '5760', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4387', '709', '1934', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4389', '43', '153', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4390', '51', '198', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4392', '45', '149', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4394', '9', '55', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4398', '2149', '3256', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4399', '2592', '2700', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4406', '734', '1988', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4408', '105', '250', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4409', '132', '211', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4410', '626', '1962', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4412', '412', '1118', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4413', '240', '1420', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4415', '93', '565', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4416', '2716', '6944', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4417', '2475', '15972', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4419', '12390', '14000', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4420', '13124', '13230', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4422', '150', '328', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4423', '225', '720', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4424', '825', '4488', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4425', '240', '1113', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('5302', '4431', '72', '376', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4432', '87', '192', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4435', '3520', '3968', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4436', '240', '1113', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4437', '240', '1113', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('5302', '4438', '2750', '7084', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4441', '753', '3720', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4442', '300', '1504', '55', '11', '22');
+INSERT INTO `guild_shops` VALUES ('5302', '4444', '18', '45', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4445', '41', '88', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4455', '968', '984', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4456', '2452', '10620', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4457', '4800', '13920', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4468', '60', '208', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4482', '1408', '1984', '255', '0', '100');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4490', '955', '2284', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4491', '150', '696', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4492', '1182', '2845', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4499', '75', '320', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4537', '967', '2600', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4538', '1628', '4232', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('5302', '4556', '10644', '10644', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4560', '2861', '2861', '55', '11', '22');
+-- INSERT INTO `guild_shops` VALUES ('5302', '4563', '6113', '15360', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('5302', '4570', '47', '245', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4571', '75', '460', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('5302', '4572', '1360', '7260', '55', '11', '22');
+
+-- Doggomehr (Northern San d'Oria) Smithing Guild (S)
+INSERT INTO `guild_shops` VALUES ('531', '640', '9', '36', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('531', '641', '30', '66', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('531', '643', '675', '981', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('531', '649', '115', '349', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('531', '651', '2700', '10800', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('531', '652', '25620', '25620', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('531', '660', '69', '294', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('531', '662', '4050', '9898', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('531', '666', '14868', '39984', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('531', '672', '81', '254', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('531', '676', '13720', '13720', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('531', '680', '11781', '11781', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('531', '1155', '2400', '2400', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('531', '2143', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('531', '2144', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('531', '12424', '7695', '26676', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('531', '12432', '2711', '2856', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('531', '12688', '1666', '5664', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('531', '12944', '1519', '5294', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('531', '13783', '81084', '162345', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('531', '13871', '27216', '47355', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('531', '13873', '61107', '70963', '20', '3', '5');
+INSERT INTO `guild_shops` VALUES ('531', '14001', '42476', '88529', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('531', '14003', '79745', '84198', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('531', '14245', '52785', '166096', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('531', '16412', '56544', '56544', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('531', '16448', '240', '761', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('531', '16532', '36503', '36503', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('531', '16535', '509', '1056', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('531', '16537', '25800', '32680', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('531', '16565', '1395', '8853', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('531', '16589', '10444', '67958', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('531', '16650', '18270', '36987', '20', '5', '10');
+-- INSERT INTO `guild_shops` VALUES ('531', '16651', '66555', '168606', '20', '2', '5');
+-- INSERT INTO `guild_shops` VALUES ('531', '16768', '643', '677', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('531', '16770', '16803', '24703', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('531', '17034', '313', '917', '20', '0', '15');
+
+
+
+-- Lucretia (Northern San d'Oria) Smithing Guild (S)
+-- INSERT INTO `guild_shops` VALUES ('5312', '640', '9', '36', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5312', '641', '30', '66', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5312', '643', '675', '981', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '649', '115', '349', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '651', '2700', '10800', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '652', '25620', '25620', '80', '16', '32');
+-- INSERT INTO `guild_shops` VALUES ('5312', '660', '69', '294', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '662', '4050', '9898', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '666', '14868', '39984', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '672', '81', '254', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '676', '13720', '13720', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5312', '680', '11781', '11781', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5312', '1155', '2400', '2400', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5312', '2143', '75', '75', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5312', '2144', '75', '75', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5312', '12424', '7695', '26676', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5312', '12432', '2711', '2856', '20', '10', '20');
+-- INSERT INTO `guild_shops` VALUES ('5312', '12688', '1666', '5664', '20', '7', '15');
+-- INSERT INTO `guild_shops` VALUES ('5312', '12944', '1519', '5294', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5312', '13783', '81084', '162345', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5312', '13871', '27216', '47355', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5312', '13873', '61107', '70963', '20', '3', '5');
+-- INSERT INTO `guild_shops` VALUES ('5312', '14001', '42476', '88529', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5312', '14003', '79745', '84198', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5312', '14245', '52785', '166096', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5312', '16412', '56544', '56544', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5312', '16448', '240', '761', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5312', '16532', '36503', '36503', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5312', '16535', '509', '1056', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5312', '16537', '25800', '32680', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5312', '16565', '1395', '8853', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5312', '16589', '10444', '67958', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5312', '16650', '18270', '36987', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('5312', '16651', '66555', '168606', '20', '2', '5');
+INSERT INTO `guild_shops` VALUES ('5312', '16768', '643', '677', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5312', '16770', '16803', '24703', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5312', '17034', '313', '917', '20', '0', '15');
+
+-- Mololo / Kamilah (Mhaura) Smithing Guild (S)
+INSERT INTO `guild_shops` VALUES ('532', '640', '9', '20', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('532', '641', '30', '66', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('532', '643', '675', '1224', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('532', '652', '3517', '22890', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('532', '660', '61', '423', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('532', '672', '72', '209', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('532', '680', '12411', '12400', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('532', '12706', '21945', '21945', '20', '0', '15');
+
+-- Vicious Eye (Metalworks) Smithing Guild (S)
+INSERT INTO `guild_shops` VALUES ('533', '640', '9', '44', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('533', '641', '30', '66', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('533', '643', '675', '1656', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('533', '644', '2000', '10000', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('533', '649', '103', '349', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('533', '651', '2700', '4680', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('533', '660', '69', '294', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('533', '662', '4050', '7020', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('533', '664', '66690', '66690', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('533', '672', '81', '106', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('533', '674', '4945', '12411', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('533', '676', '7350', '11466', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('533', '680', '4725', '11592', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('533', '2143', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('533', '2144', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('533', '12299', '708', '2835', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('533', '12450', '15300', '15300', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('533', '12544', '36855', '83538', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('533', '12578', '61086', '81086', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('533', '12672', '19440', '23328', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('533', '12704', '191', '394', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('533', '12706', '12960', '12960', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('533', '12800', '34020', '69552', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('533', '12832', '409', '818', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('533', '12836', '19008', '38565', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('533', '12928', '34927', '45144', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('533', '12962', '27866', '76830', '20', '0', '5');
+INSERT INTO `guild_shops` VALUES ('533', '13080', '13770', '14412', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('533', '16406', '10713', '17020', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('533', '16465', '229', '754', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('533', '16467', '22422', '22422', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('533', '16552', '8914', '8914', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('533', '16558', '10200', '81600', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('533', '16640', '622', '2898', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('533', '16657', '95040', '314160', '20', '0', '3');
+-- INSERT INTO `guild_shops` VALUES ('533', '16704', '1323', '3565', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('533', '16706', '30912', '90783', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('533', '17045', '11970', '29366', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('533', '17298', '598', '620', '2970', '0', '1188');
+-- INSERT INTO `guild_shops` VALUES ('533', '17336', '4', '11', '2970', '0', '1188');
+
+-- Amulya (Metalworks) Smithing Guild (S)
+-- INSERT INTO `guild_shops` VALUES ('5332', '640', '9', '44', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5332', '641', '30', '66', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5332', '643', '675', '1656', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '644', '2000', '10000', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '649', '103', '349', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '651', '2700', '4680', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '660', '69', '294', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '662', '4050', '7020', '165', '33', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '664', '66690', '66690', '30', '0', '12');
+-- INSERT INTO `guild_shops` VALUES ('5332', '672', '81', '106', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '674', '4945', '12411', '165', '0', '65');
+-- INSERT INTO `guild_shops` VALUES ('5332', '676', '7350', '11466', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5332', '680', '4725', '11592', '80', '0', '32');
+-- INSERT INTO `guild_shops` VALUES ('5332', '2143', '75', '75', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5332', '2144', '75', '75', '255', '48', '100');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12299', '708', '2835', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12450', '15300', '15300', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12544', '36855', '83538', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12578', '61086', '81086', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12672', '19440', '23328', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12704', '191', '394', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12706', '12960', '12960', '20', '0', '15');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12800', '34020', '69552', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12832', '409', '818', '20', '0', '20');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12836', '19008', '38565', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12928', '34927', '45144', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5332', '12962', '27866', '76830', '20', '0', '5');
+-- INSERT INTO `guild_shops` VALUES ('5332', '13080', '13770', '14412', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5332', '16406', '10713', '17020', '20', '0', '10');
+-- INSERT INTO `guild_shops` VALUES ('5332', '16465', '229', '754', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5332', '16467', '22422', '22422', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5332', '16552', '8914', '8914', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('5332', '16558', '10200', '81600', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5332', '16640', '622', '2898', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('5332', '16657', '95040', '314160', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('5332', '16704', '1323', '3565', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5332', '16706', '30912', '90783', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5332', '17045', '11970', '29366', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('5332', '17298', '598', '620', '2970', '0', '1188');
+INSERT INTO `guild_shops` VALUES ('5332', '17336', '4', '11', '2970', '0', '1188');
+
+-- Beugungel (Carpenter's Landing) Woodworking Guild
+INSERT INTO `guild_shops` VALUES ('534', '688', '12', '30', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('534', '693', '640', '1622', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('534', '695', '120', '184', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('534', '696', '330', '686', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('534', '698', '60', '182', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('534', '1021', '312', '500', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('534', '1657', '75', '255', '255', '48', '100');
+
+-- Amalasanda (Lower Jeuno) Tenshodo Merchent
+INSERT INTO `guild_shops` VALUES ('60416', '704', '96', '149', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '829', '35070', '77280', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60416', '626', '229', '280', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1240', '165', '210', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60416', '657', '4690', '21000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60416', '1415', '55147', '55147', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60416', '4928', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60416', '4934', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60416', '4937', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60416', '4943', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60416', '1471', '316', '316', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1554', '431', '512', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1555', '1061', '1259', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1590', '536', '700', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1475', '579', '1188', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '5164', '1945', '2854', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1652', '150', '160', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60416', '1161', '66', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60416', '1170', '58', '107', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60416', '1176', '44', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60416', '5237', '369', '369', '255', '48', '100');
+
+
+-- Akamafula (Lower Jeuno) Tenshodo Merchent
+INSERT INTO `guild_shops` VALUES ('60417', '16896', '517', '592', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '16900', '1404', '1608', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60417', '16960', '3121', '3575', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '16974', '224510', '224510', '20', '1', '3');
+INSERT INTO `guild_shops` VALUES ('60417', '16975', '11583', '13266', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '16966', '1836', '2103', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '16982', '4752', '15760', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '16987', '12253', '14033', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '17265', '25732', '25372', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '17301', '29', '87', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60417', '12456', '552', '858', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '12457', '3272', '5079', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60417', '12458', '8972', '13927', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '13111', '20061', '29942', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '12584', '833', '1294', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '12585', '4931', '7654', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60417', '12586', '13266', '14850', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '12712', '458', '712', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '12713', '2713', '4212', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60417', '12714', '2713', '8316', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '12840', '666', '1034', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '12841', '2713', '6133', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60417', '12842', '10805', '12096', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60417', '12968', '424', '660', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60417', '12969', '2528', '3924', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60417', '12970', '11071', '12393', '20', '5', '10');
+
+-- Blabbivix (Port Bastok) / Gaudylox (Northern San d'Oria) / Scavnix (Windurst Walls) (Chip Vendors pseudo guild shop)
+INSERT INTO `guild_shops` VALUES ('60418', '474', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '475', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '476', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '477', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '478', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '479', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '480', '21000', '21000', '255', '255', '255');
+INSERT INTO `guild_shops` VALUES ('60418', '481', '21000', '21000', '255', '255', '255');
+
+-- Jabbar (Port Bastok) Tenshodo Merchant
+INSERT INTO `guild_shops` VALUES ('60419', '704', '96', '149', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '657', '4690', '21000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60419', '4928', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '4934', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '4937', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '4943', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '4878', '37800', '41370', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '4879', '14070', '15750', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '4880', '14070', '15750', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60419', '1554', '431', '512', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '1555', '1061', '1259', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '1590', '536', '700', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '1475', '579', '1188', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '4876', '39270', '41370', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('60419', '4877', '39270', '41370', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('60419', '1164', '30', '120', '2970', '0', '1188');
+INSERT INTO `guild_shops` VALUES ('60419', '4874', '39270', '41370', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('60419', '5164', '1945', '2854', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '1652', '150', '160', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60419', '5236', '198', '224', '255', '48', '100');
+
+-- Silver Owl (Port Bastok) Tenshodo Merchant
+INSERT INTO `guild_shops` VALUES ('60420', '16896', '517', '592', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '16919', '2728', '3125', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60420', '16975', '11583', '13266', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60420', '16988', '14676', '16808', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60420', '12456', '552', '858', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '12457', '3272', '5079', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60420', '13111', '20061', '29942', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60420', '13088', '43890', '52440', '20', '1', '3');
+INSERT INTO `guild_shops` VALUES ('60420', '12584', '833', '1294', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '12585', '4931', '7654', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60420', '12712', '458', '712', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '12713', '2713', '4212', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60420', '12840', '666', '1034', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '12968', '424', '660', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '12969', '2528', '3924', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60420', '16405', '104', '225', '20', '0', '20');
+INSERT INTO `guild_shops` VALUES ('60420', '17314', '7333', '7446', '15', '0', '6');
+
+-- Achika (Norg) Tenshodo Merchant
+INSERT INTO `guild_shops` VALUES ('60421', '12456', '552', '858', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60421', '12457', '3272', '5079', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60421', '12458', '8972', '13927', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60421', '13111', '20061', '29942', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60421', '13088', '43890', '52440', '20', '1', '3');
+INSERT INTO `guild_shops` VALUES ('60421', '12584', '833', '1294', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60421', '12585', '4931', '7654', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60421', '12586', '13266', '14850', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60421', '12712', '458', '712', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60421', '12713', '2713', '4212', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60421', '12714', '2713', '8316', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60421', '12840', '666', '1034', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60421', '12841', '3951', '6133', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60421', '12842', '10805', '12096', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60421', '12968', '424', '660', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60421', '12969', '2528', '3924', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60421', '12970', '11071', '12393', '20', '5', '10');
+
+-- Chiyo (Norg) Tenshodo Merchant
+INSERT INTO `guild_shops` VALUES ('60422', '4876', '39270', '41370', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('60422', '4879', '14070', '15750', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4880', '14070', '15750', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4928', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4931', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4934', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4937', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4940', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4943', '1561', '1747', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60422', '4877', '39270', '41370', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('60422', '4878', '37800', '41370', '30', '6', '12');
+
+
+-- Jirokichi (Norg) Tenshodo Merchant
+INSERT INTO `guild_shops` VALUES ('60423', '16406', '14428', '34214', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '16411', '11746', '21322', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '16419', '45760', '76416', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '16896', '517', '592', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60423', '16917', '4226', '4226', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60423', '16900', '1404', '1608', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60423', '16919', '2728', '3125', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60423', '16960', '3121', '3575', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60423', '16975', '11583', '13266', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '16966', '1836', '2103', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60423', '16982', '4752', '15760', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '16987', '12253', '14033', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '16988', '14676', '16808', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '17802', '189945', '464059', '20', '2', '3');
+INSERT INTO `guild_shops` VALUES ('60423', '16871', '183516', '404395', '20', '2', '3');
+INSERT INTO `guild_shops` VALUES ('60423', '17259', '72144', '158976', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60423', '17301', '29', '87', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60423', '17302', '347', '993', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60423', '17303', '7333', '10120', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60423', '17285', '101745', '101745', '20', '1', '5');
+INSERT INTO `guild_shops` VALUES ('60423', '17314', '7333', '7446', '15', '3', '6');
+INSERT INTO `guild_shops` VALUES ('60423', '17320', '7', '10', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60423', '17322', '81', '187', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60423', '17340', '58', '436', '2970', '594', '1188');
+
+-- Vuliaie (Norg) Tenshodo Merchant
+INSERT INTO `guild_shops` VALUES ('60424', '704', '96', '149', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('60424', '915', '2700', '16120', '165', '33', '165');
+INSERT INTO `guild_shops` VALUES ('60424', '1134', '810', '2095', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '1155', '436', '645', '165', '33', '165');
+INSERT INTO `guild_shops` VALUES ('60424', '657', '4690', '21000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60424', '1415', '55147', '55147', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60424', '1161', '66', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60424', '1164', '30', '120', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60424', '1167', '58', '107', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60424', '1170', '58', '107', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60424', '1173', '56', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60424', '1176', '44', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60424', '1472', '369', '369', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '1554', '431', '512', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '1555', '1061', '1259', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '1590', '536', '700', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '1475', '579', '1188', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '5164', '1945', '2854', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '1652', '150', '160', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60424', '5235', '187', '200', '255', '48', '100');
+
+-- Wahraga (Alchemy Guild) Aht Urhgan Whitegate
+INSERT INTO `guild_shops` VALUES ('60425', '621', '21', '50', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '622', '37', '86', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '636', '106', '234', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '638', '138', '156', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '914', '1125', '4140', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60425', '920', '1084', '6651', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60425', '933', '660', '3392', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60425', '951', '90', '216', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '1108', '573', '826', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '2131', '75', '242', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '2175', '644', '644', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60425', '2229', '1080', '3744', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60425', '2309', '963', '963', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60425', '2316', '9', '9', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '4443', '76', '147', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60425', '4509', '40', '55', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('60425', '17041', '147655', '147655', '20', '0', '3');
+INSERT INTO `guild_shops` VALUES ('60425', '18228', '114', '114', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60425', '18232', '114', '114', '2970', '594', '1188'); 
+INSERT INTO `guild_shops` VALUES ('60425', '18236', '21', '21', '2970', '594', '1188');   
+
+-- Wahnid (Fishing Guild) Aht Urhgan Whitegate
+INSERT INTO `guild_shops` VALUES ('60426', '2216', '615', '615', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '4426', '364', '728', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '4428', '192', '272', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '4451', '3540', '16000', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('60426', '4470', '4369', '4369', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('60426', '4471', '12544', '12544', '55', '0', '22');
+INSERT INTO `guild_shops` VALUES ('60426', '4472', '30', '48', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '4477', '8000', '8000', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('60426', '4485', '10080', '13328', '30', '0', '12');
+INSERT INTO `guild_shops` VALUES ('60426', '5134', '89700', '89700', '6', '0', '2');
+INSERT INTO `guild_shops` VALUES ('60426', '5140', '74256', '74256', '6', '0', '2');
+INSERT INTO `guild_shops` VALUES ('60426', '5141', '7992', '7992', '15', '0', '6');
+INSERT INTO `guild_shops` VALUES ('60426', '5447', '21', '128', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '5448', '2652', '7072', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('60426', '5449', '21', '21', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '5453', '4560', '5952', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60426', '5454', '5130', '25920', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60426', '5456', '1503', '1503', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('60426', '5458', '900', '900', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '5459', '1350', '1350', '255', '0', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '5460', '3487', '11532', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('60426', '16992', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '16993', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '16994', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '16996', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '16997', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '16998', '30', '184', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '16999', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '17000', '52', '254', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60426', '17380', '25740', '25740', '30', '5', '5');    
+INSERT INTO `guild_shops` VALUES ('60426', '17382', '9657', '9657', '30', '5', '10');     
+INSERT INTO `guild_shops` VALUES ('60426', '17383', '1980', '1980', '30', '10', '20');    
+INSERT INTO `guild_shops` VALUES ('60426', '17387', '4077', '4077', '30', '5', '15');     
+INSERT INTO `guild_shops` VALUES ('60426', '17388', '934', '934', '30', '10', '20');      
+INSERT INTO `guild_shops` VALUES ('60426', '17389', '332', '332', '30', '10', '20');      
+INSERT INTO `guild_shops` VALUES ('60426', '17390', '145', '145', '30', '10', '20');      
+INSERT INTO `guild_shops` VALUES ('60426', '17391', '44', '44', '30', '10', '20');        
+INSERT INTO `guild_shops` VALUES ('60426', '17392', '213', '283', '255', '48', '100');    
+INSERT INTO `guild_shops` VALUES ('60426', '17393', '213', '283', '255', '48', '100');    
+INSERT INTO `guild_shops` VALUES ('60426', '17394', '220', '300', '255', '48', '100');    
+INSERT INTO `guild_shops` VALUES ('60426', '17395', '8', '9', '255', '48', '100');        
+INSERT INTO `guild_shops` VALUES ('60426', '17396', '3', '8', '255', '48', '100');        
+INSERT INTO `guild_shops` VALUES ('60426', '17399', '2394', '2394', '20', '6', '12');     
+INSERT INTO `guild_shops` VALUES ('60426', '17404', '540', '540', '20', '6', '12');       
+INSERT INTO `guild_shops` VALUES ('60426', '17405', '540', '540', '20', '6', '12');       
+INSERT INTO `guild_shops` VALUES ('60426', '17407', '303', '303', '20', '6', '12');       
+
+-- Ndego (Smithing Guild) Al Zahbi
+INSERT INTO `guild_shops` VALUES ('60427', '640', '9', '36', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60427', '641', '30', '43', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60427', '643', '675', '2700', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60427', '649', '288', '349', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60427', '651', '2700', '3060', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60427', '660', '69', '294', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60427', '662', '4050', '9898', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60427', '2143', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60427', '2144', '75', '75', '255', '48', '100');
+
+-- Dehbi Moshal (Woodworking Guild) Al Zahbi
+INSERT INTO `guild_shops` VALUES ('60428', '23', '829', '2035', '20', '0', '15');
+INSERT INTO `guild_shops` VALUES ('60428', '688', '15', '30', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '689', '27', '59', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '690', '1401', '10295', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '691', '45', '192', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '693', '640', '2459', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '694', '2119', '4182', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '695', '120', '184', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '696', '330', '686', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '697', '528', '930', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '698', '72', '86', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '699', '4740', '29072', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '700', '9075', '10103', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '701', '6615', '18345', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '702', '9600', '45568', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '704', '108', '248', '375', '100', '150');
+INSERT INTO `guild_shops` VALUES ('60428', '705', '7', '18', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '706', '27', '97', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '707', '1723', '1838', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '708', '45', '276', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '710', '2119', '2543', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '712', '120', '256', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '713', '330', '426', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '714', '607', '2559', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '715', '72', '215', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '716', '4740', '26544', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60428', '721', '704', '2465', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60428', '17318', '6', '13', '8910', '0', '3564');
+INSERT INTO `guild_shops` VALUES ('60428', '17320', '21', '26', '5940', '0', '2376');
+INSERT INTO `guild_shops` VALUES ('60428', '17321', '48', '60', '2970', '0', '1188');
+
+-- Bornahn (Goldsmithing Guild) Al Zahbi
+INSERT INTO `guild_shops` VALUES ('60429', '640', '9', '36', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60429', '644', '1500', '9200', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '673', '436', '1308', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60429', '681', '10500', '66640', '30', '6', '12');
+INSERT INTO `guild_shops` VALUES ('60429', '736', '315', '1260', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60429', '769', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '770', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '771', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '772', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '773', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '774', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '775', '6328', '7000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '776', '6328', '7000', '165', '0', '65');
+INSERT INTO `guild_shops` VALUES ('60429', '795', '1396', '2794', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '796', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '799', '1396', '2794', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '800', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '806', '1396', '2794', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '807', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '809', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '814', '1396', '2794', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60429', '2144', '75', '75', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60429', '13446', '21060', '21060', '20', '0', '10');
+
+-- Taten-Bilten (Clothcraft Guild) Al Zahbi
+INSERT INTO `guild_shops` VALUES ('60430', '2149', '815', '989', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60430', '825', '480', '640', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60430', '818', '159', '768', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '839', '173', '870', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '835', '187', '1000', '375', '75', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '823', '18240', '95760', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60430', '824', '240', '1344', '80', '16', '32');
+INSERT INTO `guild_shops` VALUES ('60430', '817', '45', '240', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '878', '2700', '17280', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60430', '819', '750', '790', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '833', '15', '18', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('60430', '2148', '815', '989', '80', '0', '32');
+INSERT INTO `guild_shops` VALUES ('60430', '834', '79', '200', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '832', '675', '4500', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '822', '1800', '3400', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '2128', '75', '86', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('60430', '2173', '405', '748', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60430', '2145', '75', '180', '165', '33', '65');
+
+-- Tsutsuroon (Tenshodo Merchant) Nashmau
+INSERT INTO `guild_shops` VALUES ('60431', '16896', '517', '592', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '16917', '4226', '4226', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '16900', '1404', '1608', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '16919', '2728', '3125', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '16960', '3121', '3575', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '16975', '11583', '13266', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '16966', '1836', '2103', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '16982', '4752', '15760', '20', '0', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '16987', '12253', '14033', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '16988', '14676', '16808', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '17802', '189945', '464059', '20', '2', '3');
+INSERT INTO `guild_shops` VALUES ('60431', '16871', '183516', '404395', '20', '2', '3');
+INSERT INTO `guild_shops` VALUES ('60431', '17259', '72144', '158976', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '17301', '29', '87', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '17302', '347', '993', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '17304', '57960', '57960', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '17322', '81', '187', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '17340', '58', '436', '8910', '0', '3564');
+INSERT INTO `guild_shops` VALUES ('60431', '12456', '552', '858', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '12457', '3272', '5079', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '12458', '8972', '13927', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '13111', '20061', '29942', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '12584', '833', '1294', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '12585', '4931', '7654', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '12586', '13266', '14850', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '12712', '458', '712', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '12713', '2713', '4212', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '12714', '2713', '8316', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '12840', '666', '1034', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '12841', '2713', '6133', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '12842', '10805', '12096', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '12968', '424', '660', '20', '10', '20');
+INSERT INTO `guild_shops` VALUES ('60431', '12969', '2528', '3924', '20', '7', '15');
+INSERT INTO `guild_shops` VALUES ('60431', '12970', '11071', '12393', '20', '5', '10');
+INSERT INTO `guild_shops` VALUES ('60431', '704', '96', '149', '375', '75', '150');
+INSERT INTO `guild_shops` VALUES ('60431', '915', '2700', '16120', '165', '33', '165');
+INSERT INTO `guild_shops` VALUES ('60431', '1134', '810', '2095', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '1155', '436', '645', '165', '33', '165');
+INSERT INTO `guild_shops` VALUES ('60431', '657', '4690', '21000', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60431', '1415', '55147', '55147', '165', '33', '65');
+INSERT INTO `guild_shops` VALUES ('60431', '1161', '66', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '1164', '30', '120', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '1167', '58', '107', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '1170', '58', '107', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '1173', '56', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '1176', '44', '174', '2970', '594', '1188');
+INSERT INTO `guild_shops` VALUES ('60431', '1472', '369', '369', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '1554', '431', '512', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '1555', '1061', '1259', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '1590', '536', '700', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '1475', '579', '1188', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '5164', '1945', '2854', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '1652', '150', '160', '255', '48', '100');
+INSERT INTO `guild_shops` VALUES ('60431', '5235', '187', '200', '255', '48', '100');
\ No newline at end of file