l2j-server-datapack/L2J_DataPack/sql/merchant_shopids.sql

--
-- Table structure for table `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;

--
-- Dumping data for table `merchant_shopids`
--

-- General Shops

INSERT INTO merchant_shopids VALUES (3000100,'30001');
INSERT INTO merchant_shopids VALUES (3000101,'30001');
INSERT INTO merchant_shopids VALUES (3000200,'30002');
INSERT INTO merchant_shopids VALUES (3000201,'30002');
INSERT INTO merchant_shopids VALUES (3000300,'30003');
INSERT INTO merchant_shopids VALUES (3000301,'30003');
INSERT INTO merchant_shopids VALUES (3000400,'30004');
INSERT INTO merchant_shopids VALUES (3004700,'30047');
INSERT INTO merchant_shopids VALUES (3006000,'30060');
INSERT INTO merchant_shopids VALUES (3006001,'30060');
INSERT INTO merchant_shopids VALUES (3006100,'30061');
INSERT INTO merchant_shopids VALUES (3006101,'30061');
INSERT INTO merchant_shopids VALUES (3006200,'30062');
INSERT INTO merchant_shopids VALUES (3006201,'30062');
INSERT INTO merchant_shopids VALUES (3006300,'30063');
INSERT INTO merchant_shopids VALUES (3006301,'30063');
INSERT INTO merchant_shopids VALUES (3007800,'30078');
INSERT INTO merchant_shopids VALUES (3008100,'30081');
INSERT INTO merchant_shopids VALUES (3008101,'30081');
INSERT INTO merchant_shopids VALUES (3008200,'30082');
INSERT INTO merchant_shopids VALUES (3008201,'30082');
INSERT INTO merchant_shopids VALUES (3008400,'30084');
INSERT INTO merchant_shopids VALUES (3008500,'30085');
INSERT INTO merchant_shopids VALUES (3008700,'30087');
INSERT INTO merchant_shopids VALUES (3008800,'30088');
INSERT INTO merchant_shopids VALUES (3009000,'30090');
INSERT INTO merchant_shopids VALUES (3009100,'30091');
INSERT INTO merchant_shopids VALUES (3009300,'30093');
INSERT INTO merchant_shopids VALUES (3009400,'30094');
INSERT INTO merchant_shopids VALUES (3009401,'30094');
INSERT INTO merchant_shopids VALUES (3013500,'30135');
INSERT INTO merchant_shopids VALUES (3013501,'30135');
INSERT INTO merchant_shopids VALUES (3013600,'30136');
INSERT INTO merchant_shopids VALUES (3013601,'30136');
INSERT INTO merchant_shopids VALUES (3013700,'30137');
INSERT INTO merchant_shopids VALUES (3013800,'30138');
INSERT INTO merchant_shopids VALUES (3013801,'30138');
INSERT INTO merchant_shopids VALUES (3014700,'30147');
INSERT INTO merchant_shopids VALUES (3014701,'30147');
INSERT INTO merchant_shopids VALUES (3014800,'30148');
INSERT INTO merchant_shopids VALUES (3014801,'30148');
INSERT INTO merchant_shopids VALUES (3014900,'30149');
INSERT INTO merchant_shopids VALUES (3014901,'30149');
INSERT INTO merchant_shopids VALUES (3015000,'30150');
INSERT INTO merchant_shopids VALUES (3016300,'30163');
INSERT INTO merchant_shopids VALUES (3016400,'30164');
INSERT INTO merchant_shopids VALUES (3016500,'30165');
INSERT INTO merchant_shopids VALUES (3016501,'30165');
INSERT INTO merchant_shopids VALUES (3016600,'30166');
INSERT INTO merchant_shopids VALUES (3016601,'30166');
INSERT INTO merchant_shopids VALUES (3017800,'30178');
INSERT INTO merchant_shopids VALUES (3017801,'30178');
INSERT INTO merchant_shopids VALUES (3017900,'30179');
INSERT INTO merchant_shopids VALUES (3017901,'30179');
INSERT INTO merchant_shopids VALUES (3018000,'30180');
INSERT INTO merchant_shopids VALUES (3018001,'30180');
INSERT INTO merchant_shopids VALUES (3018100,'30181');
INSERT INTO merchant_shopids VALUES (3018101,'30181');
INSERT INTO merchant_shopids VALUES (3020700,'30207');
INSERT INTO merchant_shopids VALUES (3020701,'30207');
INSERT INTO merchant_shopids VALUES (3020800,'30208');
INSERT INTO merchant_shopids VALUES (3020801,'30208');
INSERT INTO merchant_shopids VALUES (3020900,'30209');
INSERT INTO merchant_shopids VALUES (3023000,'30230');
INSERT INTO merchant_shopids VALUES (3023001,'30230');
INSERT INTO merchant_shopids VALUES (3023100,'30231');
INSERT INTO merchant_shopids VALUES (3023101,'30231');
INSERT INTO merchant_shopids VALUES (3025300,'30253');
INSERT INTO merchant_shopids VALUES (3025301,'30253');
INSERT INTO merchant_shopids VALUES (3025400,'30254');
INSERT INTO merchant_shopids VALUES (3025401,'30254');
INSERT INTO merchant_shopids VALUES (3029400,'30294');
INSERT INTO merchant_shopids VALUES (3029401,'30294');
INSERT INTO merchant_shopids VALUES (3030100,'30301');
INSERT INTO merchant_shopids VALUES (3030101,'30301');
INSERT INTO merchant_shopids VALUES (3031300,'30313');
INSERT INTO merchant_shopids VALUES (3031400,'30314');
INSERT INTO merchant_shopids VALUES (3031401,'30314');
INSERT INTO merchant_shopids VALUES (3031500,'30315');
INSERT INTO merchant_shopids VALUES (3032100,'30321');
INSERT INTO merchant_shopids VALUES (3032101,'30321');
INSERT INTO merchant_shopids VALUES (3038700,'30387');
INSERT INTO merchant_shopids VALUES (3042000,'30420');
INSERT INTO merchant_shopids VALUES (3043600,'30436');
INSERT INTO merchant_shopids VALUES (3043700,'30437');
INSERT INTO merchant_shopids VALUES (3051600,'30516');
INSERT INTO merchant_shopids VALUES (3051601,'30516');
INSERT INTO merchant_shopids VALUES (3051700,'30517');
INSERT INTO merchant_shopids VALUES (3051701,'30517');
INSERT INTO merchant_shopids VALUES (3051800,'30518');
INSERT INTO merchant_shopids VALUES (3051900,'30519');
INSERT INTO merchant_shopids VALUES (3051901,'30519');
INSERT INTO merchant_shopids VALUES (3055800,'30558');
INSERT INTO merchant_shopids VALUES (3055801,'30558');
INSERT INTO merchant_shopids VALUES (3055900,'30559');
INSERT INTO merchant_shopids VALUES (3055901,'30559');
INSERT INTO merchant_shopids VALUES (3056000,'30560');
INSERT INTO merchant_shopids VALUES (3056001,'30560');
INSERT INTO merchant_shopids VALUES (3056100,'30561');
INSERT INTO merchant_shopids VALUES (3068400,'30684');
INSERT INTO merchant_shopids VALUES (3068401,'30684');
INSERT INTO merchant_shopids VALUES (3073100,'30731');
INSERT INTO merchant_shopids VALUES (3082700,'30827');
INSERT INTO merchant_shopids VALUES (3082800,'30828');
INSERT INTO merchant_shopids VALUES (3082900,'30829');
INSERT INTO merchant_shopids VALUES (3083000,'30830');
INSERT INTO merchant_shopids VALUES (3083100,'30831');
INSERT INTO merchant_shopids VALUES (3083400,'30834');
INSERT INTO merchant_shopids VALUES (3083401,'30834');
INSERT INTO merchant_shopids VALUES (3083700,'30837');
INSERT INTO merchant_shopids VALUES (3083701,'30837');
INSERT INTO merchant_shopids VALUES (3083800,'30838');
INSERT INTO merchant_shopids VALUES (3083801,'30838');
INSERT INTO merchant_shopids VALUES (3083900,'30839');
INSERT INTO merchant_shopids VALUES (3084000,'30840');
INSERT INTO merchant_shopids VALUES (3084100,'30841');
INSERT INTO merchant_shopids VALUES (3084101,'30841');
INSERT INTO merchant_shopids VALUES (3084200,'30842');
INSERT INTO merchant_shopids VALUES (3084201,'30842');
INSERT INTO merchant_shopids VALUES (3086900,'30869');
INSERT INTO merchant_shopids VALUES (3087900,'30879');
INSERT INTO merchant_shopids VALUES (3089000,'30890');
INSERT INTO merchant_shopids VALUES (3089001,'30890');
INSERT INTO merchant_shopids VALUES (3089100,'30891');
INSERT INTO merchant_shopids VALUES (3089101,'30891');
INSERT INTO merchant_shopids VALUES (3089200,'30892');
INSERT INTO merchant_shopids VALUES (3089201,'30892');
INSERT INTO merchant_shopids VALUES (3089300,'30893');
INSERT INTO merchant_shopids VALUES (3089301,'30893');
INSERT INTO merchant_shopids VALUES (3104400,'31044');
INSERT INTO merchant_shopids VALUES (3104500,'31045');
INSERT INTO merchant_shopids VALUES (3106700,'31067');
INSERT INTO merchant_shopids VALUES (3125600,'31256');
INSERT INTO merchant_shopids VALUES (3125601,'31256');
INSERT INTO merchant_shopids VALUES (3125700,'31257');
INSERT INTO merchant_shopids VALUES (3125701,'31257');
INSERT INTO merchant_shopids VALUES (3125800,'31258');
INSERT INTO merchant_shopids VALUES (3125801,'31258');
INSERT INTO merchant_shopids VALUES (3125900,'31259');
INSERT INTO merchant_shopids VALUES (3125901,'31259');
INSERT INTO merchant_shopids VALUES (3126000,'31260');
INSERT INTO merchant_shopids VALUES (3126100,'31261');
INSERT INTO merchant_shopids VALUES (3126200,'31262');
INSERT INTO merchant_shopids VALUES (3126300,'31263');
INSERT INTO merchant_shopids VALUES (3126301,'31263');
INSERT INTO merchant_shopids VALUES (3126500,'31265');
INSERT INTO merchant_shopids VALUES (3127300,'31273');
INSERT INTO merchant_shopids VALUES (3127400,'31274');
INSERT INTO merchant_shopids VALUES (3128400,'31284');
INSERT INTO merchant_shopids VALUES (3129100,'31291');
INSERT INTO merchant_shopids VALUES (3130000,'31300');
INSERT INTO merchant_shopids VALUES (3130001,'31300');
INSERT INTO merchant_shopids VALUES (3130100,'31301');
INSERT INTO merchant_shopids VALUES (3130101,'31301');
INSERT INTO merchant_shopids VALUES (3130200,'31302');
INSERT INTO merchant_shopids VALUES (3130201,'31302');
INSERT INTO merchant_shopids VALUES (3130300,'31303');
INSERT INTO merchant_shopids VALUES (3130301,'31303');
INSERT INTO merchant_shopids VALUES (3130400,'31304');
INSERT INTO merchant_shopids VALUES (3130500,'31305');
INSERT INTO merchant_shopids VALUES (3130600,'31306');
INSERT INTO merchant_shopids VALUES (3130700,'31307');
INSERT INTO merchant_shopids VALUES (3130701,'31307');
INSERT INTO merchant_shopids VALUES (3130900,'31309');
INSERT INTO merchant_shopids VALUES (3131800,'31318');
INSERT INTO merchant_shopids VALUES (3131900,'31319');
INSERT INTO merchant_shopids VALUES (3133800,'31338');
INSERT INTO merchant_shopids VALUES (3133900,'31339');
INSERT INTO merchant_shopids VALUES (3135100,'31351');
INSERT INTO merchant_shopids VALUES (3136600,'31366');
INSERT INTO merchant_shopids VALUES (3138600,'31386');
INSERT INTO merchant_shopids VALUES (3141300,'31413');
INSERT INTO merchant_shopids VALUES (3141400,'31414');
INSERT INTO merchant_shopids VALUES (3141500,'31415');
INSERT INTO merchant_shopids VALUES (3141600,'31416');
INSERT INTO merchant_shopids VALUES (3141700,'31417');
INSERT INTO merchant_shopids VALUES (3141800,'31418');
INSERT INTO merchant_shopids VALUES (3141900,'31419');
INSERT INTO merchant_shopids VALUES (3142000,'31420');
INSERT INTO merchant_shopids VALUES (3142100,'31421');
INSERT INTO merchant_shopids VALUES (3142200,'31422');
INSERT INTO merchant_shopids VALUES (3142300,'31423');
INSERT INTO merchant_shopids VALUES (3142400,'31424');
INSERT INTO merchant_shopids VALUES (3142500,'31425');
INSERT INTO merchant_shopids VALUES (3142600,'31426');
INSERT INTO merchant_shopids VALUES (3142700,'31427');
INSERT INTO merchant_shopids VALUES (3142800,'31428');
INSERT INTO merchant_shopids VALUES (3142900,'31429');
INSERT INTO merchant_shopids VALUES (3143000,'31430');
INSERT INTO merchant_shopids VALUES (3143100,'31431');
INSERT INTO merchant_shopids VALUES (3143200,'31432');
INSERT INTO merchant_shopids VALUES (3143300,'31433');
INSERT INTO merchant_shopids VALUES (3143400,'31434');
INSERT INTO merchant_shopids VALUES (3143500,'31435');
INSERT INTO merchant_shopids VALUES (3143600,'31436');
INSERT INTO merchant_shopids VALUES (3143700,'31437');
INSERT INTO merchant_shopids VALUES (3143800,'31438');
INSERT INTO merchant_shopids VALUES (3143900,'31439');
INSERT INTO merchant_shopids VALUES (3144000,'31440');
INSERT INTO merchant_shopids VALUES (3144100,'31441');
INSERT INTO merchant_shopids VALUES (3144200,'31442');
INSERT INTO merchant_shopids VALUES (3144300,'31443');
INSERT INTO merchant_shopids VALUES (3144400,'31444');
INSERT INTO merchant_shopids VALUES (3144500,'31445');
INSERT INTO merchant_shopids VALUES (3166600,'31666');
INSERT INTO merchant_shopids VALUES (3166700,'31667');
INSERT INTO merchant_shopids VALUES (3166800,'31668');
INSERT INTO merchant_shopids VALUES (3166900,'31669');
INSERT INTO merchant_shopids VALUES (3167000,'31670');
INSERT INTO merchant_shopids VALUES (3194500,'31945');
INSERT INTO merchant_shopids VALUES (3194501,'31945');
INSERT INTO merchant_shopids VALUES (3194600,'31946');
INSERT INTO merchant_shopids VALUES (3194601,'31946');
INSERT INTO merchant_shopids VALUES (3194700,'31947');
INSERT INTO merchant_shopids VALUES (3194701,'31947');
INSERT INTO merchant_shopids VALUES (3194800,'31948');
INSERT INTO merchant_shopids VALUES (3194801,'31948');
INSERT INTO merchant_shopids VALUES (3194900,'31949');
INSERT INTO merchant_shopids VALUES (3195000,'31950');
INSERT INTO merchant_shopids VALUES (3195100,'31951');
INSERT INTO merchant_shopids VALUES (3195200,'31952');
INSERT INTO merchant_shopids VALUES (3195201,'31952');
INSERT INTO merchant_shopids VALUES (3195400,'31954');
INSERT INTO merchant_shopids VALUES (3196200,'31962');
INSERT INTO merchant_shopids VALUES (3196300,'31963');
INSERT INTO merchant_shopids VALUES (3197300,'31973');
INSERT INTO merchant_shopids VALUES (3198000,'31980');
INSERT INTO merchant_shopids VALUES (3210500,'32105');
INSERT INTO merchant_shopids VALUES (3210600,'32106');
INSERT INTO merchant_shopids VALUES (3216400,'32164');
INSERT INTO merchant_shopids VALUES (3216401,'32164');
INSERT INTO merchant_shopids VALUES (3216500,'32165');
INSERT INTO merchant_shopids VALUES (3216501,'32165');
INSERT INTO merchant_shopids VALUES (3216600,'32166');
INSERT INTO merchant_shopids VALUES (3216700,'32167');
INSERT INTO merchant_shopids VALUES (3216800,'32168');
INSERT INTO merchant_shopids VALUES (3216900,'32169');
INSERT INTO merchant_shopids VALUES (382,'31380');
INSERT INTO merchant_shopids VALUES (383,'31373');

-- Mercenary Managers

INSERT INTO merchant_shopids VALUES (351021,'35102');
INSERT INTO merchant_shopids VALUES (351441,'35144');
INSERT INTO merchant_shopids VALUES (351861,'35186');
INSERT INTO merchant_shopids VALUES (352281,'35228');
INSERT INTO merchant_shopids VALUES (352761,'35276');
INSERT INTO merchant_shopids VALUES (353181,'35318');
INSERT INTO merchant_shopids VALUES (353651,'35365');

-- Fishermens

INSERT INTO merchant_shopids VALUES (3156200,'31562');
INSERT INTO merchant_shopids VALUES (3156300,'31563');
INSERT INTO merchant_shopids VALUES (3156400,'31564');
INSERT INTO merchant_shopids VALUES (3156500,'31565');
INSERT INTO merchant_shopids VALUES (3156600,'31566');
INSERT INTO merchant_shopids VALUES (3156700,'31567');
INSERT INTO merchant_shopids VALUES (3156800,'31568');
INSERT INTO merchant_shopids VALUES (3156900,'31569');
INSERT INTO merchant_shopids VALUES (3157000,'31570');
INSERT INTO merchant_shopids VALUES (3157100,'31571');
INSERT INTO merchant_shopids VALUES (3157200,'31572');
INSERT INTO merchant_shopids VALUES (3157300,'31573');
INSERT INTO merchant_shopids VALUES (3157400,'31574');
INSERT INTO merchant_shopids VALUES (3157500,'31575');
INSERT INTO merchant_shopids VALUES (3157600,'31576');
INSERT INTO merchant_shopids VALUES (3157700,'31577');
INSERT INTO merchant_shopids VALUES (3157800,'31578');
INSERT INTO merchant_shopids VALUES (3157900,'31579');
INSERT INTO merchant_shopids VALUES (3169600,'31696');
INSERT INTO merchant_shopids VALUES (3169700,'31697');
INSERT INTO merchant_shopids VALUES (3198900,'31989');
INSERT INTO merchant_shopids VALUES (3234800,'32348');

-- GM Shops

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 (1020,'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 (9001,'gm');
INSERT INTO merchant_shopids VALUES (9002,'gm');
INSERT INTO merchant_shopids VALUES (9003,'gm');
INSERT INTO merchant_shopids VALUES (9004,'gm');
INSERT INTO merchant_shopids VALUES (9005,'gm');
INSERT INTO merchant_shopids VALUES (9006,'gm');
INSERT INTO merchant_shopids VALUES (9007,'gm');
INSERT INTO merchant_shopids VALUES (9008,'gm');
INSERT INTO merchant_shopids VALUES (9009,'gm');
INSERT INTO merchant_shopids VALUES (9010,'gm');
INSERT INTO merchant_shopids VALUES (9011,'gm');
INSERT INTO merchant_shopids VALUES (9012,'gm');
INSERT INTO merchant_shopids VALUES (9013,'gm');
INSERT INTO merchant_shopids VALUES (9014,'gm');
INSERT INTO merchant_shopids VALUES (9015,'gm');
INSERT INTO merchant_shopids VALUES (9016,'gm');
INSERT INTO merchant_shopids VALUES (9017,'gm');
INSERT INTO merchant_shopids VALUES (9018,'gm');
INSERT INTO merchant_shopids VALUES (9019,'gm');
INSERT INTO merchant_shopids VALUES (9020,'gm');
INSERT INTO merchant_shopids VALUES (9021,'gm');
INSERT INTO merchant_shopids VALUES (9022,'gm');
INSERT INTO merchant_shopids VALUES (9023,'gm');
INSERT INTO merchant_shopids VALUES (9024,'gm');
INSERT INTO merchant_shopids VALUES (9025,'gm');
INSERT INTO merchant_shopids VALUES (9026,'gm');
INSERT INTO merchant_shopids VALUES (9027,'gm');
INSERT INTO merchant_shopids VALUES (9028,'gm');
INSERT INTO merchant_shopids VALUES (9029,'gm');
INSERT INTO merchant_shopids VALUES (9030,'gm');
INSERT INTO merchant_shopids VALUES (9031,'gm');
INSERT INTO merchant_shopids VALUES (9032,'gm');
INSERT INTO merchant_shopids VALUES (9033,'gm');
INSERT INTO merchant_shopids VALUES (9034,'gm');
INSERT INTO merchant_shopids VALUES (9035,'gm');
INSERT INTO merchant_shopids VALUES (9036,'gm');
INSERT INTO merchant_shopids VALUES (9037,'gm');
INSERT INTO merchant_shopids VALUES (9038,'gm');
INSERT INTO merchant_shopids VALUES (9039,'gm');
INSERT INTO merchant_shopids VALUES (9040,'gm');
INSERT INTO merchant_shopids VALUES (9041,'gm');
INSERT INTO merchant_shopids VALUES (9042,'gm');
INSERT INTO merchant_shopids VALUES (9043,'gm');
INSERT INTO merchant_shopids VALUES (9044,'gm');
INSERT INTO merchant_shopids VALUES (9045,'gm');
INSERT INTO merchant_shopids VALUES (9046,'gm');
INSERT INTO merchant_shopids VALUES (9047,'gm');
INSERT INTO merchant_shopids VALUES (9048,'gm');
INSERT INTO merchant_shopids VALUES (9049,'gm');
INSERT INTO merchant_shopids VALUES (9050,'gm');
INSERT INTO merchant_shopids VALUES (9051,'gm');
INSERT INTO merchant_shopids VALUES (9052,'gm');
INSERT INTO merchant_shopids VALUES (9053,'gm');
INSERT INTO merchant_shopids VALUES (9054,'gm');
INSERT INTO merchant_shopids VALUES (9055,'gm');
INSERT INTO merchant_shopids VALUES (9056,'gm');
INSERT INTO merchant_shopids VALUES (9057,'gm');
INSERT INTO merchant_shopids VALUES (9058,'gm');
INSERT INTO merchant_shopids VALUES (9059,'gm');
INSERT INTO merchant_shopids VALUES (9060,'gm');
INSERT INTO merchant_shopids VALUES (9061,'gm');
INSERT INTO merchant_shopids VALUES (9062,'gm');
INSERT INTO merchant_shopids VALUES (9063,'gm');
INSERT INTO merchant_shopids VALUES (9064,'gm');
INSERT INTO merchant_shopids VALUES (9065,'gm');
INSERT INTO merchant_shopids VALUES (9066,'gm');
INSERT INTO merchant_shopids VALUES (9067,'gm');
INSERT INTO merchant_shopids VALUES (9068,'gm');
INSERT INTO merchant_shopids VALUES (9069,'gm');
INSERT INTO merchant_shopids VALUES (9070,'gm');
INSERT INTO merchant_shopids VALUES (9071,'gm');
INSERT INTO merchant_shopids VALUES (9072,'gm');
INSERT INTO merchant_shopids VALUES (9073,'gm');
INSERT INTO merchant_shopids VALUES (9074,'gm');
INSERT INTO merchant_shopids VALUES (9075,'gm');
INSERT INTO merchant_shopids VALUES (9076,'gm');
INSERT INTO merchant_shopids VALUES (9077,'gm');
INSERT INTO merchant_shopids VALUES (9078,'gm');
INSERT INTO merchant_shopids VALUES (9079,'gm');
INSERT INTO merchant_shopids VALUES (9080,'gm');
INSERT INTO merchant_shopids VALUES (9081,'gm');
INSERT INTO merchant_shopids VALUES (9082,'gm');
INSERT INTO merchant_shopids VALUES (9083,'gm');
INSERT INTO merchant_shopids VALUES (9084,'gm');
INSERT INTO merchant_shopids VALUES (9085,'gm');
INSERT INTO merchant_shopids VALUES (9086,'gm');
INSERT INTO merchant_shopids VALUES (9087,'gm');
INSERT INTO merchant_shopids VALUES (9088,'gm');
INSERT INTO merchant_shopids VALUES (9089,'gm');
INSERT INTO merchant_shopids VALUES (9090,'gm');
INSERT INTO merchant_shopids VALUES (9091,'gm');
INSERT INTO merchant_shopids VALUES (9092,'gm');
INSERT INTO merchant_shopids VALUES (9093,'gm');
INSERT INTO merchant_shopids VALUES (9094,'gm');
INSERT INTO merchant_shopids VALUES (9095,'gm');
INSERT INTO merchant_shopids VALUES (9096,'gm');
INSERT INTO merchant_shopids VALUES (9097,'gm');
INSERT INTO merchant_shopids VALUES (9098,'gm');
INSERT INTO merchant_shopids VALUES (9099,'gm');
INSERT INTO merchant_shopids VALUES (9100,'gm');
INSERT INTO merchant_shopids VALUES (9101,'gm');
INSERT INTO merchant_shopids VALUES (9102,'gm');
INSERT INTO merchant_shopids VALUES (9103,'gm');
INSERT INTO merchant_shopids VALUES (9104,'gm');
INSERT INTO merchant_shopids VALUES (9105,'gm');
INSERT INTO merchant_shopids VALUES (9106,'gm');
INSERT INTO merchant_shopids VALUES (9107,'gm');
INSERT INTO merchant_shopids VALUES (9108,'gm');
INSERT INTO merchant_shopids VALUES (9109,'gm');
INSERT INTO merchant_shopids VALUES (9110,'gm');
INSERT INTO merchant_shopids VALUES (9111,'gm');
INSERT INTO merchant_shopids VALUES (9112,'gm');
INSERT INTO merchant_shopids VALUES (9113,'gm');
INSERT INTO merchant_shopids VALUES (9114,'gm');
INSERT INTO merchant_shopids VALUES (9115,'gm');
INSERT INTO merchant_shopids VALUES (9116,'gm');
INSERT INTO merchant_shopids VALUES (9117,'gm');
INSERT INTO merchant_shopids VALUES (9118,'gm');
INSERT INTO merchant_shopids VALUES (9119,'gm');
INSERT INTO merchant_shopids VALUES (9120,'gm');
INSERT INTO merchant_shopids VALUES (9121,'gm');
INSERT INTO merchant_shopids VALUES (9122,'gm');
INSERT INTO merchant_shopids VALUES (9123,'gm');
INSERT INTO merchant_shopids VALUES (9124,'gm');
INSERT INTO merchant_shopids VALUES (9125,'gm');
INSERT INTO merchant_shopids VALUES (9126,'gm');
INSERT INTO merchant_shopids VALUES (9127,'gm');
INSERT INTO merchant_shopids VALUES (9128,'gm');
INSERT INTO merchant_shopids VALUES (9148,'gm');
INSERT INTO merchant_shopids VALUES (9149,'gm');
INSERT INTO merchant_shopids VALUES (9150,'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 (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 (71021,'gm');
INSERT INTO merchant_shopids VALUES (71022,'gm');
INSERT INTO merchant_shopids VALUES (71023,'gm');
INSERT INTO merchant_shopids VALUES (71024,'gm');
INSERT INTO merchant_shopids VALUES (71025,'gm');
INSERT INTO merchant_shopids VALUES (71026,'gm');
INSERT INTO merchant_shopids VALUES (71027,'gm');
INSERT INTO merchant_shopids VALUES (71028,'gm');
INSERT INTO merchant_shopids VALUES (71029,'gm');
INSERT INTO merchant_shopids VALUES (71030,'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 (300527,'gm');
INSERT INTO merchant_shopids VALUES (300528,'gm');
INSERT INTO merchant_shopids VALUES (300529,'gm');
INSERT INTO merchant_shopids VALUES (300530,'gm');
INSERT INTO merchant_shopids VALUES (300531,'gm');
INSERT INTO merchant_shopids VALUES (300532,'gm');
INSERT INTO merchant_shopids VALUES (300533,'gm');
INSERT INTO merchant_shopids VALUES (300534,'gm');
INSERT INTO merchant_shopids VALUES (300535,'gm');
INSERT INTO merchant_shopids VALUES (300536,'gm');
INSERT INTO merchant_shopids VALUES (300537,'gm');
INSERT INTO merchant_shopids VALUES (300538,'gm');
INSERT INTO merchant_shopids VALUES (300539,'gm');
INSERT INTO merchant_shopids VALUES (300540,'gm');
INSERT INTO merchant_shopids VALUES (300541,'gm');
INSERT INTO merchant_shopids VALUES (300522,'gm');
INSERT INTO merchant_shopids VALUES (300511,'gm');
INSERT INTO merchant_shopids VALUES (300510,'gm');
INSERT INTO merchant_shopids VALUES (300410,'gm');
INSERT INTO merchant_shopids VALUES (300542,'gm');
INSERT INTO merchant_shopids VALUES (71031,'gm');
INSERT INTO merchant_shopids VALUES (71032,'gm');
INSERT INTO merchant_shopids VALUES (9151,'gm');
INSERT INTO merchant_shopids VALUES (9152,'gm');
INSERT INTO merchant_shopids VALUES (9153,'gm');
INSERT INTO merchant_shopids VALUES (9154,'gm');
INSERT INTO merchant_shopids VALUES (9155,'gm');
INSERT INTO merchant_shopids VALUES (9156,'gm');
INSERT INTO merchant_shopids VALUES (9157,'gm');
INSERT INTO merchant_shopids VALUES (9158,'gm');
INSERT INTO merchant_shopids VALUES (9159,'gm');
INSERT INTO merchant_shopids VALUES (9160,'gm');
INSERT INTO merchant_shopids VALUES (9161,'gm');
--
-- Castle 
--
INSERT INTO `merchant_shopids` VALUES (335103, '35103');
INSERT INTO `merchant_shopids` VALUES (335145, '35145');
INSERT INTO `merchant_shopids` VALUES (335187, '35187');
INSERT INTO `merchant_shopids` VALUES (335229, '35229');
INSERT INTO `merchant_shopids` VALUES (335230, '35230');
INSERT INTO `merchant_shopids` VALUES (335231, '35231');
INSERT INTO `merchant_shopids` VALUES (335277, '35277');
INSERT INTO `merchant_shopids` VALUES (335319, '35319');
INSERT INTO `merchant_shopids` VALUES (335366, '35366');
INSERT INTO `merchant_shopids` VALUES (335512, '35512');
INSERT INTO `merchant_shopids` VALUES (335558, '35558');
INSERT INTO `merchant_shopids` VALUES (335644, '35644');
INSERT INTO `merchant_shopids` VALUES (335645, '35645');
--
-- Castles Item creation
--
INSERT INTO merchant_shopids VALUES (351001,'35100');
INSERT INTO merchant_shopids VALUES (351421,'35142');
INSERT INTO merchant_shopids VALUES (351841,'35184');
INSERT INTO merchant_shopids VALUES (352261,'35226');
INSERT INTO merchant_shopids VALUES (352741,'35274');
INSERT INTO merchant_shopids VALUES (353161,'35316');
INSERT INTO merchant_shopids VALUES (353631,'35363');
INSERT INTO merchant_shopids VALUES (355091,'35509');
INSERT INTO merchant_shopids VALUES (355551,'35555');
--
-- Clan Halls Item creation
--
INSERT INTO merchant_shopids VALUES (135445, '35445');
INSERT INTO merchant_shopids VALUES (235445, '35445');
INSERT INTO merchant_shopids VALUES (335445, '35445');
INSERT INTO merchant_shopids VALUES (135453, '35453');
INSERT INTO merchant_shopids VALUES (235453, '35453');
INSERT INTO merchant_shopids VALUES (335453, '35453');
INSERT INTO merchant_shopids VALUES (135455, '35455');
INSERT INTO merchant_shopids VALUES (235455, '35455');
INSERT INTO merchant_shopids VALUES (335455, '35455');
INSERT INTO merchant_shopids VALUES (135451, '35451');
INSERT INTO merchant_shopids VALUES (235451, '35451');
INSERT INTO merchant_shopids VALUES (335451, '35451');
INSERT INTO merchant_shopids VALUES (135457, '35457');
INSERT INTO merchant_shopids VALUES (235457, '35457');
INSERT INTO merchant_shopids VALUES (335457, '35457');
INSERT INTO merchant_shopids VALUES (135459, '35459');
INSERT INTO merchant_shopids VALUES (235459, '35459');
INSERT INTO merchant_shopids VALUES (335459, '35459');
INSERT INTO merchant_shopids VALUES (135383, '35383');
INSERT INTO merchant_shopids VALUES (235383, '35383');
INSERT INTO merchant_shopids VALUES (335383, '35383');
INSERT INTO merchant_shopids VALUES (135398, '35398');
INSERT INTO merchant_shopids VALUES (235398, '35398');
INSERT INTO merchant_shopids VALUES (335398, '35398');
INSERT INTO merchant_shopids VALUES (135400, '35400');
INSERT INTO merchant_shopids VALUES (235400, '35400');
INSERT INTO merchant_shopids VALUES (335400, '35400');
INSERT INTO merchant_shopids VALUES (135392, '35392');
INSERT INTO merchant_shopids VALUES (235392, '35392');
INSERT INTO merchant_shopids VALUES (335392, '35392');
INSERT INTO merchant_shopids VALUES (135394, '35394');
INSERT INTO merchant_shopids VALUES (235394, '35394');
INSERT INTO merchant_shopids VALUES (335394, '35394');
INSERT INTO merchant_shopids VALUES (135396, '35396');
INSERT INTO merchant_shopids VALUES (235396, '35396');
INSERT INTO merchant_shopids VALUES (335396, '35396');
INSERT INTO merchant_shopids VALUES (135384, '35384');
INSERT INTO merchant_shopids VALUES (235384, '35384');
INSERT INTO merchant_shopids VALUES (335384, '35384');
INSERT INTO merchant_shopids VALUES (135390, '35390');
INSERT INTO merchant_shopids VALUES (235390, '35390');
INSERT INTO merchant_shopids VALUES (335390, '35390');
INSERT INTO merchant_shopids VALUES (135386, '35386');
INSERT INTO merchant_shopids VALUES (235386, '35386');
INSERT INTO merchant_shopids VALUES (335386, '35386');
INSERT INTO merchant_shopids VALUES (135388, '35388');
INSERT INTO merchant_shopids VALUES (235388, '35388');
INSERT INTO merchant_shopids VALUES (335388, '35388');
INSERT INTO merchant_shopids VALUES (135407, '35407');
INSERT INTO merchant_shopids VALUES (235407, '35407');
INSERT INTO merchant_shopids VALUES (335407, '35407');
INSERT INTO merchant_shopids VALUES (135403, '35403');
INSERT INTO merchant_shopids VALUES (235403, '35403');
INSERT INTO merchant_shopids VALUES (335403, '35403');
INSERT INTO merchant_shopids VALUES (135405, '35405');
INSERT INTO merchant_shopids VALUES (235405, '35405');
INSERT INTO merchant_shopids VALUES (335405, '35405');
INSERT INTO merchant_shopids VALUES (135421, '35421');
INSERT INTO merchant_shopids VALUES (235421, '35421');
INSERT INTO merchant_shopids VALUES (335421, '35421');
INSERT INTO merchant_shopids VALUES (135439, '35439');
INSERT INTO merchant_shopids VALUES (235439, '35439');
INSERT INTO merchant_shopids VALUES (335439, '35439');
INSERT INTO merchant_shopids VALUES (135441, '35441');
INSERT INTO merchant_shopids VALUES (235441, '35441');
INSERT INTO merchant_shopids VALUES (335441, '35441');
INSERT INTO merchant_shopids VALUES (135443, '35443');
INSERT INTO merchant_shopids VALUES (235443, '35443');
INSERT INTO merchant_shopids VALUES (335443, '35443');
INSERT INTO merchant_shopids VALUES (135447, '35447');
INSERT INTO merchant_shopids VALUES (235447, '35447');
INSERT INTO merchant_shopids VALUES (335447, '35447');
INSERT INTO merchant_shopids VALUES (135449, '35449');
INSERT INTO merchant_shopids VALUES (235449, '35449');
INSERT INTO merchant_shopids VALUES (335449, '35449');
INSERT INTO merchant_shopids VALUES (135467, '35467');
INSERT INTO merchant_shopids VALUES (235467, '35467');
INSERT INTO merchant_shopids VALUES (335467, '35467');
INSERT INTO merchant_shopids VALUES (135465, '35465');
INSERT INTO merchant_shopids VALUES (235465, '35465');
INSERT INTO merchant_shopids VALUES (335465, '35465');
INSERT INTO merchant_shopids VALUES (135463, '35463');
INSERT INTO merchant_shopids VALUES (235463, '35463');
INSERT INTO merchant_shopids VALUES (335463, '35463');
INSERT INTO merchant_shopids VALUES (135461, '35461');
INSERT INTO merchant_shopids VALUES (235461, '35461');
INSERT INTO merchant_shopids VALUES (335461, '35461');
INSERT INTO merchant_shopids VALUES (335566, '35566');
INSERT INTO merchant_shopids VALUES (235566, '35566');
INSERT INTO merchant_shopids VALUES (135566, '35566');
INSERT INTO merchant_shopids VALUES (335568, '35568');
INSERT INTO merchant_shopids VALUES (235568, '35568');
INSERT INTO merchant_shopids VALUES (135568, '35568');
INSERT INTO merchant_shopids VALUES (335570, '35570');
INSERT INTO merchant_shopids VALUES (235570, '35570');
INSERT INTO merchant_shopids VALUES (135570, '35570');
INSERT INTO merchant_shopids VALUES (335572, '35572');
INSERT INTO merchant_shopids VALUES (235572, '35572');
INSERT INTO merchant_shopids VALUES (135572, '35572');
INSERT INTO merchant_shopids VALUES (335574, '35574');
INSERT INTO merchant_shopids VALUES (235574, '35574');
INSERT INTO merchant_shopids VALUES (135574, '35574');
INSERT INTO merchant_shopids VALUES (335576, '35576');
INSERT INTO merchant_shopids VALUES (235576, '35576');
INSERT INTO merchant_shopids VALUES (135576, '35576');
INSERT INTO merchant_shopids VALUES (335578, '35578');
INSERT INTO merchant_shopids VALUES (235578, '35578');
INSERT INTO merchant_shopids VALUES (135578, '35578');
INSERT INTO merchant_shopids VALUES (235580, '35580');
INSERT INTO merchant_shopids VALUES (135580, '35580');
INSERT INTO merchant_shopids VALUES (335580, '35580');
INSERT INTO merchant_shopids VALUES (335582, '35582');
INSERT INTO merchant_shopids VALUES (235582, '35582');
INSERT INTO merchant_shopids VALUES (135582, '35582');
INSERT INTO merchant_shopids VALUES (135584, '35584');
INSERT INTO merchant_shopids VALUES (235584, '35584');
INSERT INTO merchant_shopids VALUES (335584, '35584');
INSERT INTO merchant_shopids VALUES (335586, '35586');
INSERT INTO merchant_shopids VALUES (135586, '35586');
INSERT INTO merchant_shopids VALUES (235586, '35586');
INSERT INTO merchant_shopids VALUES (355111, '35511');
INSERT INTO merchant_shopids VALUES (355571, '35557');