хм .  Молодец  , пасиб.

Напишите плиз Ид всех квестовых вещей.

ХЗ

магазинов нет потомучто есть тарговцы!!!!и они все продают вот их иды
разобраться просто то есть мущины врятле будут в магическо шопе ну а женщины врятле будут в оружейном.
расположение определяется расое то есть дарк ельв будет в дарк ельвен вилиадж
ну а человек и так далее по заселености города. ельфы и эльфов, гномы у гномов
чтоб создать зайди под админо и так чтоб ник был цветным и набей //admin
в меню выбери создать нпс и набери его ид и жми свамп
EverybodyHasAdminRights = False поменяй на True
чтоб быть админом

Trash значит GM
Торговец

!!!!!список может быть не правильый!!!!!!!!
поксперементий в их созданий как написано вышеINSERT

INTO `npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`) VALUES

(7001,7001,'Lector',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7002,7002,'Jackson',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7003,7003,'Silvia',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7004,7004,'Katerina',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7052,7052,'trash',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7053,7053,'trash',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7060,7060,'Sabrin',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7061,7061,'Casey',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7062,7062,'Sonia',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7063,7063,'Lara',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7081,7081,'Helvetia',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7082,7082,'Denkus',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7084,7084,'Graham',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7085,7085,'Stanford',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7087,7087,'Peta',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7088,7088,'Radia',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7090,7090,'Sandra',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7091,7091,'Ellie',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7093,7093,'Groot',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7094,7094,'Gentler',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7097,7097,'Galladucci',0,'',0,'NPC.a_traderA_MDwarf',8,17,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7098,7098,'Alexandria',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7099,7099,'trash',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7100,7100,'trash',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7135,7135,'Iria',0,'',0,'NPC.a_trader_Fdarkelf',8,24.5,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7136,7136,'Payne',0,'',0,'NPC.a_trader_MDarkElf',8,22.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7137,7137,'Vollodos',0,'',0,'NPC.a_trader_MDarkElf',8,22.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7138,7138,'Minaless',0,'',0,'NPC.a_trader_Fdarkelf',8,24.5,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7139,7139,'Dorankus',0,'',0,'NPC.a_trader_MDarkElf',8,22.5,70,'male','L2Warehouse',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7140,7140,'Erviante',0,'',0,'NPC.a_trader_MDarkElf',8,22.5,70,'male','L2Warehouse',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7147,7147,'Unoren',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7148,7148,'Ariel',0,'',0,'NPC.a_trader_FElf',8,24,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0)  (7149,7149,'Creamees',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7150,7150,'Herbiel',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7151,7151,'Chad',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Warehouse',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7163,7163,'Rex',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7164,7164,'Ian',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7165,7165,'Ralford',0,'',0,'NPC.a_trader_FElf',8,24,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7166,7166,'Wesley',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7167,7167,'trash',0,'',0,'NPC.a_traderA_MDwarf',8,17,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7168,7168,'trash',0,'',0,'NPC.a_traderA_MDwarf',8,17,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7178,7178,'Zenkin',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7179,7179,'Raudia',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7180,7180,'Sara',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7181,7181,'Galibredo',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7207,7207,'Arodin',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7208,7208,'Damion',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7209,7209,'Colleen',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7211,7211,'trash',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7212,7212,'trash',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7213,7213,'trash',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7225,7225,'trash',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7226,7226,'trash',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7227,7227,'trash',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
7230,7230,'Edroc',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7231,7231,'Garette',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7234,7234,'trash',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7235,7235,'trash',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7253,7253,'Simplon',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7254,7254,'Harmony',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7292,7292,'trash',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7294,7294,'Varan',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7301,7301,'Hally',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7302,7302,'trash',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7313,7313,'Asha',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7314,7314,'Nestle',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7315,7315,'Poesia',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7321,7321,'Sydnia',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7420,7420,'Tyra',0,'',0,'NPC.a_trader_Fdarkelf',8,24.5,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7436,7436,'Sarien',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7437,7437,'Rolento',0,'',0,'NPC.e_traderB_MDwarf',8,17,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7479,7479,'trash',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7480,7480,'trash',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7481,7481,'trash',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7482,7482,'trash',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7516,7516,'Reep',0,'',0,'NPC.a_traderA_MDwarf',8,17,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7517,7517,'Shari',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7518,7518,'Garita',0,'',0,'NPC.e_traderB_MDwarf',8,17,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7519,7519,'Mion',0,'',0,'NPC.e_traderB_FDwarf',7,18.5,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7532,7532,'Spiron',0,'',0,'NPC.e_traderA_master_MDwarf',8,17,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7533,7533,'Balanki',0,'',0,'NPC.e_traderB_master_MDwarf',8,17,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7555,7555,'Torocco',0,'',0,'NPC.a_traderA_MDwarf',8,17,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7558,7558,'Jakal',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7559,7559,'Kunai',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7560,7560,'Uska',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7561,7561,'Papuma',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7562,7562,'Grookin',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Warehouse',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7563,7563,'Imantu',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Warehouse',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7564,7564,'Sumari',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7570,7570,'Karukia',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Trainer',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7586,7586,'AnaiZuNeruga',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7588,7588,'Takia Zu Duda-Mara',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7603,7603,'trash',0,'',0,'NPC.a_traderB_FHuman',8,25.3,70,'male','L2Teleporter',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7605,7605,'Temporary Teleporter',0,'',0,'NPC.a_trader_Fdarkelf',8,24.5,70,'male','L2Teleporter',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7606,7606,'trash',0,'',0,'NPC.e_trader_FOrc',8,24,70,'male','L2Teleporter',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7607,7607,'trash',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,70,'male','L2Teleporter',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7648,7648,'Santiago',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7658,7658,'Gupu',0,'',0,'NPC.a_traderA_MDwarf',8,17,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
  (7659,7659,'Orphan Girl',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7669,7669,'Kakan',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
Kamur',0,'',0,'NPC.e_trader_Morc_death',22,23.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7681,7681,'Karia',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2VillageMaster',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7684,7684,'Viktor',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7731,7731,'Martin',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),

P.S
список не полный
полный будет завтра

ты чуть не то выложил а я протормозил нада не тока сами НПС но и номера буй листов к ним так как шмот загоняется в буй лист ))

Как видишь появились акционеры мамоны и маноры не смущайся они все что то продают
то есть то что он лотерей тикер не значит что он не чего не продает ну как и все торговцы))))))))

ОНИ ВСЕ ТАРГОВЦЫ

но отличее между торговцом Глудио и Гирана минемальны так как они что скореевсего продают одно и тоже!!

