/*
MySQL Data Transfer
Source Host: localhost
Source Database: l2jdb
Target Host: localhost
Target Database: l2jdb
Date: 2012-07-22 11:09:14
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for merchant_shopids
-- ----------------------------
DROP TABLE IF EXISTS `merchant_shopids`;
CREATE TABLE `merchant_shopids` (
  `shop_id` decimal(9,0) NOT NULL default '0',
  `npc_id` varchar(9) default NULL,
  PRIMARY KEY  (`shop_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `merchant_shopids` VALUES ('1', '7001');
INSERT INTO `merchant_shopids` VALUES ('2', '7001');
INSERT INTO `merchant_shopids` VALUES ('3', '7087');
INSERT INTO `merchant_shopids` VALUES ('4', '7087');
INSERT INTO `merchant_shopids` VALUES ('5', '7088');
INSERT INTO `merchant_shopids` VALUES ('6', '7088');
INSERT INTO `merchant_shopids` VALUES ('7', '7090');
INSERT INTO `merchant_shopids` VALUES ('8', '7091');
INSERT INTO `merchant_shopids` VALUES ('9', '7093');
INSERT INTO `merchant_shopids` VALUES ('10', '7093');
INSERT INTO `merchant_shopids` VALUES ('11', '7002');
INSERT INTO `merchant_shopids` VALUES ('12', '7002');
INSERT INTO `merchant_shopids` VALUES ('13', '7003');
INSERT INTO `merchant_shopids` VALUES ('14', '7004');
INSERT INTO `merchant_shopids` VALUES ('15', '7060');
INSERT INTO `merchant_shopids` VALUES ('16', '7060');
INSERT INTO `merchant_shopids` VALUES ('17', '7061');
INSERT INTO `merchant_shopids` VALUES ('18', '7061');
INSERT INTO `merchant_shopids` VALUES ('19', '7062');
INSERT INTO `merchant_shopids` VALUES ('20', '7063');
INSERT INTO `merchant_shopids` VALUES ('21', '7078');
INSERT INTO `merchant_shopids` VALUES ('22', '7078');
INSERT INTO `merchant_shopids` VALUES ('23', '7081');
INSERT INTO `merchant_shopids` VALUES ('24', '7082');
INSERT INTO `merchant_shopids` VALUES ('25', '7084');
INSERT INTO `merchant_shopids` VALUES ('26', '7084');
INSERT INTO `merchant_shopids` VALUES ('27', '7085');
INSERT INTO `merchant_shopids` VALUES ('28', '7085');
INSERT INTO `merchant_shopids` VALUES ('29', '7094');
INSERT INTO `merchant_shopids` VALUES ('30', '7094');
INSERT INTO `merchant_shopids` VALUES ('31', '7135');
INSERT INTO `merchant_shopids` VALUES ('32', '7135');
INSERT INTO `merchant_shopids` VALUES ('33', '7136');
INSERT INTO `merchant_shopids` VALUES ('34', '7136');
INSERT INTO `merchant_shopids` VALUES ('35', '7137');
INSERT INTO `merchant_shopids` VALUES ('36', '7138');
INSERT INTO `merchant_shopids` VALUES ('37', '7147');
INSERT INTO `merchant_shopids` VALUES ('38', '7147');
INSERT INTO `merchant_shopids` VALUES ('39', '7148');
INSERT INTO `merchant_shopids` VALUES ('40', '7148');
INSERT INTO `merchant_shopids` VALUES ('41', '7149');
INSERT INTO `merchant_shopids` VALUES ('42', '7150');
INSERT INTO `merchant_shopids` VALUES ('43', '7163');
INSERT INTO `merchant_shopids` VALUES ('44', '7164');
INSERT INTO `merchant_shopids` VALUES ('45', '7165');
INSERT INTO `merchant_shopids` VALUES ('46', '7166');
INSERT INTO `merchant_shopids` VALUES ('47', '7178');
INSERT INTO `merchant_shopids` VALUES ('48', '7178');
INSERT INTO `merchant_shopids` VALUES ('49', '7179');
INSERT INTO `merchant_shopids` VALUES ('50', '7179');
INSERT INTO `merchant_shopids` VALUES ('51', '7180');
INSERT INTO `merchant_shopids` VALUES ('52', '7181');
INSERT INTO `merchant_shopids` VALUES ('53', '7207');
INSERT INTO `merchant_shopids` VALUES ('54', '7207');
INSERT INTO `merchant_shopids` VALUES ('55', '7208');
INSERT INTO `merchant_shopids` VALUES ('56', '7208');
INSERT INTO `merchant_shopids` VALUES ('57', '7209');
INSERT INTO `merchant_shopids` VALUES ('58', '7230');
INSERT INTO `merchant_shopids` VALUES ('59', '7230');
INSERT INTO `merchant_shopids` VALUES ('60', '7231');
INSERT INTO `merchant_shopids` VALUES ('61', '7253');
INSERT INTO `merchant_shopids` VALUES ('62', '7253');
INSERT INTO `merchant_shopids` VALUES ('63', '7254');
INSERT INTO `merchant_shopids` VALUES ('64', '7294');
INSERT INTO `merchant_shopids` VALUES ('65', '7301');
INSERT INTO `merchant_shopids` VALUES ('66', '7313');
INSERT INTO `merchant_shopids` VALUES ('67', '7314');
INSERT INTO `merchant_shopids` VALUES ('68', '7315');
INSERT INTO `merchant_shopids` VALUES ('69', '7321');
INSERT INTO `merchant_shopids` VALUES ('70', '7321');
INSERT INTO `merchant_shopids` VALUES ('71', '7420');
INSERT INTO `merchant_shopids` VALUES ('72', '7436');
INSERT INTO `merchant_shopids` VALUES ('73', '7436');
INSERT INTO `merchant_shopids` VALUES ('74', '7437');
INSERT INTO `merchant_shopids` VALUES ('75', '7516');
INSERT INTO `merchant_shopids` VALUES ('76', '7516');
INSERT INTO `merchant_shopids` VALUES ('77', '7517');
INSERT INTO `merchant_shopids` VALUES ('78', '7517');
INSERT INTO `merchant_shopids` VALUES ('79', '7518');
INSERT INTO `merchant_shopids` VALUES ('80', '7519');
INSERT INTO `merchant_shopids` VALUES ('81', '7558');
INSERT INTO `merchant_shopids` VALUES ('82', '7558');
INSERT INTO `merchant_shopids` VALUES ('83', '7559');
INSERT INTO `merchant_shopids` VALUES ('84', '7559');
INSERT INTO `merchant_shopids` VALUES ('85', '7560');
INSERT INTO `merchant_shopids` VALUES ('86', '7561');
INSERT INTO `merchant_shopids` VALUES ('87', '7684');
INSERT INTO `merchant_shopids` VALUES ('88', '7684');
INSERT INTO `merchant_shopids` VALUES ('89', '7731');
INSERT INTO `merchant_shopids` VALUES ('90', '7827');
INSERT INTO `merchant_shopids` VALUES ('91', '7828');
INSERT INTO `merchant_shopids` VALUES ('92', '7829');
INSERT INTO `merchant_shopids` VALUES ('93', '7830');
INSERT INTO `merchant_shopids` VALUES ('94', '7831');
INSERT INTO `merchant_shopids` VALUES ('95', '7834');
INSERT INTO `merchant_shopids` VALUES ('96', '7837');
INSERT INTO `merchant_shopids` VALUES ('97', '7837');
INSERT INTO `merchant_shopids` VALUES ('98', '7838');
INSERT INTO `merchant_shopids` VALUES ('99', '7838');
INSERT INTO `merchant_shopids` VALUES ('100', '7839');
INSERT INTO `merchant_shopids` VALUES ('101', '7840');
INSERT INTO `merchant_shopids` VALUES ('102', '7841');
INSERT INTO `merchant_shopids` VALUES ('103', '7842');
INSERT INTO `merchant_shopids` VALUES ('104', '7869');
INSERT INTO `merchant_shopids` VALUES ('105', '8256');
INSERT INTO `merchant_shopids` VALUES ('106', '8256');
INSERT INTO `merchant_shopids` VALUES ('107', '8257');
INSERT INTO `merchant_shopids` VALUES ('108', '8257');
INSERT INTO `merchant_shopids` VALUES ('109', '8258');
INSERT INTO `merchant_shopids` VALUES ('110', '8258');
INSERT INTO `merchant_shopids` VALUES ('111', '8259');
INSERT INTO `merchant_shopids` VALUES ('112', '8259');
INSERT INTO `merchant_shopids` VALUES ('113', '8260');
INSERT INTO `merchant_shopids` VALUES ('114', '8261');
INSERT INTO `merchant_shopids` VALUES ('115', '8262');
INSERT INTO `merchant_shopids` VALUES ('116', '8263');
INSERT INTO `merchant_shopids` VALUES ('117', '8263');
INSERT INTO `merchant_shopids` VALUES ('118', '8265');
INSERT INTO `merchant_shopids` VALUES ('119', '8273');
INSERT INTO `merchant_shopids` VALUES ('120', '8274');
INSERT INTO `merchant_shopids` VALUES ('121', '8284');
INSERT INTO `merchant_shopids` VALUES ('122', '8291');
INSERT INTO `merchant_shopids` VALUES ('123', '8300');
INSERT INTO `merchant_shopids` VALUES ('124', '8300');
INSERT INTO `merchant_shopids` VALUES ('125', '8301');
INSERT INTO `merchant_shopids` VALUES ('126', '8301');
INSERT INTO `merchant_shopids` VALUES ('127', '8302');
INSERT INTO `merchant_shopids` VALUES ('128', '8302');
INSERT INTO `merchant_shopids` VALUES ('129', '8303');
INSERT INTO `merchant_shopids` VALUES ('130', '8303');
INSERT INTO `merchant_shopids` VALUES ('131', '8304');
INSERT INTO `merchant_shopids` VALUES ('132', '8305');
INSERT INTO `merchant_shopids` VALUES ('133', '8306');
INSERT INTO `merchant_shopids` VALUES ('134', '8307');
INSERT INTO `merchant_shopids` VALUES ('135', '8307');
INSERT INTO `merchant_shopids` VALUES ('136', '8309');
INSERT INTO `merchant_shopids` VALUES ('137', '8318');
INSERT INTO `merchant_shopids` VALUES ('138', '8319');
INSERT INTO `merchant_shopids` VALUES ('139', '8338');
INSERT INTO `merchant_shopids` VALUES ('140', '8339');
INSERT INTO `merchant_shopids` VALUES ('141', '8366');
INSERT INTO `merchant_shopids` VALUES ('142', '8578');
INSERT INTO `merchant_shopids` VALUES ('143', '8579');
INSERT INTO `merchant_shopids` VALUES ('144', '8696');
INSERT INTO `merchant_shopids` VALUES ('145', '8366');
INSERT INTO `merchant_shopids` VALUES ('146', '8445');
INSERT INTO `merchant_shopids` VALUES ('5800', '7890');
INSERT INTO `merchant_shopids` VALUES ('5801', '7890');
INSERT INTO `merchant_shopids` VALUES ('5802', '7891');
INSERT INTO `merchant_shopids` VALUES ('5803', '7891');
INSERT INTO `merchant_shopids` VALUES ('305', '8044');
INSERT INTO `merchant_shopids` VALUES ('306', '8045');
INSERT INTO `merchant_shopids` VALUES ('5807', '8045');
INSERT INTO `merchant_shopids` VALUES ('5600', '7892');
INSERT INTO `merchant_shopids` VALUES ('5601', '7893');
INSERT INTO `merchant_shopids` VALUES ('5710', '8067');
INSERT INTO `merchant_shopids` VALUES ('123161', '12316');
INSERT INTO `merchant_shopids` VALUES ('123171', '12317');
INSERT INTO `merchant_shopids` VALUES ('123181', '12318');
INSERT INTO `merchant_shopids` VALUES ('123191', '12319');
INSERT INTO `merchant_shopids` VALUES ('123201', '12320');
INSERT INTO `merchant_shopids` VALUES ('123211', '12321');
INSERT INTO `merchant_shopids` VALUES ('1001', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1002', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1003', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1004', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1005', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1006', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1007', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1008', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1009', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1010', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1011', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1012', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1013', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1014', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1015', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2001', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2002', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2003', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2004', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2005', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2006', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2007', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2008', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2009', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2010', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2011', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2012', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2013', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2014', 'gm');
INSERT INTO `merchant_shopids` VALUES ('2015', 'gm');
INSERT INTO `merchant_shopids` VALUES ('3001', 'gm');
INSERT INTO `merchant_shopids` VALUES ('3002', 'gm');
INSERT INTO `merchant_shopids` VALUES ('3003', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30040', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30041', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30042', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30043', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30044', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30045', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30046', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30047', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30048', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30049', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300410', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30050', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30051', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30052', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30053', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30054', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30055', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30056', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30057', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30058', 'gm');
INSERT INTO `merchant_shopids` VALUES ('30059', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300510', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300511', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1025', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1026', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1027', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1028', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1029', 'gm');
INSERT INTO `merchant_shopids` VALUES ('1030', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300522', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300523', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300524', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300525', 'gm');
INSERT INTO `merchant_shopids` VALUES ('300526', 'gm');
INSERT INTO `merchant_shopids` VALUES ('307596', '7596');
INSERT INTO `merchant_shopids` VALUES ('307774', '7774');
INSERT INTO `merchant_shopids` VALUES ('307776', '7776');
INSERT INTO `merchant_shopids` VALUES ('307778', '7778');
INSERT INTO `merchant_shopids` VALUES ('307780', '7780');
INSERT INTO `merchant_shopids` VALUES ('307782', '7782');
INSERT INTO `merchant_shopids` VALUES ('307784', '7784');
INSERT INTO `merchant_shopids` VALUES ('307785', '7785');
INSERT INTO `merchant_shopids` VALUES ('307786', '7786');
INSERT INTO `merchant_shopids` VALUES ('307788', '7788');
INSERT INTO `merchant_shopids` VALUES ('307790', '7790');
INSERT INTO `merchant_shopids` VALUES ('307798', '7798');
INSERT INTO `merchant_shopids` VALUES ('307800', '7800');
INSERT INTO `merchant_shopids` VALUES ('307802', '7802');
INSERT INTO `merchant_shopids` VALUES ('308150', '8150');
INSERT INTO `merchant_shopids` VALUES ('308152', '8152');
INSERT INTO `merchant_shopids` VALUES ('308154', '8154');
INSERT INTO `merchant_shopids` VALUES ('308156', '8156');
INSERT INTO `merchant_shopids` VALUES ('308158', '8158');
INSERT INTO `merchant_shopids` VALUES ('308160', '8160');
INSERT INTO `merchant_shopids` VALUES ('312562', '12562');
INSERT INTO `merchant_shopids` VALUES ('312833', '12833');
INSERT INTO `merchant_shopids` VALUES ('312834', '12834');
INSERT INTO `merchant_shopids` VALUES ('312835', '12835');
INSERT INTO `merchant_shopids` VALUES ('312836', '12836');
INSERT INTO `merchant_shopids` VALUES ('312837', '12837');
INSERT INTO `merchant_shopids` VALUES ('312846', '12846');
INSERT INTO `merchant_shopids` VALUES ('312847', '12847');
INSERT INTO `merchant_shopids` VALUES ('312848', '12848');
INSERT INTO `merchant_shopids` VALUES ('312849', '12849');
INSERT INTO `merchant_shopids` VALUES ('312850', '12850');
INSERT INTO `merchant_shopids` VALUES ('312851', '12851');
INSERT INTO `merchant_shopids` VALUES ('312852', '12852');
INSERT INTO `merchant_shopids` VALUES ('312853', '12853');
INSERT INTO `merchant_shopids` VALUES ('312854', '12854');
INSERT INTO `merchant_shopids` VALUES ('312855', '12855');
INSERT INTO `merchant_shopids` VALUES ('312856', '12856');
INSERT INTO `merchant_shopids` VALUES ('312857', '12857');
INSERT INTO `merchant_shopids` VALUES ('312858', '12858');
INSERT INTO `merchant_shopids` VALUES ('312859', '12859');
INSERT INTO `merchant_shopids` VALUES ('312860', '12860');
INSERT INTO `merchant_shopids` VALUES ('312861', '12861');
INSERT INTO `merchant_shopids` VALUES ('312862', '12862');
INSERT INTO `merchant_shopids` VALUES ('312863', '12863');
INSERT INTO `merchant_shopids` VALUES ('312864', '12864');
INSERT INTO `merchant_shopids` VALUES ('312865', '12865');
INSERT INTO `merchant_shopids` VALUES ('312866', '12866');
INSERT INTO `merchant_shopids` VALUES ('312867', '12867');
INSERT INTO `merchant_shopids` VALUES ('312868', '12868');
INSERT INTO `merchant_shopids` VALUES ('312869', '12869');
INSERT INTO `merchant_shopids` VALUES ('312870', '12870');
INSERT INTO `merchant_shopids` VALUES ('312871', '12871');
INSERT INTO `merchant_shopids` VALUES ('312872', '12872');
INSERT INTO `merchant_shopids` VALUES ('312873', '12873');
INSERT INTO `merchant_shopids` VALUES ('312874', '12874');
INSERT INTO `merchant_shopids` VALUES ('312875', '12875');
INSERT INTO `merchant_shopids` VALUES ('312876', '12876');
INSERT INTO `merchant_shopids` VALUES ('312877', '12877');
INSERT INTO `merchant_shopids` VALUES ('312878', '12878');
INSERT INTO `merchant_shopids` VALUES ('312879', '12879');
INSERT INTO `merchant_shopids` VALUES ('312880', '12880');
INSERT INTO `merchant_shopids` VALUES ('312881', '12881');
INSERT INTO `merchant_shopids` VALUES ('312882', '12882');
INSERT INTO `merchant_shopids` VALUES ('312883', '12883');
INSERT INTO `merchant_shopids` VALUES ('312884', '12884');
INSERT INTO `merchant_shopids` VALUES ('312885', '12885');
INSERT INTO `merchant_shopids` VALUES ('312886', '12886');
INSERT INTO `merchant_shopids` VALUES ('312889', '12889');
INSERT INTO `merchant_shopids` VALUES ('312890', '12890');
INSERT INTO `merchant_shopids` VALUES ('312891', '12891');
INSERT INTO `merchant_shopids` VALUES ('312892', '12892');
INSERT INTO `merchant_shopids` VALUES ('312893', '12893');
INSERT INTO `merchant_shopids` VALUES ('312894', '12894');
INSERT INTO `merchant_shopids` VALUES ('312895', '12895');
INSERT INTO `merchant_shopids` VALUES ('312896', '12896');
INSERT INTO `merchant_shopids` VALUES ('312897', '12897');
INSERT INTO `merchant_shopids` VALUES ('312898', '12898');
INSERT INTO `merchant_shopids` VALUES ('207596', '7596');
INSERT INTO `merchant_shopids` VALUES ('207774', '7774');
INSERT INTO `merchant_shopids` VALUES ('207776', '7776');
INSERT INTO `merchant_shopids` VALUES ('207778', '7778');
INSERT INTO `merchant_shopids` VALUES ('207780', '7780');
INSERT INTO `merchant_shopids` VALUES ('207782', '7782');
INSERT INTO `merchant_shopids` VALUES ('207784', '7784');
INSERT INTO `merchant_shopids` VALUES ('207785', '7785');
INSERT INTO `merchant_shopids` VALUES ('207786', '7786');
INSERT INTO `merchant_shopids` VALUES ('207788', '7788');
INSERT INTO `merchant_shopids` VALUES ('207790', '7790');
INSERT INTO `merchant_shopids` VALUES ('207798', '7798');
INSERT INTO `merchant_shopids` VALUES ('207800', '7800');
INSERT INTO `merchant_shopids` VALUES ('207802', '7802');
INSERT INTO `merchant_shopids` VALUES ('208150', '8150');
INSERT INTO `merchant_shopids` VALUES ('208152', '8152');
INSERT INTO `merchant_shopids` VALUES ('208154', '8154');
INSERT INTO `merchant_shopids` VALUES ('208156', '8156');
INSERT INTO `merchant_shopids` VALUES ('208158', '8158');
INSERT INTO `merchant_shopids` VALUES ('208160', '8160');
INSERT INTO `merchant_shopids` VALUES ('212562', '12562');
INSERT INTO `merchant_shopids` VALUES ('212833', '12833');
INSERT INTO `merchant_shopids` VALUES ('212834', '12834');
INSERT INTO `merchant_shopids` VALUES ('212835', '12835');
INSERT INTO `merchant_shopids` VALUES ('212836', '12836');
INSERT INTO `merchant_shopids` VALUES ('212837', '12837');
INSERT INTO `merchant_shopids` VALUES ('212846', '12846');
INSERT INTO `merchant_shopids` VALUES ('212847', '12847');
INSERT INTO `merchant_shopids` VALUES ('212848', '12848');
INSERT INTO `merchant_shopids` VALUES ('212849', '12849');
INSERT INTO `merchant_shopids` VALUES ('212850', '12850');
INSERT INTO `merchant_shopids` VALUES ('212851', '12851');
INSERT INTO `merchant_shopids` VALUES ('212852', '12852');
INSERT INTO `merchant_shopids` VALUES ('212853', '12853');
INSERT INTO `merchant_shopids` VALUES ('212854', '12854');
INSERT INTO `merchant_shopids` VALUES ('212855', '12855');
INSERT INTO `merchant_shopids` VALUES ('212856', '12856');
INSERT INTO `merchant_shopids` VALUES ('212857', '12857');
INSERT INTO `merchant_shopids` VALUES ('212858', '12858');
INSERT INTO `merchant_shopids` VALUES ('212859', '12859');
INSERT INTO `merchant_shopids` VALUES ('212860', '12860');
INSERT INTO `merchant_shopids` VALUES ('212861', '12861');
INSERT INTO `merchant_shopids` VALUES ('212862', '12862');
INSERT INTO `merchant_shopids` VALUES ('212863', '12863');
INSERT INTO `merchant_shopids` VALUES ('212864', '12864');
INSERT INTO `merchant_shopids` VALUES ('212865', '12865');
INSERT INTO `merchant_shopids` VALUES ('212866', '12866');
INSERT INTO `merchant_shopids` VALUES ('212867', '12867');
INSERT INTO `merchant_shopids` VALUES ('212868', '12868');
INSERT INTO `merchant_shopids` VALUES ('212869', '12869');
INSERT INTO `merchant_shopids` VALUES ('212870', '12870');
INSERT INTO `merchant_shopids` VALUES ('212871', '12871');
INSERT INTO `merchant_shopids` VALUES ('212872', '12872');
INSERT INTO `merchant_shopids` VALUES ('212873', '12873');
INSERT INTO `merchant_shopids` VALUES ('212874', '12874');
INSERT INTO `merchant_shopids` VALUES ('212875', '12875');
INSERT INTO `merchant_shopids` VALUES ('212876', '12876');
INSERT INTO `merchant_shopids` VALUES ('212877', '12877');
INSERT INTO `merchant_shopids` VALUES ('212878', '12878');
INSERT INTO `merchant_shopids` VALUES ('212879', '12879');
INSERT INTO `merchant_shopids` VALUES ('212880', '12880');
INSERT INTO `merchant_shopids` VALUES ('212881', '12881');
INSERT INTO `merchant_shopids` VALUES ('212882', '12882');
INSERT INTO `merchant_shopids` VALUES ('212883', '12883');
INSERT INTO `merchant_shopids` VALUES ('212884', '12884');
INSERT INTO `merchant_shopids` VALUES ('212885', '12885');
INSERT INTO `merchant_shopids` VALUES ('212886', '12886');
INSERT INTO `merchant_shopids` VALUES ('212889', '12889');
INSERT INTO `merchant_shopids` VALUES ('212890', '12890');
INSERT INTO `merchant_shopids` VALUES ('212891', '12891');
INSERT INTO `merchant_shopids` VALUES ('212892', '12892');
INSERT INTO `merchant_shopids` VALUES ('212893', '12893');
INSERT INTO `merchant_shopids` VALUES ('212894', '12894');
INSERT INTO `merchant_shopids` VALUES ('212895', '12895');
INSERT INTO `merchant_shopids` VALUES ('212896', '12896');
INSERT INTO `merchant_shopids` VALUES ('212897', '12897');
INSERT INTO `merchant_shopids` VALUES ('212898', '12898');
INSERT INTO `merchant_shopids` VALUES ('107596', '7596');
INSERT INTO `merchant_shopids` VALUES ('107774', '7774');
INSERT INTO `merchant_shopids` VALUES ('107776', '7776');
INSERT INTO `merchant_shopids` VALUES ('107778', '7778');
INSERT INTO `merchant_shopids` VALUES ('107780', '7780');
INSERT INTO `merchant_shopids` VALUES ('107782', '7782');
INSERT INTO `merchant_shopids` VALUES ('107784', '7784');
INSERT INTO `merchant_shopids` VALUES ('107785', '7785');
INSERT INTO `merchant_shopids` VALUES ('107786', '7786');
INSERT INTO `merchant_shopids` VALUES ('107788', '7788');
INSERT INTO `merchant_shopids` VALUES ('107790', '7790');
INSERT INTO `merchant_shopids` VALUES ('107798', '7798');
INSERT INTO `merchant_shopids` VALUES ('107800', '7800');
INSERT INTO `merchant_shopids` VALUES ('107802', '7802');
INSERT INTO `merchant_shopids` VALUES ('108150', '8150');
INSERT INTO `merchant_shopids` VALUES ('108152', '8152');
INSERT INTO `merchant_shopids` VALUES ('108154', '8154');
INSERT INTO `merchant_shopids` VALUES ('108156', '8156');
INSERT INTO `merchant_shopids` VALUES ('108158', '8158');
INSERT INTO `merchant_shopids` VALUES ('108160', '8160');
INSERT INTO `merchant_shopids` VALUES ('112562', '12562');
INSERT INTO `merchant_shopids` VALUES ('112833', '12833');
INSERT INTO `merchant_shopids` VALUES ('112834', '12834');
INSERT INTO `merchant_shopids` VALUES ('112835', '12835');
INSERT INTO `merchant_shopids` VALUES ('112836', '12836');
INSERT INTO `merchant_shopids` VALUES ('112837', '12837');
INSERT INTO `merchant_shopids` VALUES ('112846', '12846');
INSERT INTO `merchant_shopids` VALUES ('112847', '12847');
INSERT INTO `merchant_shopids` VALUES ('112848', '12848');
INSERT INTO `merchant_shopids` VALUES ('112849', '12849');
INSERT INTO `merchant_shopids` VALUES ('112850', '12850');
INSERT INTO `merchant_shopids` VALUES ('112851', '12851');
INSERT INTO `merchant_shopids` VALUES ('112852', '12852');
INSERT INTO `merchant_shopids` VALUES ('112853', '12853');
INSERT INTO `merchant_shopids` VALUES ('112854', '12854');
INSERT INTO `merchant_shopids` VALUES ('112855', '12855');
INSERT INTO `merchant_shopids` VALUES ('112856', '12856');
INSERT INTO `merchant_shopids` VALUES ('112857', '12857');
INSERT INTO `merchant_shopids` VALUES ('112858', '12858');
INSERT INTO `merchant_shopids` VALUES ('112859', '12859');
INSERT INTO `merchant_shopids` VALUES ('112860', '12860');
INSERT INTO `merchant_shopids` VALUES ('112861', '12861');
INSERT INTO `merchant_shopids` VALUES ('112862', '12862');
INSERT INTO `merchant_shopids` VALUES ('112863', '12863');
INSERT INTO `merchant_shopids` VALUES ('112864', '12864');
INSERT INTO `merchant_shopids` VALUES ('112865', '12865');
INSERT INTO `merchant_shopids` VALUES ('112866', '12866');
INSERT INTO `merchant_shopids` VALUES ('112867', '12867');
INSERT INTO `merchant_shopids` VALUES ('112868', '12868');
INSERT INTO `merchant_shopids` VALUES ('112869', '12869');
INSERT INTO `merchant_shopids` VALUES ('112870', '12870');
INSERT INTO `merchant_shopids` VALUES ('112871', '12871');
INSERT INTO `merchant_shopids` VALUES ('112872', '12872');
INSERT INTO `merchant_shopids` VALUES ('112873', '12873');
INSERT INTO `merchant_shopids` VALUES ('112874', '12874');
INSERT INTO `merchant_shopids` VALUES ('112875', '12875');
INSERT INTO `merchant_shopids` VALUES ('112876', '12876');
INSERT INTO `merchant_shopids` VALUES ('112877', '12877');
INSERT INTO `merchant_shopids` VALUES ('112878', '12878');
INSERT INTO `merchant_shopids` VALUES ('112879', '12879');
INSERT INTO `merchant_shopids` VALUES ('112880', '12880');
INSERT INTO `merchant_shopids` VALUES ('112881', '12881');
INSERT INTO `merchant_shopids` VALUES ('112882', '12882');
INSERT INTO `merchant_shopids` VALUES ('112883', '12883');
INSERT INTO `merchant_shopids` VALUES ('112884', '12884');
INSERT INTO `merchant_shopids` VALUES ('112885', '12885');
INSERT INTO `merchant_shopids` VALUES ('112886', '12886');
INSERT INTO `merchant_shopids` VALUES ('112889', '12889');
INSERT INTO `merchant_shopids` VALUES ('112890', '12890');
INSERT INTO `merchant_shopids` VALUES ('112891', '12891');
INSERT INTO `merchant_shopids` VALUES ('112892', '12892');
INSERT INTO `merchant_shopids` VALUES ('112893', '12893');
INSERT INTO `merchant_shopids` VALUES ('112894', '12894');
INSERT INTO `merchant_shopids` VALUES ('112895', '12895');
INSERT INTO `merchant_shopids` VALUES ('112896', '12896');
INSERT INTO `merchant_shopids` VALUES ('112897', '12897');
INSERT INTO `merchant_shopids` VALUES ('112898', '12898');
INSERT INTO `merchant_shopids` VALUES ('12152', '12152');
INSERT INTO `merchant_shopids` VALUES ('12252', '12252');
INSERT INTO `merchant_shopids` VALUES ('12121', '12121');
INSERT INTO `merchant_shopids` VALUES ('12255', '12255');
INSERT INTO `merchant_shopids` VALUES ('12791', '12791');
INSERT INTO `merchant_shopids` VALUES ('12240', '12240');
INSERT INTO `merchant_shopids` VALUES ('147', '8386');
INSERT INTO `merchant_shopids` VALUES ('148', '8438');
INSERT INTO `merchant_shopids` VALUES ('335512', '38403');
INSERT INTO `merchant_shopids` VALUES ('37996', '37996');
INSERT INTO `merchant_shopids` VALUES ('37997', '37997');
INSERT INTO `merchant_shopids` VALUES ('37998', '37998');
INSERT INTO `merchant_shopids` VALUES ('37999', '37999');
INSERT INTO `merchant_shopids` VALUES ('38000', '38000');
INSERT INTO `merchant_shopids` VALUES ('38058', '38058');
INSERT INTO `merchant_shopids` VALUES ('38059', '38059');
INSERT INTO `merchant_shopids` VALUES ('38060', '38060');
INSERT INTO `merchant_shopids` VALUES ('38402', '38402');
INSERT INTO `merchant_shopids` VALUES ('38403', '38403');
INSERT INTO `merchant_shopids` VALUES ('149', '8413');
INSERT INTO `merchant_shopids` VALUES ('150', '8419');
INSERT INTO `merchant_shopids` VALUES ('159', '8414');
INSERT INTO `merchant_shopids` VALUES ('160', '8418');
INSERT INTO `merchant_shopids` VALUES ('161', '8415');
INSERT INTO `merchant_shopids` VALUES ('162', '8423');
INSERT INTO `merchant_shopids` VALUES ('170', '8416');
INSERT INTO `merchant_shopids` VALUES ('171', '8417');
INSERT INTO `merchant_shopids` VALUES ('197', '8420');
INSERT INTO `merchant_shopids` VALUES ('202', '8421');
INSERT INTO `merchant_shopids` VALUES ('174', '8422');
INSERT INTO `merchant_shopids` VALUES ('301', '8041');
INSERT INTO `merchant_shopids` VALUES ('302', '12790');
INSERT INTO `merchant_shopids` VALUES ('155', '8442');
INSERT INTO `merchant_shopids` VALUES ('368', '7081');