(7737,7737,'Morgan',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7738,7738,'Matild',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7744,7744,'Grey',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7768,7768,'Auctioneer',0,'',0,'NPC.a_trader_FElf',8,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7770,7770,'Auctioneer',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7771,7771,'Auctioneer',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7792,7792,'Lowell',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7793,7793,'Paranos',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7794,7794,'Klingel',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7795,7795,'Keffer',0,'',0,'NPC.a_trader_MElf',6,24.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7811,7811,'Baraha',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7812,7812,'Vanhal',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Npc',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7827,7827,'Lundy',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7828,7828,'Waters',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7829,7829,'Cooper',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0), (7830,7830,'Joey',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7831,7831,'Nelson',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7837,7837,'Woodrow',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7838,7838,'Woodley',0,'',0,'NPC.a_traderA_MHuman',10,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7839,7839,'Holly',0,'',0,'NPC.a_traderA_FHuman',7,23,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7841,7841,'Carson',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7842,7842,'Alexis',0,'',0,'NPC.a_trader_FElf',8,24,70,'female','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7860,7860,'Flownia',0,'',0,'NPC.a_trader_FElf',8,24,70,'female','L2Trainer',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7866,7866,'Marestella',0,'',0,'NPC.e_trader_FOrc',8,24,70,'female','L2Trainer',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7867,7867,'Reva',0,'',0,'NPC.e_trader_MOrc',8,23.5,70,'male','L2Trainer',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7869,7869,'Lemper',0,'',0,'NPC.a_traderB_MHuman',8,24,70,'male','L2Merchant',40,3862,1494,40,43,30,21,20,10,5879,590,1444,514,760,381,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7890,7890,'Espen',0,'',0,'NPC.a_trader_MElf',6,24.5,40,'male','L2Merchant',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7891,7891,'Verona',0,'',0,'NPC.a_traderB_FHuman',8,25.3,40,'male','L2Merchant',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),  (7892,7892,'Enverun',0,'',0,'NPC.a_traderA_MHuman',10,24,40,'male','L2Merchant',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7893,7893,'Payel',0,'',0,'NPC.a_trader_FElf',8,24,40,'male','L2Merchant',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7914,7914,'Sorbo',0,'',0,'NPC.e_trader_FOrc',8,24,40,'male','L2Trainer',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
7931,7931,'Bentley',0,'',0,'NPC.a_traderA_MDwarf',8,17,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7947,7947,'Rerikya',0,'',0,'NPC.e_trader_FOrc',8,24,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7968,7968,'Jennifer',0,'',0,'NPC.e_trader_FOrc',8,24,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(7991,7991,'Lottery Ticket Seller',0,'',0,'NPC.a_trader_MElf',6,24.5,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
  (7992,7992,'Lottery Ticket Seller',0,'',0,'NPC.a_trader_MDarkElf',8,22.5,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
  (7993,7993,'Lottery Ticket Seller',0,'',0,'NPC.a_traderA_MDwarf',8,17,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),                                                                                                                                                            (7994,7994,'Lottery Ticket Seller',0,'',0,'NPC.e_trader_MOrc',8,23.5,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8043,8043,'Octavia',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8046,8046,'Marsden',0,'',0,'NPC.a_traderC_Mhuman',8,23,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),  (8047,8047,'Kelly',0,'',0,'NPC.a_traderC_Mhuman',8,23.5,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),  (8048,8048,'McDermott',0,'',0,'NPC.a_traderC_Mhuman',8,23,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0), (8049,8049,'Pepper',0,'',0,'NPC.a_traderC_Mhuman',8,23,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8050,8050,'Thora',0,'',0,'NPC.a_traderC_Mhuman',8,23.5,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8051,8051,'Keach',0,'',0,'NPC.a_traderC_Mhuman',8,23,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0), (8052,8052,'Heid',0,'',0,'NPC.a_traderC_Mhuman',8,23,40,'male','L2SymbolMaker',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8059,8059,'Manor Manager',0,'',0,'NPC.a_trader_MElf',6,24.5,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8067,8067,'Rood',0,'',0,'NPC.a_traderB_MHuman',8,24,40,'male','L2Merchant',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8074,8074,'Corpse of Hutaku',0,'',0,'NPC.e_trader_Morc_death',22,23.5,40,'male','L2Npc',40,1527,531,40,21,30,20,43,10,1921,124,298,221,127,163,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8092,8092,'Black Marketeer of Mammon',0,'',0,'NPC.black_market_trader_MDwarf',8,18,75,'male','L2SignsPriest',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),
  (8113,8113,'Merchant of Mammon',0,'',0,'NPC.black_market_trader_MDwarf_set',22,18,75,'male','L2SignsPriest',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8162,8162,'Grad',0,'',0,'NPC.a_traderB_MHuman',8,24,75,'male','L2Npc',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),  (8163,8163,'Bryce',0,'',0,'NPC.a_traderB_MHuman',8,24,75,'male','L2Npc',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),  (8164,8164,'Hodler',0,'',0,'NPC.a_traderB_MHuman',8,24,75,'male','L2Npc',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),  (8165,8165,'Finrod',0,'',0,'NPC.a_trader_MElf',6,24.5,75,'male','L2Npc',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),  (8166,8166,'Tate',0,'',0,'NPC.a_traderB_MHuman',8,24,75,'male','L2Npc',40,4229,1674,40,21,30,20,43,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8211,8211,'Race Track Guide',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,75,'female','L2Teleporter',40,4229,1674,40,43,30,21,20,10,6742,730,1714,572,926,425,253,0,253,0,0,0,80,120,NULL,0,0,0),
(8256,8256,'Leon',0,'',0,'NPC.a_traderC_Mhuman',8,22,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8257,8257,'Veronica',0,'',0,'NPC.a_traderD_Fhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8260,8260,'Judith',0,'',0,'NPC.a_traderD_Fhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8262,8262,'Rupert',0,'',0,'NPC.a_traderD_Mhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8264,8264,'Olsun',0,'',0,'NPC.a_traderC_Mhuman',8,23,76,'male','L2SymbolMaker',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8269,8269,'Mona',0,'',0,'NPC.e_traderB_FDwarf',7,18,76,'male','L2VillageMaster',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8284,8284,'Elena',0,'',0,'NPC.a_traderD_Fhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8300,8300,'Drumond',0,'',0,'NPC.e_traderB_master_MDwarf',8,17,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8301,8301,'Nils',0,'',0,'NPC.a_traderD_Mhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8303,8303,'Alisha',0,'',0,'NPC.a_traderD_Fhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0), (8304,8304,'Astrid',0,'',0,'NPC.a_traderC_Fhuman',8,22.5,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),  (8305,8305,'Candice',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),  (8306,8306,'Natasha',0,'',0,'NPC.a_traderB_FHuman',8,24.5,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),  (8307,8307,'Weber',0,'',0,'NPC.a_traderD_Mhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),  (8308,8308,'Achim',0,'',0,'NPC.a_traderC_Mhuman',8,23,76,'male','L2SymbolMaker',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),  (8309,8309,'Woods',0,'',0,'NPC.a_traderD_Mhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8312,8312,'Durin',0,'',0,'NPC.a_traderA_MDwarf',8,17,76,'male','L2Warehouse',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),  (8313,8313,'Lunin',0,'',0,'NPC.e_traderB_MDwarf',8,17,76,'male','L2Warehouse',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8319,8319,'Hans',0,'',0,'NPC.e_traderB_master_MDwarf',8,17,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8338,8338,'Anton',0,'',0,'NPC.a_traderD_Mhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8351,8351,'Volker',0,'',0,'NPC.a_traderC_Mhuman',8,23,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8356,8356,'Remy',0,'',0,'NPC.a_traderB_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8358,8358,'Kasiel',0,'',0,'NPC.a_trader_MElf',6,24.5,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8361,8361,'Kreed',0,'',0,'NPC.a_trader_MDarkElf',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),  (8362,8362,'Tate',0,'',0,'NPC.a_traderA_MDwarf',8,17,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8366,8366,'Feed Seller',0,'',0,'NPC.a_traderD_Mhuman',8,25.3,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8386,8386,'Violet',0,'',0,'NPC.a_traderD_Fhuman',8,22,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),  (8387,8387,'Kurstin',0,'',0,'NPC.a_traderB_FHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0), (8388,8388,'Mina',0,'',0,'NPC.a_traderB_FHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8390,8390,'Dummy - Boy A',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
  (8391,8391,'Dummy  - Boy B',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
  (8392,8392,'Dummy  - Boy C',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
  (8393,8393,'Dummy - Boy D',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
  (8394,8394,'Dummy - Boy E',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8418,8418,'Rouke',0,'',0,'NPC.a_traderB_MHuman',8,25,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8423,8423,'Romas',0,'',0,'NPC.a_traderB_MHuman',8,25,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8435,8435,'Daeger',0,'',0,'NPC.e_traderA_master_MDwarf',8,17,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8441,8441,'Gordo',0,'',0,'NPC.e_traderB_master_MDwarf',8,17,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),  (8442,8442,'Kiki',0,'',0,'NPC.e_traderB_FDwarf',8,22,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8445,8445,'Shutner',0,'',0,'NPC.e_traderB_MDwarf',8,17,76,'male','L2Merchant',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8538,8538,'Ghost of Adventurer',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8556,8556,'Selina',0,'',0,'NPC.a_traderC_Fhuman',8,22.5,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,189,659,0,50,120,NULL,0,0,0),
(8584,8584,'Valentine',0,'',0,'NPC.e_traderB_MDwarf',8,17,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
(8587,8587,'Gedrik',0,'',0,'NPC.e_traderB_master_MDwarf',8,17,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,278,0,333,0,0,0,50,120,NULL,0,0,0),
  (8598,8598,'Medina Blackheart',0,'',0,'NPC.a_trader_Fdarkelf',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8612,8612,'Eternity Wanderer Staris',0,'',0,'NPC.a_trader_MElf',6,24.5,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8628,8628,'Lilly',0,'',0,'NPC.e_traderA_FDwarf',7,18.5,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),
(8639,8639,'Kain Van Halter',0,'',0,'NPC.a_traderA_MHuman',8,22,76,'male','L2Npc',40,4298,1710,40,21,30,20,43,10,6922,761,1770,584,962,434,253,0,333,0,0,0,80,120,NULL,0,0,0),

P.S все основные нпс перечислины

Тебе нужны дополнительные?
бай лист будет))

INSERT INTO `merchant_buylists` (`item_id`, `price`, `shop_id`, `order`) VALUES
  (1,883,75,1),
  (1,0,2001,1),
  (1,883,31,1),
  (1,883,81,1),
  (1,883,37,1),
  (1,883,83,1),
  (1,883,77,1),
  (1,883,1,1),
  (1,883,33,1),
  (1,883,39,1),
  (1,883,11,1),
  (2,156400,75,19),
  (2,149600,27,1),
  (2,0,2001,2),
  (2,176800,58,8),
  (2,163202,123,1),
  (2,149600,25,1),
  (2,163202,125,1),
  (2,156400,47,8),
  (2,156400,81,19),
  (2,156400,37,19),
  (2,156400,39,19),
  (2,156400,83,19),
  (2,163200,96,8),
  (2,163200,53,15),
  (2,156400,31,19),
  (2,156400,77,19),
  (2,163202,107,1),
  (2,156400,33,19),
  (2,204000,72,5),
  (2,163200,69,1),
  (2,156400,11,19),
  (2,163200,15,8),
  (2,163200,17,8),
  (2,163200,61,1),
  (2,156400,1,19),
  (2,163202,105,1),
  (3,14375,83,5),
  (3,14375,77,5),
  (3,14375,31,5),
  (3,14375,39,5),
  (3,14375,1,5),
  (3,14375,37,5),
  (3,14375,81,5),
  (3,14375,33,5),
  (3,14375,11,5),
  (3,15000,53,1),
  (3,14375,75,5),
  (3,0,2001,3),
  (4,883,81,2),
  (4,883,37,2),
  (4,883,75,2),
  (4,883,77,2),
  (4,883,33,2),
  (4,883,39,2),
  (4,883,1,2),
  (4,0,2009,1),
  (4,883,11,2),
  (4,883,83,2),
  (4,883,31,2),
  (5,0,2009,2),
  (5,14375,11,10),
  (5,14375,33,10),
  (5,15000,53,6),
  (5,14375,77,10),
  (5,14375,83,10),
  (5,14375,39,10),
  (5,14375,37,10),
  (5,14375,1,10),
  (5,14375,81,10),
  (5,14375,31,10),
  (5,14375,75,10),
  (6,0,2009,3),
  (7,0,2009,4),
  (7,883,78,1),
  (7,883,40,1),
  (7,883,34,1),
  (7,883,32,1),
  (7,883,82,1),
  (7,883,12,1),
  (7,883,2,1),
  (7,883,84,1),
  (7,883,76,1),
  (7,883,38,1),
  (8,14375,84,3),
  (8,14375,82,3),
  (8,14375,34,3),
  (8,0,2010,1),
  (8,14375,40,3),
  (8,14375,38,3),
  (8,14375,12,3),
  (8,14375,76,3),
  (8,14375,2,3),
  (8,14375,32,3),
  (8,15000,54,1),
  (8,14375,78,3),
  (9,62215,38,5),
  (9,62215,2,5),
  (9,62215,82,5),
  (9,62215,76,5),
  (9,70330,59,1),
  (9,62215,48,1),
  (9,0,2010,2),
  (9,64920,16,1),
  (9,62215,78,5),
  (9,64920,54,3),
  (9,62215,32,5),
  (9,64920,97,1),
  (9,62215,12,5),
  (9,62215,84,5),
  (9,81150,73,1),
  (9,62215,34,5),
  (9,64920,18,1),
  (9,62215,40,5),
  (10,0,2004,1),
  (11,883,1,3),
  (11,883,39,3),
  (11,883,75,3),
  (11,883,37,3),
  (11,0,2004,2),
  (11,883,33,3),
  (11,883,31,3),
  (11,883,81,3),
  (11,883,11,3),
  (11,883,83,3),
  (11,883,77,3),
  (12,0,2004,3),
  (12,14375,31,7),
  (12,14375,33,7),
  (12,14375,11,7),
  (12,14375,39,7),
  (12,14375,37,7),
  (12,14375,75,7),
  (12,14375,81,7),
  (12,14375,83,7),
  (12,14375,1,7),
  (12,15000,53,3),
  (12,14375,77,7),
  (13,883,33,4),
  (13,883,1,4),
  (13,883,11,4),
  (13,883,81,4),
  (13,883,31,4),
  (13,883,37,4),
  (13,883,77,4),
  (13,883,83,4),
  (13,883,39,4),
  (13,883,75,4),
  (13,0,2005,1),
  (14,14375,77,9),
  (14,14375,39,9),
  (14,14375,11,9),
  (14,14375,1,9),
  (14,14375,81,9),
  (14,14375,83,9),
  (14,0,2005,2),
  (14,14375,75,9),
  (14,14375,33,9),
  (14,14375,31,9),
  (14,15000,53,5),
  (14,14375,37,9),
  (15,0,2008,1),
  (15,163200,15,11),
  (15,163200,53,18),
  (15,176800,58,11),
  (15,156400,31,22),
  (15,156400,75,22),
  (15,163202,105,4),
  (15,204000,72,6),
  (15,163202,125,4),
  (15,149600,25,4),
  (15,163202,123,4),
  (15,163200,61,4),
  (15,163200,17,11),
  (15,149600,27,4),
  (15,156400,1,22),
  (15,156400,33,22),
  (15,156400,11,22),
  (15,163202,107,4),
  (15,156400,83,22),
  (15,163200,69,4),
  (15,156400,81,22),
  (15,163200,96,11),
  (15,163200,5800,4),
  (15,156400,37,22),
  (15,163200,5806,4),
  (15,156400,77,22),
  (15,156400,47,11),
  (15,156400,39,22),
  (16,292800,17,17),
  (16,292804,107,10),
  (16,292804,123,10),
  (16,280600,47,17),
  (16,268400,25,10),
  (16,268400,27,10),
  (16,292800,5806,10),
  (16,292804,125,10),
  (16,292800,69,10),
  (16,292800,96,17),
  (16,317200,58,17),
  (16,292800,53,24),
  (16,292800,15,17),
  (16,292800,5800,10),
  (16,0,2008,2),
  (16,292804,105,10),
  (16,292800,61,10),
  (17,2,117,10),
  (17,2,10,1),
  (17,2,5801,22),
  (17,2,64,13),
  (17,0,2005,51),
  (17,2,11,53),
  (17,2,15,59),
  (17,2,68,21),
  (17,2,16,37),
  (17,2,62,49),
  (17,2,12,37),
  (17,2,61,62),
  (17,2,13,14),
  (17,2,67,21),
  (17,3,71,14),
  (17,2,19,71),
  (17,3,72,28),
  (17,3,65,14),
  (17,2,18,37),
  (17,2,17,59),
  (17,2,70,49),
  (17,2,69,62),
  (17,2,50,25),
  (17,2,51,8),
  (17,2,80,14),
  (17,3,88,25),
  (17,2,35,14),
  (17,2,34,37),
  (17,2,77,53),
  (17,2,32,37),
  (17,2,96,29),
  (17,2,33,53),
  (17,2,79,14),
  (17,2,78,37),
  (17,2,40,37),
  (17,2,41,14),
  (17,2,83,57),
  (17,2,85,14),
  (17,2,39,53),
  (17,2,84,37),
  (17,2,81,57),
  (17,2,47,29),
  (17,2,48,13),
  (17,2,38,37),
  (17,2,82,37),
  (17,2,37,53),
  (17,2,26,28),
  (17,2,25,50),
  (17,3,22,1),
  (17,2,102,8),
  (17,2,28,28),
  (17,2,27,50),
  (17,3,58,29),
  (17,3,59,13),
  (17,2,20,71),
  (17,3,74,14),
  (17,3,73,21),
  (17,2,135,10),
  (17,2,97,13),
  (17,2,76,37),
  (17,2,55,37),
  (17,2,53,38),
  (17,2,54,13),
  (17,2,31,53),
  (17,2,98,31),
  (17,2,99,25),
  (17,2,101,1),
  (17,2,56,34),
  (17,2,75,53),
  (17,2,30,1),
  (17,2,1,53),
  (17,2,5807,22),
  (17,2,2,37),
  (18,45,39,34),
  (18,45,78,18),
  (18,45,32,18),
  (18,45,2,18),
  (18,45,77,34),
  (18,45,38,18),
  (18,45,84,18),
  (18,0,2011,1),
  (18,45,83,38),
  (18,45,82,18),
  (18,45,31,34),
  (18,45,40,18),
  (18,45,81,38),
  (18,45,75,34),
  (18,45,11,34),
  (18,47,56,12),
  (18,45,76,18),
  (18,45,34,18),
  (18,47,55,15),
  (18,45,1,34),
  (18,45,37,34),
  (18,45,33,34),
  (18,45,12,18),
  (19,734,84,19),
  (19,734,40,19),
  (19,734,33,35),
  (19,734,31,35),
  (19,734,38,19),
  (19,734,37,35),
  (19,734,34,19),
  (19,734,39,35),
  (19,734,32,19),
  (19,734,83,39),
  (19,766,55,16),
  (19,734,12,19),
  (19,734,77,35),
  (19,734,2,19),
  (19,734,76,19),
  (19,734,75,35),
  (19,734,1,35),
  (19,766,56,13),
  (19,734,11,35),
  (19,734,78,19),
  (19,734,81,39),
  (19,734,82,19),
  (19,0,2011,2),
  (20,3197,11,36),
  (20,3336,99,9),
  (20,0,2011,3),
  (20,3336,15,43),
  (20,3336,16,21),
  (20,3197,32,20),
  (20,3336,17,43),
  (20,3197,31,36),
  (20,3336,18,21),
  (20,3336,98,15),
  (20,3197,12,20),
  (20,3197,78,20),
  (20,3197,77,36),
  (20,3197,50,9),
  (20,3197,81,40),
  (20,3197,49,15),
  (20,3197,2,20),
  (20,3197,75,36),
  (20,3197,1,36),
  (20,3336,56,14),
  (20,3336,55,17),
  (20,3197,76,20),
  (20,3197,37,36),
  (20,3614,87,15),
  (20,3614,88,9),
  (20,3197,33,36),
  (20,3197,34,20),
  (20,3197,38,20),
  (20,3197,83,40),
  (20,3197,82,20),
  (20,3197,84,20),
  (20,3197,39,36),
  (20,3197,40,20),
  (21,169,75,24),
  (21,169,33,24),
  (21,169,39,24),
  (21,169,37,24),
  (21,0,1001,1),
  (21,169,77,24),
  (21,169,1,24),
  (21,169,83,28),
  (21,169,11,24),
  (21,169,81,28),
  (21,169,31,24),
  (22,2794,81,30),
  (22,2794,39,26),
  (22,2916,55,2),
  (22,0,1001,2),
  (22,2794,77,26),
  (22,2794,83,30),
  (22,2794,1,26),
  (22,2794,33,26),
  (22,2794,11,26),
  (22,2794,31,26),
  (22,2794,37,26),
  (22,2794,75,26),
  (23,9154,37,28),
  (23,9154,81,33),
  (23,9552,98,2),
  (23,9552,15,30),
  (23,9154,83,33),
  (23,9154,31,28),
  (23,0,1001,3),
  (23,9154,33,28),
  (23,10348,87,2),
  (23,9154,39,28),
  (23,9154,1,29),
  (23,9154,11,29),
  (23,9154,75,29),
  (23,9552,17,30),
  (23,9154,49,2),
  (23,9552,55,4),
  (23,9154,77,29),
  (24,24360,129,3),
  (24,24360,55,8),
  (24,23345,11,32),
  (24,23345,75,32),
  (24,24360,15,33),
  (24,24360,17,33),
  (24,24360,61,31),
  (24,24360,98,5),
  (24,24360,69,31),
  (24,23345,1,32),
  (24,23345,33,32),
  (24,23345,31,32),
  (24,22330,5,3),
  (24,24360,111,3),
  (24,0,1001,4),
  (24,23345,39,32),
  (24,23345,83,36),
  (24,23345,49,5),
  (24,23345,81,36),
  (24,24360,127,3),
  (24,23345,77,32),
  (24,23345,37,32),
  (24,24360,5802,4),
  (24,26390,87,5),
  (24,24360,5804,4),
  (24,22330,3,3),
  (24,24360,109,3),
  (25,0,1001,5),
  (25,38160,98,7),
  (25,38160,127,5),
  (25,38160,15,35),
  (25,38160,17,35),
  (25,34980,3,5),
  (25,38160,109,5),
  (25,36570,49,7),
  (25,38160,69,33),
  (25,38160,61,33),
  (25,38160,5804,6),
  (25,38160,111,5),
  (25,38160,129,5),
  (25,34980,5,5),
  (25,41340,87,7),
  (25,38160,5802,6),
  (26,59040,109,6),
  (26,59040,15,36),
  (26,59040,111,6),
  (26,59040,5804,10),
  (26,54120,3,6),
  (26,56580,49,8),
  (26,59040,55,10),
  (26,59040,69,34),
  (26,59040,61,34),
  (26,73800,72,15),
  (26,59040,5802,10),
  (26,0,1001,6),
  (26,59040,127,6),
  (26,59040,17,36),
  (26,59040,98,8),
  (26,63960,87,8),
  (26,59040,129,6),
  (26,54120,5,6),
  (27,0,1001,7),
  (27,44280,98,11),
  (27,44280,61,37),
  (27,44280,127,9),
  (27,44280,15,39),
  (27,44280,129,9),
  (27,44280,109,9),
  (27,55350,72,17),
  (27,40590,5,9),
  (27,44280,111,9),
  (27,47970,87,11),
  (27,44280,69,37),
  (27,44280,55,12),
  (27,44280,17,39),
  (27,42435,49,11),
  (27,40590,3,9),
  (27,44280,5804,8),
  (27,44280,5802,8),
  (28,106,77,23),
  (28,106,33,23),
  (28,106,31,23),
  (28,106,37,23),
  (28,0,1002,1),
  (28,106,39,23),
  (28,106,1,23),
  (28,106,81,27),
  (28,106,83,27),
  (28,106,75,23),
  (28,106,11,23),
  (29,1748,81,29),
  (29,1748,33,25),
  (29,1824,55,1),
  (29,1748,75,25),
  (29,0,1002,2),
  (29,1748,1,25),
  (29,1748,83,29),
  (29,1748,11,25),
  (29,1748,31,25),
  (29,1748,77,25),
  (29,1748,37,25),
  (29,1748,39,25);

COMMIT;

INSERT INTO `merchant_buylists` (`item_id`, `price`, `shop_id`, `order`) VALUES
  (30,5716,83,31),
  (30,5716,49,1),
  (30,5716,37,27),
  (30,5716,33,27),
  (30,5716,81,31),
  (30,5716,39,27),
  (30,6461,87,1),
  (30,5716,1,27),
  (30,5716,31,27),
  (30,5964,17,29),
  (30,5716,11,27),
  (30,0,1002,3),
  (30,5716,75,27),
  (30,5716,77,27),
  (30,5964,55,3),
  (30,5964,15,29),
  (30,5964,98,1),
  (31,14605,39,33),
  (31,14605,83,37),
  (31,15240,17,34),
  (31,16510,87,6),
  (31,15240,111,4),
  (31,15240,5802,3),
  (31,15240,55,9),
  (31,14605,75,33),
  (31,0,1002,4),
  (31,14605,1,33),
  (31,15240,61,32),
  (31,14605,33,33),
  (31,13970,5,4),
  (31,14605,31,33),
  (31,13970,3,4),
  (31,15240,5804,3),
  (31,14605,37,33),
  (31,14605,11,33),
  (31,14605,77,33),
  (31,14605,49,6),
  (31,15240,129,4),
  (31,15240,127,4),
  (31,15240,98,6),
  (31,15240,109,4),
  (31,15240,15,34),
  (31,14605,81,37),
  (31,15240,69,32),
  (32,23880,69,36),
  (32,23880,5802,5),
  (32,0,1002,5),
  (32,23880,61,36),
  (32,23880,109,8),
  (32,23880,129,8),
  (32,23880,111,8),
  (32,23880,127,8),
  (32,23880,98,10),
  (32,21890,5,8),
  (32,21890,3,8),
  (32,23880,5804,5),
  (32,25870,87,10),
  (32,22885,49,10),
  (32,23880,15,38),
  (32,23880,17,38),
  (33,27600,127,7),
  (33,0,1002,6),
  (33,25300,5,7),
  (33,27600,61,35),
  (33,27600,111,7),
  (33,26450,49,9),
  (33,27600,98,9),
  (33,25300,3,7),
  (33,27600,5804,7),
  (33,34500,72,16),
  (33,27600,55,11),
  (33,27600,69,35),
  (33,27600,109,7),
  (33,27600,5802,7),
  (33,27600,17,37),
  (33,29900,87,9),
  (33,27600,129,7),
  (33,27600,15,37),
  (34,0,1002,7),
  (34,36840,129,10),
  (34,36840,111,10),
  (34,36840,98,12),
  (34,35305,49,12),
  (34,33770,3,10),
  (34,36840,17,40),
  (34,46050,21,11),
  (34,36840,5804,9),
  (34,46050,72,18),
  (34,36840,55,13),
  (34,36840,15,40),
  (34,36840,127,10),
  (34,33770,5,10),
  (34,39910,87,12),
  (34,36840,61,38),
  (34,36840,109,10),
  (34,36840,5802,9),
  (34,36840,69,38),
  (35,43,33,43),
  (35,43,81,47),
  (35,43,82,27),
  (35,43,83,47),
  (35,43,34,27),
  (35,43,77,43),
  (35,43,78,27),
  (35,43,76,27),
  (35,43,39,43),
  (35,43,1,43),
  (35,0,1003,1),
  (35,43,2,27),
  (35,43,84,27),
  (35,43,40,27),
  (35,43,75,43),
  (35,43,32,27),
  (35,43,38,27),
  (35,43,12,27),
  (35,43,31,43),
  (35,43,37,43),
  (35,43,11,43),
  (36,43,12,28),
  (36,43,38,28),
  (36,43,81,48),
  (36,43,1,44),
  (36,43,76,28),
  (36,0,1003,2),
  (36,43,34,28),
  (36,43,32,28),
  (36,43,82,28),
  (36,43,39,44),
  (36,43,84,28),
  (36,43,37,44),
  (36,43,75,44),
  (36,43,40,28),
  (36,43,83,48),
  (36,43,31,44),
  (36,43,11,44),
  (36,43,2,28),
  (36,43,77,44),
  (36,43,33,44),
  (36,43,78,28),
  (37,3047,1,47),
  (37,3047,82,31),
  (37,3180,56,25),
  (37,3047,83,51),
  (37,3047,78,31),
  (37,3180,99,17),
  (37,3047,81,51),
  (37,3047,11,47),
  (37,3180,18,29),
  (37,3047,12,31),
  (37,3047,34,31),
  (37,3047,75,47),
  (37,3047,84,31),
  (37,3047,77,47),
  (37,3047,39,47),
  (37,3975,73,17),
  (37,3047,2,31),
  (37,3047,40,31),
  (37,3180,17,51),
  (37,3047,37,47),
  (37,3047,31,47),
  (37,3180,16,29),
  (37,3047,76,31),
  (37,3975,72,24),
  (37,3445,87,23),
  (37,0,1003,3),
  (37,3047,32,31),
  (37,3047,33,47),
  (37,3047,50,17),
  (37,3047,38,31),
  (37,3180,55,28),
  (37,3180,15,51),
  (37,3445,88,17),
  (37,3047,49,23),
  (37,3180,98,23),
  (38,7785,77,48),
  (38,7785,49,24),
  (38,7785,31,48),
  (38,7785,84,32),
  (38,7785,11,48),
  (38,8124,112,26),
  (38,7785,34,32),
  (38,8124,5804,40),
  (38,7785,75,48),
  (38,7447,4,27),
  (38,7785,50,18),
  (38,8124,111,46),
  (38,8124,18,30),
  (38,7785,82,32),
  (38,8801,88,18),
  (38,7785,81,52),
  (38,8124,128,26),
  (38,7785,2,32),
  (38,7447,5,45),
  (38,7785,78,32),
  (38,7785,12,32),
  (38,7785,76,32),
  (38,8124,17,52),
  (38,8124,55,29),
  (38,7785,40,32),
  (38,7785,83,52),
  (38,7785,32,32),
  (38,8124,5802,40),
  (38,8124,129,46),
  (38,8124,56,26),
  (38,8124,16,30),
  (38,8124,98,24),
  (38,8124,110,26),
  (38,8124,130,26),
  (38,8124,62,41),
  (38,7785,39,48),
  (38,8124,61,54),
  (38,7785,37,48),
  (38,0,1003,4),
  (38,7447,3,45),
  (38,7785,33,48),
  (38,8124,109,46),
  (38,8124,69,54),
  (38,8124,15,52),
  (38,8124,70,41),
  (38,8801,87,24),
  (38,8124,127,46),
  (38,8124,99,18),
  (38,7785,1,48),
  (38,7447,6,27),
  (38,7785,38,32),
  (39,14760,61,55),
  (39,18450,72,25),
  (39,14760,127,47),
  (39,14760,17,53),
  (39,14145,49,25),
  (39,0,1003,5),
  (39,14760,55,30),
  (39,14760,15,53),
  (39,14760,70,42),
  (39,14760,18,31),
  (39,14760,128,27),
  (39,15990,87,25),
  (39,14760,5802,41),
  (39,14760,130,27),
  (39,14760,5804,41),
  (39,14760,56,27),
  (39,14760,111,47),
  (39,14760,69,55),
  (39,13530,3,46),
  (39,14760,109,47),
  (39,13530,4,28),
  (39,14760,16,31),
  (39,14760,99,19),
  (39,13530,6,28),
  (39,14145,50,19),
  (39,14760,112,27),
  (39,14760,129,47),
  (39,14760,98,25),
  (39,15990,88,19),
  (39,13530,5,46),
  (39,14760,62,42),
  (39,14760,110,27),
  (39,18450,73,18),
  (40,25080,130,28),
  (40,25080,95,29),
  (40,25080,69,56),
  (40,25080,98,26),
  (40,22990,6,29),
  (40,22990,5,47),
  (40,25080,18,32),
  (40,25080,129,48),
  (40,25080,5802,42),
  (40,25080,5804,42),
  (40,25080,110,28),
  (40,25080,55,31),
  (40,25080,15,54),
  (40,25080,127,48),
  (40,24035,49,26),
  (40,25080,99,20),
  (40,22990,4,29),
  (40,25080,128,28),
  (40,25080,109,48),
  (40,25080,112,28),
  (40,27170,88,20),
  (40,0,1003,6),
  (40,24035,50,20),
  (40,25080,111,48),
  (40,25080,62,43),
  (40,25080,17,54),
  (40,25080,61,56),
  (40,25080,70,43),
  (40,25080,56,28),
  (40,24035,44,14),
  (40,25080,16,32),
  (40,27170,87,26),
  (40,22990,3,47),
  (41,63,84,33),
  (41,63,2,33),
  (41,63,33,49),
  (41,63,78,33),
  (41,63,34,33),
  (41,0,1004,1),
  (41,63,31,49),
  (41,63,75,49),
  (41,63,37,49),
  (41,63,40,33),
  (41,63,83,53),
  (41,63,32,33),
  (41,63,76,33),
  (41,63,39,49),
  (41,63,12,33),
  (41,63,11,49),
  (41,63,81,53),
  (41,63,77,49),
  (41,63,1,49),
  (41,63,38,33),
  (41,63,82,33),
  (42,1048,83,54),
  (42,1048,37,50),
  (42,1048,77,50),
  (42,1048,32,34),
  (42,1093,55,32),
  (42,1048,82,34),
  (42,1048,40,34),
  (42,1048,75,50),
  (42,1048,76,34),
  (42,1048,1,50),
  (42,1048,11,50),
  (42,1048,84,34),
  (42,1093,56,29),
  (42,1048,78,34),
  (42,1048,33,50),
  (42,1048,12,34),
  (42,1048,38,34),
  (42,0,1004,2),
  (42,1048,34,34),
  (42,1048,81,54),
  (42,1048,2,34),
  (42,1048,31,50),
  (42,1048,39,50),
  (43,4577,50,21),
  (43,4776,99,21),
  (43,4577,33,51),
  (43,4577,39,51),
  (43,5174,87,27),
  (43,5970,73,19),
  (43,4577,77,51),
  (43,4577,78,35),
  (43,4577,11,51),
  (43,5174,88,21),
  (43,4776,16,33),
  (43,4577,75,51),
  (43,4577,2,35),
  (43,4776,98,27),
  (43,4577,84,35),
  (43,4577,37,51),
  (43,5970,72,26),
  (43,4776,56,30),
  (43,4776,15,55),
  (43,4577,32,35),
  (43,0,1004,3),
  (43,4577,12,35),
  (43,4577,82,35),
  (43,4776,18,33),
  (43,4577,34,35),
  (43,4577,38,35),
  (43,4577,31,51),
  (43,4577,81,55),
  (43,4577,76,35),
  (43,4776,17,55),
  (43,4577,83,55),
  (43,4577,1,51),
  (43,4577,49,27),
  (43,4577,40,35),
  (43,4776,55,33),
  (44,12240,5802,45),
  (44,12240,69,58),
  (44,11730,32,36),
  (44,11730,82,36),
  (44,11730,77,52),
  (44,11730,50,22),
  (44,11730,81,56),
  (44,11730,37,52),
  (44,11730,39,52),
  (44,11220,3,51),
  (44,11220,5,51),
  (44,12240,99,22),
  (44,11730,84,36),
  (44,11730,34,36),
  (44,11730,49,28),
  (44,11730,33,52),
  (44,11730,78,36),
  (44,12240,98,28),
  (44,13260,87,28),
  (44,11220,4,33),
  (44,0,1004,4),
  (44,11730,83,56),
  (44,11730,40,36),
  (44,11730,31,52),
  (44,12240,129,52),
  (44,12240,128,32),
  (44,11220,6,33),
  (44,11730,38,36),
  (44,11730,2,36),
  (44,12240,61,58),
  (44,13260,88,22),
  (44,12240,127,52),
  (44,12240,5804,45),
  (44,11730,11,52),
  (44,12240,111,52),
  (44,12240,56,31),
  (44,11730,1,52),
  (44,12240,18,34),
  (44,12240,15,56),
  (44,12240,109,52),
  (44,12240,112,32),
  (44,12240,70,45),
  (44,11730,12,36),
  (44,12240,55,34),
  (44,12240,110,32),
  (44,12240,130,32),
  (44,11730,76,36),
  (44,12240,16,34),
  (44,12240,17,56),
  (44,11730,75,52),
  (44,12240,62,45),
  (45,35995,44,17),
  (45,35995,49,30),
  (45,37560,127,54),
  (45,40690,88,24),
  (45,37560,129,54),
  (45,37560,18,36),
  (45,37560,109,54),
  (45,37560,69,60),
  (45,37560,61,60),
  (45,37560,110,34),
  (45,37560,55,36),
  (45,37560,111,54),
  (45,37560,5802,47),
  (45,37560,99,24),
  (45,37560,98,30),
  (45,37560,130,34),
  (45,37560,15,58),
  (45,37560,70,47),
  (45,34430,6,35),
  (45,37560,62,47),
  (45,35995,50,24),
  (45,40690,87,30),
  (45,34430,4,35),
  (45,37560,95,32),
  (45,37560,17,58),
  (45,37560,128,34),
  (45,37560,56,33),
  (45,37560,16,36),
  (45,34430,5,53),
  (45,37560,112,34),
  (45,34430,3,53),
  (45,37560,5804,47),
  (45,0,1004,5),
  (46,60000,130,35),
  (46,60000,109,55),
  (46,60000,61,61),
  (46,55000,4,36),
  (46,60000,129,55),
  (46,55000,5,54),
  (46,55000,3,54),
  (46,60000,112,35),
  (46,55000,6,36),
  (46,60000,110,35),
  (46,60000,5802,48),
  (46,60000,127,55),
  (46,60000,69,61),
  (46,57500,44,18),
  (46,0,1004,6),
  (46,60000,5804,48),
  (46,60000,128,35),
  (46,60000,62,48),
  (46,60000,70,48),
  (46,60000,111,55),
  (46,60000,95,33),
  (47,0,1004,7),
  (47,91440,112,36),
  (47,83820,6,37),
  (47,91440,127,56),
  (47,83820,4,37),
  (47,91440,128,36),
  (47,91440,5804,49),
  (47,83820,3,55),
  (47,83820,5,55),
  (47,91440,110,36),
  (47,91440,5802,49),
  (47,91440,111,56),
  (47,91440,130,36),
  (47,91440,109,56),
  (47,91440,129,56),
  (48,43,84,22),
  (48,43,1,38),
  (48,43,37,38),
  (48,43,82,22),
  (48,43,76,22),
  (48,43,39,38),
  (48,43,40,22),
  (48,43,81,42),
  (48,43,75,38),
  (48,0,1005,1);

COMMIT;

INSERT INTO `merchant_buylists` (`item_id`, `price`, `shop_id`, `order`) VALUES
  (48,43,38,22),
  (48,43,83,42),
  (48,43,31,38),
  (48,43,12,22),
  (48,43,33,38),
  (48,43,2,22),
  (48,43,77,38),
  (48,43,34,22),
  (48,43,32,22),
  (48,43,78,22),
  (48,43,11,38),
  (49,3047,34,24),
  (49,3445,88,13),
  (49,3047,84,24),
  (49,3047,32,24),
  (49,3180,16,25),
  (49,3047,12,24),
  (49,3047,38,24),
  (49,3180,18,25),
  (49,3180,17,47),
  (49,3047,33,40),
  (49,3047,11,40),
  (49,3445,87,19),
  (49,3047,83,44),
  (49,3047,1,40),
  (49,3180,56,19),
  (49,3180,55,22),
  (49,3047,81,44),
  (49,3047,77,40),
  (49,3047,50,13),
  (49,0,1005,2),
  (49,3047,49,19),
  (49,3047,76,24),
  (49,3047,2,24),
  (49,3047,39,40),
  (49,3180,98,19),
  (49,3180,99,13),
  (49,3047,37,40),
  (49,3180,15,47),
  (49,3047,75,40),
  (49,3047,78,24),
  (49,3047,31,40),
  (49,3047,40,24),
  (49,3047,82,24),
  (50,8124,111,40),
  (50,7785,49,20),
  (50,8801,88,14),
  (50,7785,76,25),
  (50,7785,78,25),
  (50,8124,55,23),
  (50,8801,87,20),
  (50,10155,73,15),
  (50,8124,127,40),
  (50,8124,70,37),
  (50,10155,72,22),
  (50,7785,38,25),
  (50,8124,98,20),
  (50,7785,33,41),
  (50,7785,11,41),
  (50,8124,18,26),
  (50,7785,82,25),
  (50,7785,81,45),
  (50,8124,15,48),
  (50,8124,99,14),
  (50,8124,128,20),
  (50,0,1005,3),
  (50,8124,5804,34),
  (50,7447,4,21),
  (50,8124,130,20),
  (50,7785,77,41),
  (50,7447,5,39),
  (50,7785,84,25),
  (50,8124,17,48),
  (50,7785,31,41),
  (50,7785,12,25),
  (50,8124,62,37),
  (50,8124,110,20),
  (50,8124,61,50),
  (50,7785,32,25),
  (50,8124,16,26),
  (50,8124,109,40),
  (50,8124,129,40),
  (50,7785,75,41),
  (50,7785,39,41),
  (50,7785,50,14),
  (50,7447,3,39),
  (50,7785,37,41),
  (50,7785,2,25),
  (50,8124,112,20),
  (50,7785,40,25),
  (50,7785,34,25),
  (50,8124,56,20),
  (50,8124,5802,34),
  (50,7785,1,41),
  (50,7785,83,45),
  (50,8124,69,50),
  (50,7447,6,21),
  (51,14760,55,24),
  (51,14760,5802,35),
  (51,14760,69,51),
  (51,13530,6,22),
  (51,14760,18,27),
  (51,14760,98,21),
  (51,14760,127,41),
  (51,14760,15,49),
  (51,14760,111,41),
  (51,14145,50,15),
  (51,18450,72,23),
  (51,13530,4,22),
  (51,14760,110,21),
  (51,14760,70,38),
  (51,13530,3,40),
  (51,14760,56,21),
  (51,18450,73,16),
  (51,14760,99,15),
  (51,14760,129,41),
  (51,14760,5804,35),
  (51,15990,88,15),
  (51,14760,17,49),
  (51,0,1005,4),
  (51,14760,109,41),
  (51,14760,61,51),
  (51,14760,128,21),
  (51,13530,5,40),
  (51,15990,87,21),
  (51,14760,112,21),
  (51,14760,16,27),
  (51,14760,62,38),
  (51,14145,49,21),
  (51,14760,130,21),
  (52,0,1006,1),
  (53,0,1006,2),
  (54,0,1006,3),
  (55,0,1007,1),
  (56,0,1007,2),
  (58,219600,127,20),
  (58,201300,3,20),
  (58,219600,69,44),
  (58,219600,61,44),
  (58,201300,5,20),
  (58,219600,129,20),
  (58,219600,111,20),
  (58,219600,5802,22),
  (58,219600,5804,22),
  (58,0,1001,8),
  (58,219600,109,20),
  (59,152400,129,21),
  (59,152400,127,21),
  (59,152400,111,21),
  (59,0,1002,8),
  (59,139700,3,27),
  (59,152400,109,21),
  (59,152400,5802,21),
  (59,139700,5,27),
  (59,152400,5804,21),
  (60,0,1001,9),
  (61,0,1005,5),
  (62,0,1003,7),
  (63,60960,128,24),
  (63,60960,129,44),
  (63,60960,110,24),
  (63,60960,95,28),
  (63,60960,111,44),
  (63,55880,5,43),
  (63,0,1005,6),
  (63,55880,6,25),
  (63,60960,109,44),
  (63,60960,5804,38),
  (63,60960,127,44),
  (63,55880,4,25),
  (63,55880,3,43),
  (63,60960,112,24),
  (63,60960,5802,38),
  (63,58420,44,13),
  (63,60960,130,24),
  (64,0,1003,8),
  (65,0,3001,1),
  (66,62215,33,13),
  (66,62215,11,13),
  (66,0,2001,4),
  (66,62215,31,13),
  (66,70330,58,2),
  (66,62215,37,13),
  (66,64920,96,2),
  (66,62215,75,13),
  (66,62215,77,13),
  (66,62215,83,13),
  (66,64920,15,2),
  (66,62215,81,13),
  (66,64920,53,9),
  (66,64920,17,2),
  (66,62215,47,2),
  (66,62215,39,13),
  (66,81150,72,1),
  (66,62215,1,13),
  (67,81150,72,2),
  (67,64920,96,3),
  (67,62215,11,14),
  (67,62215,83,14),
  (67,62215,1,14),
  (67,62215,75,14),
  (67,62215,77,14),
  (67,70330,58,3),
  (67,64920,17,3),
  (67,0,2001,5),
  (67,62215,33,14),
  (67,62215,37,14),
  (67,64920,53,10),
  (67,62215,31,14),
  (67,64920,15,3),
  (67,62215,39,14),
  (67,62215,81,14),
  (67,62215,47,3),
  (68,292800,17,12),
  (68,292800,15,12),
  (68,268400,27,5),
  (68,292800,96,12),
  (68,317200,58,12),
  (68,292800,69,5),
  (68,280600,47,12),
  (68,268400,25,5),
  (68,292800,5806,5),
  (68,292804,105,5),
  (68,292800,61,5),
  (68,292800,53,19),
  (68,292804,107,5),
  (68,366000,72,7),
  (68,292804,123,5),
  (68,292800,5800,5),
  (68,0,2001,6),
  (68,292804,125,5),
  (69,772800,69,19),
  (69,772810,107,19),
  (69,772800,5800,19),
  (69,708400,25,19),
  (69,772810,105,19),
  (69,772800,5806,19),
  (69,772800,61,19),
  (69,708400,27,19),
  (69,772810,125,19),
  (69,772810,123,19),
  (69,966000,21,8),
  (69,0,2001,7),
  (70,0,2002,1),
  (71,0,2002,2),
  (72,0,2001,8),
  (73,0,2001,9),
  (74,0,2001,10),
  (75,0,2001,11),
  (76,0,2001,12),
  (77,0,2001,13),
  (78,0,2002,3),
  (79,0,2001,14),
  (80,0,2001,15),
  (81,0,2002,4),
  (82,0,2001,16),
  (83,859211,108,15),
  (83,859211,124,15),
  (83,859200,70,15),
  (83,823400,43,6),
  (83,859200,62,15),
  (83,787600,10,14),
  (83,787600,30,14),
  (83,859200,95,6),
  (83,787600,26,15),
  (83,859211,106,15),
  (83,0,2001,17),
  (83,859200,5807,15),
  (83,859211,126,15),
  (83,859200,5801,15),
  (83,787600,28,15),
  (84,0,2001,18),
  (85,0,2001,19),
  (86,772800,5806,25),
  (86,708400,27,25),
  (86,772810,105,25),
  (86,772810,107,25),
  (86,708400,25,25),
  (86,772800,5800,25),
  (86,772810,123,25),
  (86,772810,125,25),
  (86,0,2009,5),
  (87,292800,61,9),
  (87,292800,5800,9),
  (87,317200,58,16),
  (87,292800,53,23),
  (87,268400,27,9),
  (87,292804,125,9),
  (87,280600,47,16),
  (87,292800,17,16),
  (87,0,2009,6),
  (87,292804,107,9),
  (87,292800,69,9),
  (87,292804,105,9),
  (87,268400,25,9),
  (87,292804,123,9),
  (87,292800,5806,9),
  (87,292800,15,16),
  (87,292800,96,16),
  (88,0,2009,7),
  (89,0,2009,8),
  (90,1680021,106,25),
  (90,1680021,108,25),
  (90,1540000,28,25),
  (90,1680000,5801,19),
  (90,1680021,126,25),
  (90,1680000,5807,19),
  (90,1540000,26,25),
  (90,0,2010,3),
  (90,1680021,124,25),
  (91,0,2009,9),
  (92,0,2010,4),
  (93,1680021,105,43),
  (93,1540000,25,43),
  (93,1540000,27,43),
  (93,1680000,5800,43),
  (93,1680000,5806,43),
  (93,1680021,123,43),
  (93,1680021,125,43),
  (93,0,2008,3),
  (93,1680021,107,43),
  (94,0,2008,4),
  (95,0,2008,5),
  (96,0,2008,6),
  (97,0,2008,7),
  (98,0,2008,8),
  (99,14375,12,4),
  (99,14375,2,4),
  (99,14375,84,4),
  (99,14375,34,4),
  (99,14375,78,4),
  (99,15000,54,2),
  (99,14375,76,4),
  (99,0,2012,1),
  (99,14375,32,4),
  (99,14375,38,4),
  (99,14375,40,4),
  (99,14375,82,4),
  (100,292800,70,5),
  (100,292800,18,6),
  (100,268400,28,5),
  (100,292800,16,6),
  (100,292804,126,5),
  (100,0,2012,2),
  (100,317200,59,6),
  (100,292800,5801,5),
  (100,292800,97,6),
  (100,292800,54,8),
  (100,292804,108,5),
  (100,292804,124,5),
  (100,366000,73,4),
  (100,280600,48,6),
  (100,268400,10,5),
  (100,268400,30,5),
  (100,292804,106,5),
  (100,292800,62,5),
  (100,292800,5807,5),
  (100,268400,26,5),
  (101,490800,62,7),
  (101,490806,124,7),
  (101,490800,54,10),
  (101,449900,10,7),
  (101,490800,18,8),
  (101,449900,30,7),
  (101,490806,106,7),
  (101,490800,5807,7),
  (101,449900,26,7),
  (101,0,2012,3),
  (101,490800,97,8),
  (101,449900,28,7),
  (101,490806,126,7),
  (101,531700,59,8),
  (101,490800,16,8),
  (101,470350,48,8),
  (101,490806,108,7),
  (101,490800,70,7),
  (101,490800,5801,7),
  (102,8532,18,22),
  (102,8176,82,21),
  (102,8176,49,16),
  (102,8532,130,14),
  (102,8532,110,14),
  (102,8532,56,15),
  (102,8176,84,21),
  (102,8532,128,14),
  (102,9243,87,16),
  (102,8532,129,34),
  (102,8176,33,37),
  (102,8532,70,33),
  (102,0,2011,4),
  (102,8532,111,34),
  (102,8176,81,41),
  (102,8176,38,21),
  (102,10665,73,13),
  (102,8532,98,16),
  (102,8176,1,37),
  (102,10665,72,20),
  (102,8176,39,37),
  (102,8532,99,10),
  (102,8176,76,21),
  (102,7821,5,33),
  (102,8532,15,44),
  (102,8532,17,44),
  (102,8176,2,21),
  (102,8532,5804,29),
  (102,8532,127,34),
  (102,8176,78,21),
  (102,8176,11,37),
  (102,8532,112,14),
  (102,8532,61,46),
  (102,8532,16,22),
  (102,8176,34,21),
  (102,8532,55,18),
  (102,7821,3,33),
  (102,9243,88,10),
  (102,8532,69,46),
  (102,8176,50,10),
  (102,8176,83,41),
  (102,8176,75,37),
  (102,8176,37,37),
  (102,8532,109,34),
  (102,8532,62,33),
  (102,8176,32,21),
  (102,8176,12,21),
  (102,8176,31,37),
  (102,7821,6,15),
  (102,7821,4,15),
  (102,8176,40,21),
  (102,8176,77,37),
  (102,8532,5802,29),
  (103,0,2011,5),
  (104,0,2011,6),
  (105,0,2011,7),
  (106,0,2011,8),
  (107,0,2011,9),
  (108,0,2011,10),
  (109,0,2011,11),
  (110,0,2011,12),
  (111,0,2011,13),
  (112,56,41,5),
  (112,56,79,5),
  (112,74,71,5),
  (112,74,74,5),
  (112,56,85,5),
  (112,0,1008,1),
  (112,56,80,5),
  (112,56,35,5),
  (112,56,13,5),
  (113,973,67,6),
  (113,933,85,6),
  (113,933,35,6),
  (113,1216,71,6),
  (113,933,80,6),
  (113,933,79,6),
  (113,0,1008,2),
  (113,1216,74,6),
  (113,933,13,6),
  (113,973,68,6),
  (113,933,41,6),
  (114,4036,85,7),
  (114,4036,41,7),
  (114,4036,79,7),
  (114,4036,35,7),
  (114,4036,13,7),
  (114,4036,51,3),
  (114,5265,74,7),
  (114,4212,68,7),
  (114,4212,20,3),
  (114,5265,71,7),
  (114,4036,80,7),
  (114,0,1008,3),
  (114,5265,22,7),
  (114,4212,102,3),
  (114,4212,103,3),
  (114,4212,67,7),
  (114,4212,19,3),
  (115,5265,22,8),
  (115,4036,80,8),
  (115,4036,51,4),
  (115,4036,79,8),
  (115,4036,13,8),
  (115,4212,68,8),
  (115,5265,74,8),
  (115,0,1008,4),
  (115,4212,67,8),
  (115,4212,102,4),
  (115,4212,103,4),
  (115,4212,19,4),
  (115,5265,71,8),
  (115,4036,41,8),
  (115,4212,20,4),
  (115,4036,35,8),
  (115,4036,85,8),
  (116,38,35,10),
  (116,38,80,10),
  (116,38,13,10),
  (116,0,1009,1),
  (116,50,71,10),
  (116,38,85,10),
  (116,50,74,10);

COMMIT;

INSERT INTO `merchant_buylists` (`item_id`, `price`, `shop_id`, `order`) VALUES
  (116,38,79,10),
  (116,38,41,10),
  (117,0,1009,2),
  (118,76,80,1),
  (118,76,79,1),
  (118,76,41,1),
  (118,76,35,1),
  (118,76,13,1),
  (118,99,74,1),
  (118,0,1010,1),
  (118,99,71,1),
  (118,76,85,1),
  (119,0,1010,2),
  (120,0,2001,20),
  (121,0,2001,21),
  (122,62215,31,15),
  (122,62215,83,15),
  (122,62215,81,15),
  (122,62215,37,15),
  (122,62215,1,15),
  (122,64920,17,4),
  (122,62215,33,15),
  (122,62215,47,4),
  (122,64920,15,4),
  (122,70330,58,4),
  (122,62215,39,15),
  (122,62215,11,15),
  (122,64920,53,11),
  (122,0,2001,22),
  (122,62215,77,15),
  (122,64920,96,4),
  (122,62215,75,15),
  (123,449900,25,11),
  (123,490806,107,11),
  (123,490800,69,11),
  (123,449900,27,11),
  (123,490800,5800,11),
  (123,490800,5806,11),
  (123,490806,123,11),
  (123,490800,53,25),
  (123,490800,61,11),
  (123,490806,125,11),
  (123,613500,72,9),
  (123,470350,47,18),
  (123,490800,96,18),
  (123,490800,15,18),
  (123,531700,58,18),
  (123,0,2001,23),
  (123,490800,17,18),
  (123,490806,105,11),
  (123,613500,21,1),
  (124,1160415,123,28),
  (124,1160415,105,28),
  (124,1063700,27,28),
  (124,1160415,107,28),
  (124,0,2002,5),
  (124,1160415,125,28),
  (124,1063700,25,28),
  (124,1160400,5806,28),
  (124,1160400,5800,28),
  (125,0,2001,24),
  (126,772810,123,20),
  (126,708400,25,20),
  (126,772810,105,20),
  (126,772800,5800,20),
  (126,0,2001,25),
  (126,772810,107,20),
  (126,708400,27,20),
  (126,772800,5806,20),
  (126,772810,125,20),
  (127,1160415,125,29),
  (127,1063700,25,29),
  (127,0,2001,26),
  (127,1160400,5800,29),
  (127,1160415,123,29),
  (127,1160415,105,29),
  (127,1160400,5806,29),
  (127,1160415,107,29),
  (127,1063700,27,29),
  (128,0,2001,27),
  (129,1680000,5800,36),
  (129,1680021,125,36),
  (129,0,2001,28),
  (129,1680021,105,36),
  (129,1680021,107,36),
  (129,1540000,27,36),
  (129,1540000,25,36),
  (129,1680000,5806,36),
  (129,1680021,123,36),
  (130,1160400,5800,30),
  (130,1063700,27,30),
  (130,1160415,123,30),
  (130,1160415,105,30),
  (130,1160400,5806,30),
  (130,1160415,125,30),
  (130,0,2001,29),
  (130,1063700,25,30),
  (130,1160415,107,30),
  (131,0,2001,30),
  (132,0,2001,31),
  (133,0,2001,32),
  (134,0,2001,33),
  (135,0,2001,34),
  (136,0,2001,35),
  (137,0,2001,36),
  (138,0,2001,37),
  (139,0,2001,38),
  (140,0,2001,39),
  (141,0,2001,40),
  (142,0,2001,41),
  (143,859200,5801,16),
  (143,859200,70,16),
  (143,859211,124,16),
  (143,787600,10,15),
  (143,859211,108,16),
  (143,0,2001,42),
  (143,859200,62,16),
  (143,787600,26,16),
  (143,787600,30,15),
  (143,859200,5807,16),
  (143,787600,28,16),
  (143,859200,95,7),
  (143,859211,126,16),
  (143,823400,43,7),
  (143,859211,106,16),
  (144,0,2001,43),
  (144,859200,5807,17),
  (144,859200,95,8),
  (144,859211,124,17),
  (144,859211,126,17),
  (144,787600,10,16),
  (144,787600,28,17),
  (144,859200,62,17),
  (144,859200,5801,17),
  (144,787600,30,16),
  (144,859211,106,17),
  (144,823400,43,8),
  (144,787600,26,17),
  (144,859211,108,17),
  (144,859200,70,17),
  (145,0,2001,44),
  (146,0,2001,45),
  (147,0,2001,46),
  (148,0,2001,47),
  (149,0,2001,48),
  (150,0,2001,49),
  (151,0,2001,50),
  (152,9280,83,6),
  (152,9280,39,6),
  (152,9280,75,6),
  (152,9280,11,6),
  (152,9280,31,6),
  (152,9280,37,6),
  (152,9280,33,6),
  (152,9684,53,2),
  (152,9280,81,6),
  (152,9280,1,6),
  (152,9280,77,6),
  (152,0,2009,10),
  (153,21275,77,11),
  (153,21275,1,11),
  (153,21275,31,11),
  (153,21275,81,11),
  (153,21275,11,11),
  (153,22200,53,7),
  (153,0,2009,11),
  (153,21275,33,11),
  (153,21275,75,11),
  (153,21275,37,11),
  (153,21275,83,11),
  (153,21275,39,11),
  (154,62215,39,16),
  (154,0,2009,12),
  (154,62215,77,16),
  (154,64920,96,5),
  (154,70330,58,5),
  (154,62215,33,16),
  (154,62215,47,5),
  (154,64920,15,5),
  (154,62215,81,16),
  (154,62215,31,16),
  (154,62215,37,16),
  (154,62215,83,16),
  (154,62215,1,16),
  (154,62215,11,16),
  (154,62215,75,16),
  (154,64920,17,5),
  (154,64920,53,12),
  (155,292800,61,8),
  (155,292804,105,8),
  (155,292800,5800,8),
  (155,292804,107,8),
  (155,280600,47,15),
  (155,292800,69,8),
  (155,0,2009,13),
  (155,292800,53,22),
  (155,292804,123,8),
  (155,292800,17,15),
  (155,292804,125,8),
  (155,268400,27,8),
  (155,292800,5806,8),
  (155,292800,96,15),
  (155,317200,58,15),
  (155,292800,15,15),
  (155,268400,25,8),
  (156,490800,69,15),
  (156,613500,72,11),
  (156,490806,105,15),
  (156,490800,15,22),
  (156,531700,58,22),
  (156,490800,5806,15),
  (156,490800,17,22),
  (156,449900,25,15),
  (156,490806,125,15),
  (156,490800,61,15),
  (156,490800,96,22),
  (156,490806,107,15),
  (156,449900,27,15),
  (156,490800,5800,15),
  (156,0,2009,14),
  (156,490800,53,29),
  (156,470350,47,22),
  (156,490806,123,15),
  (156,613500,21,4),
  (157,1160415,105,33),
  (157,0,2009,15),
  (157,1160415,123,33),
  (157,1160400,5806,33),
  (157,1160415,107,33),
  (157,1063700,27,33),
  (157,1160400,5800,33),
  (157,1160415,125,33),
  (157,1063700,25,33),
  (158,1680021,123,40),
  (158,1680021,105,40),
  (158,0,2009,16),
  (158,1680000,5806,40),
  (158,1540000,27,40),
  (158,1680000,5800,40),
  (158,1680021,125,40),
  (158,1540000,25,40),
  (158,1680021,107,40),
  (159,0,2009,17),
  (160,0,2009,18),
  (161,0,2009,19),
  (162,0,2009,20),
  (163,0,2009,21),
  (164,0,2009,22),
  (165,0,2009,23),
  (166,449900,27,16),
  (166,470350,47,23),
  (166,490806,123,16),
  (166,490800,5806,16),
  (166,449900,25,16),
  (166,531700,58,23),
  (166,490800,69,16),
  (166,490806,125,16),
  (166,490800,96,23),
  (166,490806,105,16),
  (166,490800,17,23),
  (166,490800,15,23),
  (166,490800,61,16),
  (166,0,2009,24),
  (166,490806,107,16),
  (166,613500,21,5),
  (166,490800,5800,16),
  (166,490800,53,30),
  (167,0,2009,25),
  (168,490800,5806,17),
  (168,490800,96,24),
  (168,449900,27,17),
  (168,490806,107,17),
  (168,490800,17,24),
  (168,449900,25,17),
  (168,490800,5800,17),
  (168,490806,105,17),
  (168,490800,15,24),
  (168,0,2009,26),
  (168,490800,53,31),
  (168,613500,21,6),
  (168,531700,58,24),
  (168,490800,69,17),
  (168,490806,125,17),
  (168,490806,123,17),
  (168,470350,47,24),
  (168,490800,61,17),
  (169,0,2009,27),
  (170,0,2009,28),
  (171,0,2009,29),
  (172,1680021,123,41),
  (172,0,2009,30),
  (172,1540000,27,41),
  (172,1680000,5806,41),
  (172,1680000,5800,41),
  (172,1540000,25,41),
  (172,1680021,107,41),
  (172,1680021,125,41),
  (172,1680021,105,41),
  (173,0,2009,31),
  (174,0,2009,32),
  (175,0,2009,33),
  (176,156400,38,6),
  (176,176800,59,2),
  (176,156400,40,6),
  (176,156400,2,6),
  (176,163200,70,1),
  (176,163200,18,2),
  (176,156400,76,6),
  (176,163202,124,1),
  (176,149600,28,1),
  (176,163200,5801,1),
  (176,163202,126,1),
  (176,156400,78,6),
  (176,156400,48,2),
  (176,163200,16,2),
  (176,156400,34,6),
  (176,156400,12,6),
  (176,163202,108,1),
  (176,163200,97,2),
  (176,156400,32,6),
  (176,163200,54,4),
  (176,163200,62,1),
  (176,149600,26,1),
  (176,0,2010,5),
  (176,163200,5807,1),
  (176,163202,106,1),
  (176,156400,82,6),
  (176,156400,84,6),
  (177,280600,48,4),
  (177,292800,16,4),
  (177,292800,5801,3),
  (177,292804,108,3),
  (177,292800,18,4),
  (177,292804,124,3),
  (177,292800,97,4),
  (177,268400,28,3),
  (177,292800,54,6),
  (177,317200,59,4),
  (177,268400,26,3),
  (177,366000,73,3),
  (177,0,2010,6),
  (177,292800,70,3),
  (177,292804,106,3),
  (177,268400,10,3),
  (177,292804,126,3),
  (177,268400,30,3),
  (177,292800,62,3),
  (177,292800,5807,3),
  (178,449900,28,6),
  (178,490800,5807,6),
  (178,490806,106,6),
  (178,0,2010,7),
  (178,490800,62,6),
  (178,490806,126,6),
  (178,470350,48,7),
  (178,449900,26,6),
  (178,490800,18,7),
  (178,490800,54,9),
  (178,449900,30,6),
  (178,613500,73,5),
  (178,490800,97,7),
  (178,490806,124,6),
  (178,490800,16,7),
  (178,449900,10,6),
  (178,531700,59,7),
  (178,490800,70,6),
  (178,490800,5801,6),
  (178,490806,108,6),
  (179,772800,70,10),
  (179,708400,28,10),
  (179,740600,48,11),
  (179,772800,16,11),
  (179,772800,95,1),
  (179,772800,97,11),
  (179,708400,26,10),
  (179,0,2009,34),
  (179,740600,43,1),
  (179,772810,108,10),
  (179,772800,62,10),
  (179,837200,59,11),
  (179,772800,18,11),
  (179,772800,5807,10),
  (179,772810,124,10),
  (179,772810,106,10),
  (179,772800,5801,10),
  (179,772810,126,10),
  (180,0,2009,35),
  (181,0,2009,36),
  (182,772800,95,2),
  (182,740600,43,2),
  (182,837200,59,12),
  (182,0,2009,37),
  (182,708400,10,10),
  (182,708400,26,11),
  (182,772800,62,11),
  (182,772800,5801,11),
  (182,772810,108,11),
  (182,772810,126,11),
  (182,772800,16,12),
  (182,772800,18,12),
  (182,772800,97,12),
  (182,772800,70,11),
  (182,772800,5807,11),
  (182,740600,48,12),
  (182,708400,30,10),
  (182,772810,106,11),
  (182,772810,124,11),
  (182,708400,28,11),
  (183,772810,108,12),
  (183,0,2010,8),
  (183,772810,126,12),
  (183,772800,62,12),
  (183,708400,10,11),
  (183,772810,124,12),
  (183,708400,28,12),
  (183,772810,106,12),
  (183,772800,5807,12),
  (183,772800,70,12),
  (183,708400,30,11),
  (183,740600,43,3),
  (183,708400,26,12),
  (183,772800,5801,12),
  (183,772800,95,3),
  (184,0,2010,9),
  (185,708400,26,13),
  (185,772800,70,13),
  (185,708400,30,12),
  (185,772810,124,13),
  (185,772800,5807,13),
  (185,708400,28,13),
  (185,740600,43,4),
  (185,708400,10,12),
  (185,772800,95,4),
  (185,772810,126,13),
  (185,772810,108,13),
  (185,0,2010,10),
  (185,772800,5801,13),
  (185,772810,106,13),
  (185,772800,62,13),
  (186,1160415,106,22),
  (186,1160415,124,22),
  (186,1063700,28,22),
  (186,1160415,126,22),
  (186,1160400,95,13),
  (186,1160415,108,22),
  (186,1063700,26,22),
  (186,0,2010,11),
  (186,1112050,43,13),
  (187,0,2010,12),
  (188,0,2010,13),
  (189,0,2009,38),
  (190,0,2010,14),
  (191,0,2010,15),
  (192,0,2010,16),
  (193,0,2009,39),
  (194,0,2010,17),
  (195,0,2010,18),
  (196,0,2009,40),
  (197,0,2010,19),
  (198,0,2010,20),
  (199,0,2010,21),
  (200,0,2010,22),
  (201,0,2009,41),
  (202,0,2009,42),
  (203,0,2010,23),
  (204,0,2010,24),
  (205,0,2010,25),
  (206,0,2010,26),
  (207,0,2010,27),
  (208,0,2010,28),
  (209,0,2010,29),
  (210,0,2010,30),
  (211,0,2010,31),
  (212,0,2010,32),
  (213,0,2010,33),
  (214,0,2010,34),
  (215,14375,75,8),
  (215,15000,53,4),
  (215,14375,77,8),
  (215,14375,39,8),
  (215,14375,33,8),
  (215,14375,83,8),
  (215,14375,31,8),
  (215,0,2004,4),
  (215,14375,81,8),
  (215,14375,37,8),
  (215,14375,1,8),
  (215,14375,11,8),
  (216,62215,11,17),
  (216,70330,58,6),
  (216,64920,96,6),
  (216,62215,39,17),
  (216,64920,15,6),
  (216,62215,75,17),
  (216,64920,17,6),
  (216,62215,1,17),
  (216,81150,72,3),
  (216,62215,31,17),
  (216,62215,47,6),
  (216,64920,53,13);

COMMIT;

INSERT INTO `merchant_buylists` (`item_id`, `price`, `shop_id`, `order`) VALUES
  (216,62215,37,17),
  (216,62215,77,17),
  (216,0,2004,5),
  (216,62215,81,17),
  (216,62215,33,17),
  (216,62215,83,17),
  (217,0,2004,6),
  (218,163200,5806,2),
  (218,156400,47,9),
  (218,163200,5800,2),
  (218,156400,77,20),
  (218,156400,33,20),
  (218,0,2004,7),
  (218,163202,125,2),
  (218,163202,105,2),
  (218,156400,11,20),
  (218,163202,123,2),
  (218,163200,96,9),
  (218,163202,107,2),
  (218,156400,1,20),
  (218,163200,17,9),
  (218,156400,75,20),
  (218,176800,58,9),
  (218,156400,81,20),
  (218,163200,15,9),
  (218,163200,53,16),
  (218,163200,69,2),
  (218,156400,37,20),
  (218,156400,31,20),
  (218,163200,61,2),
  (218,149600,27,2),
  (218,156400,39,20),
  (218,149600,25,2),
  (218,156400,83,20),
  (219,292800,17,13),
  (219,292800,96,13),
  (219,292800,53,20),
  (219,280600,47,13),
  (219,292804,107,6),
  (219,317200,58,13),
  (219,268400,25,6),
  (219,292800,5806,6),
  (219,0,2004,8),
  (219,292800,15,13),
  (219,292804,105,6),
  (219,292800,69,6),
  (219,292804,123,6),
  (219,292800,5800,6),
  (219,268400,27,6),
  (219,292800,61,6),
  (219,292804,125,6),
  (220,613500,21,2),
  (220,490800,15,19),
  (220,449900,27,12),
  (220,449900,25,12),
  (220,490800,96,19),
  (220,490806,105,12),
  (220,490800,53,26),
  (220,490800,61,12),
  (220,531700,58,19),
  (220,490800,5806,12),
  (220,470350,47,19),
  (220,490806,123,12),
  (220,490806,107,12),
  (220,490800,17,19),
  (220,0,2004,9),
  (220,490806,125,12),
  (220,490800,69,12),
  (220,490800,5800,12),
  (221,531700,58,20),
  (221,449900,25,13),
  (221,613500,72,10),
  (221,490800,69,13),
  (221,490806,125,13),
  (221,490800,5806,13),
  (221,490806,107,13),
  (221,490806,105,13),
  (221,490800,5800,13),
  (221,470350,47,20),
  (221,613500,21,3),
  (221,490800,61,13),
  (221,490800,17,20),
  (221,490806,123,13),
  (221,449900,27,13),
  (221,490800,53,27),
  (221,490800,96,20),
  (221,0,2004,10),
  (221,490800,15,20),
  (222,772810,123,21),
  (222,772810,107,21),
  (222,772810,105,21),
  (222,708400,27,21),
  (222,772800,61,20),
  (222,0,2004,11),
  (222,772800,5806,21),
  (222,708400,25,21),
  (222,772810,125,21),
  (222,966000,21,9),
  (222,772800,69,20),
  (222,772800,5800,21),
  (223,1160415,105,31),
  (223,0,2004,12),
  (223,1160400,5800,31),
  (223,1160415,107,31),
  (223,1063700,25,31),
  (223,1160400,5806,31),
  (223,1160415,125,31),
  (223,1063700,27,31),
  (223,1160415,123,31),
  (224,1680000,5806,37),
  (224,0,2004,13),
  (224,1540000,27,37),
  (224,1680021,107,37),
  (224,1680021,123,37),
  (224,1680000,5800,37),
  (224,1680021,125,37),
  (224,1540000,25,37),
  (224,1680021,105,37),
  (225,0,2004,14),
  (226,0,2004,15),
  (227,0,2004,16),
  (228,0,2004,17),
  (229,0,2004,18),
  (230,0,2004,19),
  (231,0,2004,20),
  (232,0,2004,21),
  (233,0,2004,22),
  (234,0,2004,23),
  (235,0,2004,24),
  (236,0,2004,25),
  (237,0,2004,26),
  (238,0,2004,27),
  (238,1160415,126,18),
  (238,1063700,26,18),
  (238,1112050,43,9),
  (238,1160400,62,18),
  (238,1063700,30,17),
  (238,1160400,70,18),
  (238,1160415,124,18),
  (238,1160400,95,9),
  (238,1160415,108,18),
  (238,1160400,5801,18),
  (238,1160415,106,18),
  (238,1063700,28,18),
  (238,1160400,5807,18),
  (238,1063700,10,17),
  (239,0,2004,28),
  (239,1063700,26,19),
  (239,1112050,43,10),
  (239,1160415,124,19),
  (239,1160415,108,19),
  (239,1160400,95,10),
  (239,1160400,70,19),
  (239,1063700,28,19),
  (239,1063700,10,18),
  (239,1160415,126,19),
  (239,1160415,106,19),
  (239,1160400,62,19),
  (239,1063700,30,18),
  (240,1160415,106,20),
  (240,1160415,108,20),
  (240,1160400,95,11),
  (240,1160400,70,20),
  (240,1160415,126,20),
  (240,1063700,10,19),
  (240,1063700,28,20),
  (240,0,2004,29),
  (240,1160400,62,20),
  (240,1112050,43,11),
  (240,1160415,124,20),
  (240,1063700,30,19),
  (240,1063700,26,20),
  (241,1063700,28,21),
  (241,1160415,126,21),
  (241,1160415,106,21),
  (241,1160400,95,12),
  (241,0,2004,30),
  (241,1112050,43,12),
  (241,1063700,26,21),
  (241,1160415,108,21),
  (241,1160415,124,21),
  (242,0,2004,31),
  (243,0,2004,32),
  (244,0,2006,1),
  (245,0,2006,2),
  (246,0,2006,3),
  (247,0,2006,4),
  (248,0,2006,5),
  (249,0,2006,6),
  (250,0,2006,7),
  (251,0,2006,8),
  (252,0,2006,9),
  (253,0,2007,1),
  (253,883,83,23),
  (253,883,81,23),
  (254,14375,81,24),
  (254,14375,83,24),
  (254,15000,53,33),
  (254,0,2007,2),
  (255,62215,83,25),
  (255,64920,53,34),
  (255,62215,81,25),
  (255,0,2007,3),
  (256,163200,17,26),
  (256,163200,53,35),
  (256,0,2007,4),
  (256,156400,83,26),
  (256,176800,58,26),
  (256,163200,96,26),
  (256,156400,47,26),
  (256,163202,105,44),
  (256,163200,5800,44),
  (256,163202,123,44),
  (256,163200,61,25),
  (256,149600,25,44),
  (256,163202,107,44),
  (256,163202,125,44),
  (256,163200,5806,44),
  (256,149600,27,44),
  (256,163200,69,25),
  (256,156400,81,26),
  (256,163200,15,26),
  (257,292804,125,45),
  (257,292804,123,45),
  (257,292800,69,26),
  (257,292800,5806,45),
  (257,292800,61,26),
  (257,292800,15,27),
  (257,292800,5800,45),
  (257,292800,53,36),
  (257,292800,17,27),
  (257,317200,58,27),
  (257,268400,25,45),
  (257,292804,105,45),
  (257,0,2007,5),
  (257,280600,47,27),
  (257,292800,96,27),
  (257,292804,107,45),
  (257,268400,27,45),
  (258,490800,96,28),
  (258,470350,47,28),
  (258,531700,58,28),
  (258,490806,105,46),
  (258,490800,17,28),
  (258,449900,27,46),
  (258,490800,15,28),
  (258,490800,61,27),
  (258,0,2007,6),
  (258,490800,53,37),
  (258,449900,25,46),
  (258,490800,69,27),
  (258,490800,5806,46),
  (258,490806,125,46),
  (258,490806,107,46),
  (258,490800,5800,46),
  (258,490806,123,46),
  (259,772800,5800,47),
  (259,772810,123,47),
  (259,708400,25,47),
  (259,772810,105,47),
  (259,708400,27,47),
  (259,772810,125,47),
  (259,0,2007,7),
  (259,772810,107,47),
  (259,772800,61,28),
  (259,772800,5806,47),
  (259,772800,69,28),
  (260,1160415,125,48),
  (260,1063700,25,48),
  (260,1160415,123,48),
  (260,1160415,105,48),
  (260,0,2007,8),
  (260,1160400,5806,48),
  (260,1063700,27,48),
  (260,1160415,107,48),
  (260,1160400,5800,48),
  (261,1540000,25,49),
  (261,0,2007,9),
  (261,1540000,27,49),
  (261,1680021,125,49),
  (261,1680021,107,49),
  (261,1680000,5806,49),
  (261,1680021,123,49),
  (261,1680021,105,49),
  (261,1680000,5800,49),
  (262,0,2007,10),
  (263,0,2007,11),
  (264,0,2007,12),
  (265,0,2007,13),
  (266,0,2007,14),
  (267,0,2007,15),
  (268,0,2007,16),
  (269,0,2007,17),
  (270,0,2007,18),
  (271,62215,81,18),
  (271,62215,37,18),
  (271,62215,77,18),
  (271,62215,33,18),
  (271,70330,58,7),
  (271,62215,11,18),
  (271,62215,31,18),
  (271,0,2005,3),
  (271,64920,15,7),
  (271,62215,47,7),
  (271,62215,75,18),
  (271,62215,39,18),
  (271,62215,1,18),
  (271,64920,53,14),
  (271,62215,83,18),
  (271,64920,96,7),
  (271,64920,17,7),
  (271,81150,72,4),
  (272,156400,37,21),
  (272,156400,11,21),
  (272,149600,27,3),
  (272,156400,1,21),
  (272,163202,125,3),
  (272,163202,107,3),
  (272,156400,33,21),
  (272,156400,83,21),
  (272,156400,75,21),
  (272,156400,77,21),
  (272,0,2005,4),
  (272,163202,123,3),
  (272,163200,15,10),
  (272,156400,81,21),
  (272,149600,25,3),
  (272,163200,69,3),
  (272,163200,96,10),
  (272,163200,53,17),
  (272,156400,47,10),
  (272,163202,105,3),
  (272,163200,5800,3),
  (272,156400,39,21),
  (272,176800,58,10),
  (272,163200,17,10),
  (272,163200,61,3),
  (272,156400,31,21),
  (272,163200,5806,3),
  (273,317200,58,14),
  (273,292800,69,7),
  (273,366000,72,8),
  (273,292800,17,14),
  (273,292800,15,14),
  (273,292800,5806,7),
  (273,292804,105,7),
  (273,292804,123,7),
  (273,292804,107,7),
  (273,292800,5800,7),
  (273,0,2005,5),
  (273,268400,27,7),
  (273,268400,25,7),
  (273,292800,96,14),
  (273,292800,61,7),
  (273,280600,47,14),
  (273,292804,125,7),
  (273,292800,53,21),
  (274,490800,5800,14),
  (274,490806,125,14),
  (274,490806,105,14),
  (274,490800,15,21),
  (274,490800,69,14),
  (274,490800,53,28),
  (274,490800,17,21),
  (274,490800,96,21),
  (274,490800,61,14),
  (274,490806,107,14),
  (274,449900,27,14),
  (274,0,2005,6),
  (274,449900,25,14),
  (274,490800,5806,14),
  (274,470350,47,21),
  (274,490806,123,14),
  (274,531700,58,21),
  (275,772800,69,21),
  (275,966000,21,10),
  (275,0,2005,7),
  (275,772810,123,22),
  (275,772800,5800,22),
  (275,772800,5806,22),
  (275,708400,27,22),
  (275,772810,125,22),
  (275,772810,105,22),
  (275,708400,25,22),
  (275,772800,61,21),
  (275,772810,107,22),
  (276,772810,105,23),
  (276,772810,123,23),
  (276,772810,107,23),
  (276,772800,5800,23),
  (276,0,2005,8),
  (276,772800,5806,23),
  (276,708400,25,23),
  (276,772810,125,23),
  (276,708400,27,23),
  (277,772800,5800,24),
  (277,772800,69,22),
  (277,772810,107,24),
  (277,772810,105,24),
  (277,772800,61,22),
  (277,772800,5806,24),
  (277,708400,25,24),
  (277,772810,125,24),
  (277,0,2005,9),
  (277,772810,123,24),
  (277,708400,27,24),
  (278,1160415,107,32),
  (278,1160415,123,32),
  (278,1160415,125,32),
  (278,0,2005,10),
  (278,1160400,5800,32),
  (278,1160400,5806,32),
  (278,1063700,25,32),
  (278,1063700,27,32),
  (278,1160415,105,32),
  (279,1680021,125,39),
  (279,1680021,107,39),
  (279,1540000,25,39),
  (279,1680000,5806,39),
  (279,1680021,123,39),
  (279,1680021,105,39),
  (279,1680000,5800,39),
  (279,1540000,27,39),
  (279,0,2005,11),
  (280,0,2005,12),
  (281,0,2005,13),
  (282,0,2005,14),
  (283,0,2005,15),
  (284,0,2005,16),
  (285,0,2005,17),
  (286,0,2005,18),
  (287,0,2005,19),
  (288,0,2005,20),
  (289,0,2005,21),
  (290,0,2005,22),
  (291,449900,25,18),
  (291,613500,21,7),
  (291,613500,72,12),
  (291,490800,5806,18),
  (291,490800,96,25),
  (291,490800,5800,18),
  (291,490806,125,18),
  (291,490800,17,25),
  (291,470350,47,25),
  (291,490800,69,18),
  (291,531700,58,25),
  (291,449900,27,18),
  (291,490800,61,18),
  (291,490806,123,18),
  (291,490800,53,32),
  (291,490800,15,25),
  (291,490806,105,18),
  (291,0,2008,9),
  (291,490806,107,18),
  (292,772800,5806,26),
  (292,772810,125,26),
  (292,772810,105,26),
  (292,772810,107,26),
  (292,0,2008,10),
  (292,708400,25,26),
  (292,708400,27,26),
  (292,772800,61,23),
  (292,772800,5800,26),
  (292,772810,123,26),
  (292,772800,69,23),
  (293,1160415,125,34),
  (293,1063700,27,34),
  (293,1160415,123,34),
  (293,1160415,105,34),
  (293,1063700,25,34),
  (293,0,2008,11),
  (293,1160400,5806,34),
  (293,1160415,107,34),
  (293,1160400,5800,34),
  (294,1540000,25,42),
  (294,1680021,123,42),
  (294,1680000,5800,42),
  (294,0,2008,12),
  (294,1680021,125,42),
  (294,1680000,5806,42),
  (294,1680021,107,42),
  (294,1680021,105,42),
  (294,1540000,27,42),
  (295,772800,61,24),
  (295,772810,125,27),
  (295,772800,5800,27),
  (295,772800,69,24),
  (295,772810,107,27),
  (295,772800,5806,27),
  (295,0,2008,13),
  (295,708400,25,27),
  (295,708400,27,27),
  (295,772810,105,27),
  (295,772810,123,27),
  (296,1063700,27,35),
  (296,1160400,5800,35),
  (296,1063700,25,35),
  (296,1160400,5806,35),
  (296,1160415,107,35),
  (296,1160415,105,35);

COMMIT;

INSERT INTO `merchant_buylists` (`item_id`, `price`, `shop_id`, `order`) VALUES
  (296,1160415,123,35),
  (296,1160415,125,35),
  (296,0,2008,14),
  (297,0,2008,15),
  (298,0,2008,16),
  (299,0,2008,17),
  (300,0,2008,18),
  (301,0,2008,19),
  (302,0,2008,20),
  (303,0,2008,21),
  (304,0,2008,22),
  (305,0,2008,23),
  (306,0,2008,24),
  (307,0,2008,25),
  (308,883,78,2),
  (308,0,2012,4),
  (308,883,12,2),
  (308,883,2,2),
  (308,883,32,2),
  (308,883,40,2),
  (308,883,76,2),
  (308,883,34,2),
  (308,883,84,2),
  (308,883,38,2),
  (308,883,82,2),
  (309,0,2012,5),
  (310,163200,62,2),
  (310,163200,70,2),
  (310,156400,40,7),
  (310,156400,84,7),
  (310,163202,124,2),
  (310,163202,106,2),
  (310,156400,82,7),
  (310,156400,48,3),
  (310,163200,5801,2),
  (310,0,2012,6),
  (310,149600,28,2),
  (310,156400,34,7),
  (310,156400,32,7),
  (310,163200,97,3),
  (310,163202,126,2),
  (310,156400,38,7),
  (310,149600,26,2),
  (310,163200,5807,2),
  (310,156400,78,7),
  (310,163202,108,2),
  (310,163200,54,5),
  (310,156400,2,7),
  (310,176800,59,3),
  (310,163200,18,3),
  (310,163200,16,3),
  (310,204000,73,2),
  (310,156400,12,7),
  (310,156400,76,7),
  (311,268400,26,4),
  (311,292800,5807,4),
  (311,292800,62,4),
  (311,268400,30,4),
  (311,292800,97,5),
  (311,268400,10,4),
  (311,292800,5801,4),
  (311,317200,59,5),
  (311,292804,108,4),
  (311,268400,28,4),
  (311,292804,126,4),
  (311,292800,70,4),
  (311,292800,54,7),
  (311,292800,16,5),
  (311,292800,18,5),
  (311,280600,48,5),
  (311,0,2012,7),
  (311,292804,124,4),
  (311,292804,106,4),
  (312,490806,108,8),
  (312,490800,18,9),
  (312,490800,16,9),
  (312,490800,62,8),
  (312,449900,10,8),
  (312,449900,30,8),
  (312,490806,126,8),
  (312,490800,5807,8),
  (312,449900,26,8),
  (312,0,2012,8),
  (312,490806,124,8),
  (312,449900,28,8),
  (312,490800,54,11),
  (312,490800,5801,8),
  (312,470350,48,9),
  (312,490806,106,8),
  (312,490800,70,8),
  (312,531700,59,9),
  (312,490800,97,9),
  (313,0,2012,9),
  (314,490800,5801,9),
  (314,490800,97,10),
  (314,449900,28,9),
  (314,613500,73,6),
  (314,449900,10,9),
  (314,490800,5807,9),
  (314,449900,26,9),
  (314,490806,126,9),
  (314,490800,62,9),
  (314,490806,106,9),
  (314,490806,124,9),
  (314,490800,18,10),
  (314,470350,48,10),
  (314,490800,16,10),
  (314,449900,30,9),
  (314,490806,108,9),
  (314,490800,54,12),
  (314,0,2012,10),
  (314,531700,59,10),
  (314,490800,70,9),
  (315,772810,106,14),
  (315,772810,108,14),
  (315,772800,95,5),
  (315,740600,43,5),
  (315,0,2012,11),
  (315,772800,70,14),
  (315,772800,62,14),
  (315,772810,124,14),
  (315,708400,28,14),
  (315,708400,30,13),
  (315,772800,5807,14),
  (315,772810,126,14),
  (315,772800,5801,14),
  (315,708400,26,14),
  (315,708400,10,13),
  (316,1160415,108,23),
  (316,1160415,124,23),
  (316,1112050,43,14),
  (316,1063700,28,23),
  (316,1160415,126,23),
  (316,0,2012,12),
  (316,1063700,26,23),
  (316,1160415,106,23),
  (316,1160400,95,14),
  (317,1112050,43,15),
  (317,1063700,26,24),
  (317,1160415,106,24),
  (317,1063700,28,24),
  (317,1160400,95,15),
  (317,1160415,108,24),
  (317,0,2012,13),
  (317,1160415,124,24),
  (317,1160415,126,24),
  (318,1540000,28,26),
  (318,1680021,106,26),
  (318,0,2012,14),
  (318,1680021,108,26),
  (318,1680021,126,26),
  (318,1680000,5807,20),
  (318,1540000,26,26),
  (318,1680021,124,26),
  (318,1680000,5801,20),
  (319,0,2012,15),
  (320,0,2012,16),
  (321,1824023,108,27),
  (321,1824023,126,27),
  (321,1824023,124,27),
  (321,1824000,5801,21),
  (321,1672000,26,27),
  (321,1824023,106,27),
  (321,0,2012,17),
  (321,1672000,28,27),
  (321,1824000,5807,21),
  (322,0,2012,18),
  (323,0,2012,19),
  (324,0,2012,20),
  (325,0,2012,21),
  (326,0,2012,22),
  (327,0,2012,23),
  (328,0,2012,24),
  (329,0,2012,25),
  (330,0,2012,26),
  (331,0,2012,27),
  (332,0,2012,28),
  (333,0,2012,29),
  (334,0,2012,30),
  (335,0,2012,31),
  (336,0,2012,32),
  (337,0,2012,33),
  (338,0,2012,34),
  (339,0,2012,35),
  (340,0,2012,36),
  (341,0,2012,37),
  (342,0,2012,38),
  (343,0,2012,39),
  (344,0,2012,40),
  (345,0,2012,41),
  (346,0,2012,42),
  (347,108550,87,14),
  (347,100200,69,40),
  (347,125250,72,19),
  (347,100200,129,12),
  (347,100200,98,14),
  (347,100200,109,12),
  (347,100200,111,12),
  (347,100200,127,12),
  (347,0,1001,10),
  (347,100200,15,42),
  (347,125250,21,12),
  (347,100200,17,42),
  (347,100200,55,14),
  (347,96025,49,14),
  (347,100200,61,40),
  (347,91850,5,12),
  (347,91850,3,12),
  (348,159600,127,17),
  (348,146300,5,17),
  (348,159600,111,17),
  (348,0,1001,11),
  (348,159600,109,17),
  (348,159600,129,17),
  (348,146300,3,17),
  (348,159600,5802,16),
  (348,159600,5804,16),
  (349,219600,109,18),
  (349,201300,5,18),
  (349,219600,5802,18),
  (349,0,1001,12),
  (349,219600,5804,18),
  (349,201300,3,18),
  (349,219600,111,18),
  (349,219600,127,18),
  (349,219600,129,18),
  (350,0,1001,13),
  (350,219600,127,19),
  (350,219600,5802,20),
  (350,219600,109,19),
  (350,219600,5804,20),
  (350,219600,111,19),
  (350,219600,129,19),
  (350,201300,5,19),
  (350,201300,3,19),
  (351,223300,5,24),
  (351,243600,129,24),
  (351,243600,109,24),
  (351,243600,127,24),
  (351,0,1001,14),
  (351,223300,3,24),
  (351,243600,111,24),
  (352,328900,3,30),
  (352,358800,109,31),
  (352,358800,5802,28),
  (352,358800,129,31),
  (352,328900,5,30),
  (352,358800,127,31),
  (352,0,1001,15),
  (352,358800,111,31),
  (352,358800,5804,28),
  (353,0,1001,16),
  (354,0,1001,17),
  (355,0,1001,18),
  (356,0,1001,19),
  (357,0,1001,20),
  (358,0,1001,21),
  (359,0,1001,22),
  (360,0,1001,23),
  (361,0,1001,24),
  (362,0,1001,25),
  (363,0,1001,26),
  (364,0,1001,27),
  (365,0,1001,28),
  (366,0,1001,29),
  (367,0,1001,30),
  (368,0,1001,31),
  (369,0,1001,32),
  (370,0,1001,33),
  (371,0,1001,34),
  (372,0,1001,35),
  (373,0,1001,36),
  (374,0,1001,37),
  (375,0,1001,38),
  (376,62640,109,14),
  (376,62640,127,14),
  (376,78300,21,14),
  (376,57420,3,14),
  (376,62640,111,14),
  (376,57420,5,14),
  (376,0,1002,9),
  (376,62640,129,14),
  (377,0,1002,10),
  (377,99960,129,23),
  (377,91630,5,23),
  (377,91630,3,23),
  (377,99960,5804,15),
  (377,99960,5802,15),
  (377,99960,109,23),
  (377,99960,127,23),
  (377,99960,111,23),
  (378,152400,5804,17),
  (378,152400,111,25),
  (378,0,1002,11),
  (378,152400,109,25),
  (378,152400,5802,17),
  (378,139700,3,25),
  (378,152400,129,25),
  (378,152400,127,25),
  (378,139700,5,2

ну а в файле ида предметов так се запущено)))

зайди на wwwl2dc.ru  найди скил который те надо, наведи на него мишкой и внизу так где показывает адрес куда ты попадешь будет в конце написан ай-ди и левел скила