SET CHARACTER SET UTF8;
--
-- Table structure for table `testtbl`
--

DROP TABLE IF EXISTS `testtbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testtbl` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_nam` int(10) unsigned NOT NULL,
  `id_nam_partition` tinyint(2) unsigned NOT NULL,
  `stop_view_sootv` tinyint(1) NOT NULL DEFAULT 0,
  `nam` varchar(250) NOT NULL,
  `nam_etiketka` varchar(250) NOT NULL,
  `nam_description` text NOT NULL,
  `codeATX` varchar(9) NOT NULL,
  `id_strany` int(10) unsigned NOT NULL,
  `doli` mediumint(4) unsigned NOT NULL DEFAULT 1000,
  `okrb` varchar(12) NOT NULL,
  `tnved` varchar(10) NOT NULL,
  `ves_kg` decimal(7,3) NOT NULL,
  `recept` enum('','да','нет') NOT NULL DEFAULT '',
  `obiaz` enum('да','нет') NOT NULL DEFAULT 'нет',
  `spec_hran` enum('да','нет') NOT NULL DEFAULT 'нет',
  `id_nam_hran` int(10) unsigned NOT NULL DEFAULT 1,
  `lst` varchar(5) NOT NULL,
  `p_bc` varchar(13) NOT NULL,
  `p_bc2` varchar(13) NOT NULL,
  `p_bc3` varchar(13) NOT NULL,
  `p_cena` decimal(15,2) NOT NULL DEFAULT 0.00,
  `cena_base` decimal(15,2) NOT NULL DEFAULT 0.00,
  `nam_simplified` varchar(250) NOT NULL,
  `nam_zavod` varchar(250) NOT NULL,
  `last_usage` date NOT NULL,
  `ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `nam` (`nam`),
  UNIQUE KEY `id_nam` (`id_nam`,`id`),
  UNIQUE KEY `nam_partition` (`id_nam_partition`,`id`),
  UNIQUE KEY `barcode2` (`p_bc2`,`id`),
  UNIQUE KEY `barcode` (`p_bc`,`id`),
  UNIQUE KEY `barcode3` (`p_bc3`,`id`),
  KEY `ts` (`ts`),
  KEY `nam_hran` (`id_nam_hran`),
  KEY `npn` (`id_nam_partition`,`id_nam`,`nam`),
  KEY `nam_simplified` (`nam_simplified`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5201898 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci PACK_KEYS=1 ROW_FORMAT=DYNAMIC COMMENT='';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testtbl`
--

LOCK TABLES `testtbl` WRITE;
/*!40000 ALTER TABLE `testtbl` DISABLE KEYS */;
INSERT INTO `testtbl` VALUES
(20213,70939,1,0,'0.012696763512396033','','','',0,1000,'','',0.000,'нет','нет','нет',1,'','4602233003399','','',0.00,0.00,'','','2021-05-01','2023-10-05 22:14:34'),
(21375,0,5,0,'0.7372403673243153','','','',0,1,'','',0.000,'','нет','нет',1,'','4607024580011','','',0.00,0.00,'','','2021-05-01','2023-10-05 22:14:34'),
(25670,0,11,0,'0.6481115768180337','','','',0,1,'','',0.000,'','нет','нет',1,'','5900516691721','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:15:00'),
(31139,0,11,0,'0.028836812850867224','','','',0,1000,'','',0.000,'','нет','нет',1,'','4820048480970','','',0.00,0.00,'','','2023-01-08','2023-10-05 22:14:34'),
(144222,19973,0,0,'0.19984936453388014','','','',0,1000,'','3004200001',0.000,'','нет','нет',1,'','4840456000218','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(147628,323026,0,0,'0.912736414850444','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810046002915','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(160187,30211,0,0,'0.9641340113842245','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-12-13','2023-10-05 22:14:34'),
(184389,0,2,0,'0.08246084310343568','','','',0,1,'','',0.000,'','нет','нет',1,'','4602233004983','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:15:00'),
(209701,210063,0,0,'0.5199022120981498','','','',0,1000,'','',0.000,'','нет','нет',1,'','3838957048373','','',0.00,0.00,'','','2022-12-06','2023-10-05 22:14:34'),
(220270,20006,0,0,'0.35212856191408687','','','',0,1000,'','',0.000,'','нет','нет',1,'','3582910026723','','',0.00,0.00,'','','2022-07-01','2023-10-05 22:14:34'),
(234544,0,7,0,'0.20093620400962997','','','',0,1000,'','',0.000,'','нет','нет',1,'','4008600067153','','',0.00,0.00,'','','2021-02-01','2023-10-05 22:14:34'),
(256119,70939,3,0,'0.9482953650395343','','','',0,1000,'','',0.000,'','нет','нет',1,'','4607040643875','','',0.00,0.00,'','','2021-05-01','2023-10-05 22:14:34'),
(269719,0,3,0,'0.13866824390242644','','','',0,1000,'','',0.000,'','нет','нет',1,'','3600540199454','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(276997,0,1,0,'0.8484551551271744','','','',0,1,'','',0.000,'нет','нет','нет',1,'','4602193010635','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(278130,576298,0,0,'0.8262710746622375','','','',0,1000,'','',0.000,'','нет','нет',1,'','4823000805613','','',0.00,0.00,'','','2022-06-07','2023-10-05 22:14:34'),
(293685,27737,0,0,'0.5859899386633094','','','',0,1000,'','',0.000,'','нет','нет',1,'','4823060802089','','',0.00,0.00,'','','2022-02-08','2023-10-05 22:14:34'),
(314017,26434,0,0,'0.45113650006347944','','','',0,1000,'','',0.000,'','нет','нет',1,'','5995327153520','','',0.00,0.00,'','','2022-12-14','2023-10-05 22:14:34'),
(339956,0,1,0,'0.4977127150611139','','','',0,1,'','',0.000,'','нет','нет',1,'','4810201008097','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(354236,669567,0,0,'0.13515410584877627','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-10','2023-10-05 22:14:34'),
(364615,446073,3,0,'0.18263241479418466','','','',0,1,'','',0.000,'','нет','нет',1,'','4015600862268','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(365494,26463,0,0,'0.5076997871582394','','','',0,1000,'','',0.000,'','нет','нет',1,'','4601026301773','','',0.00,0.00,'','','2021-12-12','2023-10-05 22:14:34'),
(365778,338133,0,0,'0.9906017221422883','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810201003184','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(375788,233132,0,0,'0.4299092799703677','','','',0,1000,'','',0.000,'','нет','нет',1,'','4660014181339','','',0.00,0.00,'','','2021-03-11','2023-10-05 22:14:34'),
(377387,0,3,0,'0.17774126415861888','','','',0,1,'','',0.000,'','нет','нет',1,'','5907609395900','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(378767,340602,0,0,'0.5989785116156363','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810183004599','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(382023,855703,12,0,'0.46166879633596986','','','',0,1000,'','',0.000,'нет','нет','нет',1,'','4820057042060','','',0.00,0.00,'','','2022-12-19','2023-10-05 22:14:34'),
(392203,440571,0,0,'0.5114084775665854','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810183008023','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(393658,20227,0,0,'0.17203602955866235','','','',0,1000,'','',0.000,'','нет','нет',1,'','4031083004858','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(399904,664172,0,0,'0.3259547458272006','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810368008176','','',0.00,0.00,'','','2021-08-02','2023-10-05 22:14:34'),
(434506,433537,0,0,'0.11366567119366086','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812608005563','','',0.00,0.00,'','','2022-03-30','2023-10-05 22:14:34'),
(440371,0,3,0,'0.5904641492203475','','','',0,1,'','',0.000,'','нет','нет',1,'','5900117094365','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(454364,20680,0,0,'0.6113237632544001','','','',0,1000,'','',0.000,'','нет','нет',1,'','8901079004444','','',0.00,0.00,'','','2023-01-17','2023-10-05 22:14:34'),
(460197,497299,0,0,'0.285226399344603','','','',0,1000,'','',0.000,'','нет','нет',1,'','4606257000099','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(462411,0,11,0,'0.5921607376934594','','','',0,1,'','',0.000,'','нет','нет',1,'','8001090239327','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:15:00'),
(464055,30880,0,0,'0.10512452116713349','','','',0,1000,'','',0.000,'','нет','нет',1,'','8901079005144','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(483084,433388,0,0,'0.749140423488934','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-01-11','2023-10-05 22:14:34'),
(498394,0,5,0,'0.4303285846769145','','','',0,1,'','',0.000,'','да','нет',1,'','4812635001552','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(508107,0,11,0,'0.9042216836514153','','','',0,1,'','',0.000,'','нет','нет',1,'','4607091486407','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(511589,19981,0,0,'0.23012269495997828','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(512398,544876,0,0,'0.43794845457929044','','','',0,1000,'','',0.000,'','нет','нет',1,'','5000167009682','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(516305,30905,0,0,'0.49937421875016225','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-01-11','2023-10-05 22:14:34'),
(536598,19915,0,0,'0.18302576074658497','','','',0,1000,'','',0.000,'','нет','нет',1,'','8002660018717','','',0.00,0.00,'','','2023-01-11','2023-10-05 22:14:34'),
(543944,3546522,0,0,'0.41700617821608316','','','',0,1000,'','',0.000,'','нет','нет',1,'','5900717169081','','',0.00,0.00,'','','2022-05-18','2023-10-05 22:14:34'),
(558006,0,0,0,'0.5359536395743058','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(567714,0,0,0,'0.4287496939569243','','','',0,1000,'','',0.000,'','нет','нет',1,'','2000000672953','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(578051,3614958,0,0,'0.5358875817953493','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2021-04-12','2023-10-05 22:14:34'),
(585623,35596,0,0,'0.39318885783961866','','','',0,1000,'','',0.000,'','нет','нет',1,'','5997001362884','','',0.00,0.00,'','','2022-10-05','2023-10-05 22:14:34'),
(590306,902646,0,0,'0.3582815745456904','','','',0,1000,'','',0.000,'','нет','нет',1,'','4600697171081','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(625510,1780574,3,0,'0.6118413299432409','','','',0,1,'','',0.000,'','нет','нет',1,'','5902026461795','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(642811,19957,0,0,'0.9843619568127785','','','',0,1000,'','',0.000,'нет','нет','нет',1,'','8901148225558','','',0.00,0.00,'','','2022-06-15','2023-10-05 22:14:34'),
(663789,699630,0,0,'0.08628582496781445','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2021-05-25','2023-10-05 22:14:34'),
(683938,364848,0,0,'0.4783432851343819','','','',0,1000,'','',0.000,'','нет','нет',1,'','4009932557619','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(684086,256091,0,0,'0.13285898150211106','','','',0,1000,'','',0.000,'','нет','нет',1,'','4601808006964','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(684241,20131,0,0,'0.22926508284105462','','','',0,1000,'','',0.000,'','нет','нет',1,'','4607045190268','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(684735,341434,0,0,'0.7477485004325849','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810243001926','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(687872,0,1,0,'0.050947284373405656','','','',0,1,'','',0.000,'нет','нет','нет',1,'','4810046007538','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(696288,699359,0,0,'0.011490951302918561','','','',0,1000,'','',0.000,'','нет','нет',1,'','-','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(710471,20106,0,0,'0.9046129341280208','','','',0,1000,'','',0.000,'','нет','нет',1,'','4750232004869','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(723062,436693,0,0,'0.48859184746499346','','','',0,1000,'','',0.000,'','нет','нет',1,'','3838989633059','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(727729,0,3,0,'0.7291204656745498','','','',0,1,'','3307300000',0.000,'','нет','нет',1,'','4815470000131','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:15:00'),
(738473,818144,0,0,'0.1798268167114135','','','',0,1000,'','',0.000,'','нет','нет',1,'','5054094865422','','',0.00,0.00,'','','2021-08-25','2023-10-05 22:14:34'),
(742538,938686,0,0,'0.7117727172670631','','','',0,1000,'','',0.000,'нет','нет','нет',1,'','5415062334072','','',0.00,0.00,'','','2022-02-14','2023-10-05 22:14:34'),
(761186,760382,0,0,'0.019383166934720395','','','',0,1000,'','',0.000,'','нет','нет',1,'','4823015911460','','',0.00,0.00,'','','2021-03-19','2023-10-05 22:14:34'),
(768342,0,3,0,'0.9615977136060574','','','',0,1,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(768751,1689693,0,0,'0.7498390979597709','','','',0,1000,'','',0.000,'','нет','нет',1,'','4052199204321','','',0.00,0.00,'','','2021-10-19','2023-10-05 22:14:34'),
(769354,33184,0,0,'0.8644023797143273','','','',0,1000,'','',0.000,'','нет','нет',1,'','4680007632044','','',0.00,0.00,'','','2021-11-29','2023-10-05 22:14:34'),
(772386,3174839,0,0,'0.07249463542596869','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2021-07-07','2023-10-05 22:14:34'),
(773191,29876,0,0,'0.7692660687205065','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(781765,394104,0,0,'0.6288464680582718','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812635002153','','',0.00,0.00,'','','2022-12-20','2023-10-05 22:14:34'),
(782272,395320,0,0,'0.8364341648634841','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-05-26','2023-10-05 22:14:34'),
(783437,243536,0,0,'0.29563145087625037','','','',0,1000,'','2106909808',0.000,'','нет','нет',1,'','4009932554731','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(785690,3586554,0,0,'0.9688547905244443','','','',0,1000,'','',0.000,'','нет','нет',1,'','8717627100168','','',0.00,0.00,'','','2022-11-24','2023-10-05 22:14:34'),
(794149,20044,0,0,'0.9573796307271156','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(797801,274202,0,0,'0.8803338127958903','','','',0,1000,'','',0.000,'','нет','нет',1,'','5903060016491','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(814967,339383,0,0,'0.5295302025317495','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810201000336','','',0.00,0.00,'','','2022-08-11','2023-10-05 22:14:34'),
(831668,5172022,0,0,'0.006649605004721885','','','',0,1000,'','',0.000,'','нет','нет',1,'','4680002556123','','',0.00,0.00,'','','2022-12-19','2023-10-05 22:14:34'),
(848492,349311,0,0,'0.4446574481620057','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810183010668','','',0.00,0.00,'','','2020-11-03','2023-10-05 22:14:34'),
(848504,842740,0,0,'0.20333845652950783','','','',0,1000,'','',0.000,'','нет','нет',1,'','4640006307923','','',0.00,0.00,'','','2022-12-30','2023-10-05 22:14:34'),
(854643,433863,0,0,'0.6827199688951671','','','',0,1000,'','',0.000,'','нет','нет',1,'','3856013219642','','',0.00,0.00,'','','2021-12-28','2023-10-05 22:14:34'),
(854909,408489,0,0,'0.8035845056209568','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(856796,20791,0,0,'0.9697626521529282','','','',0,1000,'','',0.000,'','нет','нет',1,'','4820044930851','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(858843,682466,0,0,'0.4380597746354153','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2021-02-17','2023-10-05 22:14:34'),
(862395,378275,0,0,'0.28101094745193694','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(862752,352240,0,0,'0.09087544408708387','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810183008924','','',0.00,0.00,'','','2020-04-06','2023-10-05 22:14:34'),
(862772,335311,0,0,'0.6113444088132535','','','',0,1000,'','',0.000,'','нет','нет',1,'','4742225008435','','',0.00,0.00,'','','2020-07-02','2023-10-05 22:14:34'),
(871668,881408,0,0,'0.7840957425386605','','','',0,1000,'','',0.000,'','нет','нет',1,'','4600702061093','','',0.00,0.00,'','','2021-02-10','2023-10-05 22:14:34'),
(872398,339785,0,0,'0.08644551698718733','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-05','2023-10-05 22:14:34'),
(874625,295821,0,0,'0.07994038805360011','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-06-27','2023-10-05 22:14:34'),
(874750,288120,0,0,'0.1403654200400835','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2020-12-09','2023-10-05 22:14:34'),
(875454,338803,0,0,'0.4620059667732622','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-05-11','2023-10-05 22:14:34'),
(916068,112298,0,0,'0.8889336044797056','','','',0,1000,'','',0.000,'','нет','нет',1,'','3838989515911','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(934665,0,0,0,'0.05865015281238607','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(940575,0,3,0,'0.6264499813564587','','','',0,1,'','',0.000,'','нет','нет',1,'','5901845500364','','',0.00,0.00,'','','2021-02-24','2023-10-05 22:14:34'),
(967985,0,5,0,'0.9562994790787803','','','',0,1,'','',0.000,'','нет','нет',1,'','2000001128954','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(968067,0,1,0,'0.9021474820581707','','','',0,1,'','',0.000,'','нет','нет',1,'','3800002302044','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(971336,433991,0,0,'0.6418390037881574','','','',0,1000,'','',0.000,'','нет','нет',1,'','4814183003781','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(975004,838281,0,0,'0.5027526034999198','','','',0,1000,'','',0.000,'','нет','нет',1,'','4603907003400','','',0.00,0.00,'','','2022-12-21','2023-10-05 22:14:34'),
(999670,826048,0,0,'0.5882460368687715','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812635002115','','',0.00,0.00,'','','2022-03-25','2023-10-05 22:14:34'),
(999682,358384,0,0,'0.43297240457774366','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812635002573','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(1148878,0,0,0,'0.4001239430160485','','','',0,1000,'','',0.000,'','нет','нет',1,'','5901549097207','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(1322735,660383,0,0,'0.7017025320806564','','','',0,1000,'','',0.000,'','нет','нет',1,'','4815412001271','','',0.00,0.00,'','','2021-02-11','2023-10-05 22:14:34'),
(1322871,0,1,0,'0.30814086208878166','','','',0,1,'','',0.000,'нет','нет','нет',1,'','4810201017624','','',0.00,2.59,'','','2023-04-04','2023-10-05 22:14:34'),
(1328989,1330321,0,0,'0.43559674493558403','','','',0,1000,'','',0.000,'нет','нет','нет',1,'','4052314333325','','',0.00,0.00,'','','2022-02-12','2023-10-05 22:14:34'),
(1329756,0,0,0,'0.25356116914522014','','','',0,1000,'','',0.000,'','нет','нет',1,'','730821974111','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(1330281,416418,0,0,'0.9610156416529935','','','',0,1000,'','',0.000,'','нет','нет',1,'','5997001307298','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(1382881,0,3,0,'0.04439473156295226','','','',0,1,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-09-21','2023-10-05 22:14:34'),
(1383472,242309,0,0,'0.33892676358942575','','','',0,1000,'','',0.000,'','нет','нет',1,'','4814870000574','','',0.00,0.00,'','','2022-11-07','2023-10-05 22:14:34'),
(1384308,71512,0,0,'0.5614496539919168','','','',0,1000,'','',0.000,'','нет','нет',1,'','6221507010024','','',0.00,0.00,'','','2020-11-24','2023-10-05 22:14:34'),
(1420264,704203,0,0,'0.7904680099249519','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810133005379','','',0.00,0.00,'','','2020-10-14','2023-10-05 22:14:34'),
(1447691,1452463,0,0,'0.26799111838265427','','','',0,1000,'','',0.000,'','нет','нет',1,'','5901330022685','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(1620688,681848,0,0,'0.9685515928720605','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810229000561','','',0.00,0.00,'','','2020-04-23','2023-10-05 22:14:34'),
(1622956,2649618,0,0,'0.03878463994598448','','','',0,1000,'','',0.000,'','нет','нет',1,'','5901928008787','','',0.00,0.00,'','','2020-04-07','2023-10-05 22:14:34'),
(1690630,502619,0,0,'0.28826845184738603','','','',0,1000,'','',0.000,'','нет','нет',1,'','4030855513512','','',0.00,0.00,'','','2021-09-22','2023-10-05 22:14:34'),
(1752629,855808,0,0,'0.3249883701326217','','','',0,1000,'','',0.000,'нет','нет','нет',1,'','4601214005841','','',0.00,0.00,'','','2020-08-31','2023-10-05 22:14:34'),
(1808744,174982,0,0,'0.7601365258545955','','','',0,1000,'','',0.000,'','нет','нет',1,'','4820011182580','','',0.00,0.00,'','','2020-09-28','2023-10-05 22:14:34'),
(1817065,448928,0,0,'0.8257175496087573','','','',0,1000,'','',0.000,'','нет','нет',1,'','5907626703566','','',0.00,0.00,'','','2022-03-30','2023-10-05 22:14:34'),
(1819514,486088,0,0,'0.848178201213645','','','',0,1000,'','',0.000,'','нет','нет',1,'','4811098002359','','',0.00,0.00,'','','2020-07-20','2023-10-05 22:14:34'),
(1820990,1027554,0,0,'0.7637383879755981','','','',0,1000,'','',0.000,'','нет','нет',1,'','4823002208207','','',0.00,0.00,'','','2021-03-23','2023-10-05 22:14:34'),
(1821070,1564158,0,0,'0.27415736697070053','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812608006829','','',0.00,0.00,'','','2021-05-12','2023-10-05 22:14:34'),
(1832644,732256,0,0,'0.07957170166035342','','','',0,1000,'','',0.000,'','нет','нет',1,'','3401353791220','','',0.00,0.00,'','','2022-09-21','2023-10-05 22:14:34'),
(1919120,329985,0,0,'0.5753864381233104','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812608002821','','',0.00,0.00,'','','2022-09-21','2023-10-05 22:14:34'),
(1963431,228624,0,0,'0.6382171163691367','','','',0,1000,'','',0.000,'','нет','нет',1,'','4607011664212','','',0.00,0.00,'','','2023-01-17','2023-10-05 22:14:34'),
(2051174,2581215,0,0,'0.4649262982093974','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810137343248','','',0.00,0.00,'','','2021-07-22','2023-10-05 22:14:34'),
(2058187,449824,0,0,'0.40998017267322184','','','',0,1000,'','',0.000,'','нет','нет',1,'','5391189310444','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2063143,26219,0,0,'0.655121999471562','','','',0,1000,'','',0.000,'','нет','нет',1,'','4870206090992','','',0.00,0.00,'','','2022-03-30','2023-10-05 22:14:34'),
(2114216,706901,0,0,'0.04566951007178939','','','',0,1000,'','',0.000,'','нет','нет',1,'','4602156000321','','',0.00,0.00,'','','2020-09-01','2023-10-05 22:14:34'),
(2115340,2280879,0,0,'0.262981582677906','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812317008299','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2127089,4907004,0,0,'0.17789941390780678','','','',0,1000,'','',0.000,'','нет','нет',1,'','-','','',0.00,0.00,'','','2021-01-28','2023-10-05 22:14:34'),
(2146424,19768,0,0,'0.10055235223896089','','','',0,1000,'','',0.000,'','нет','нет',1,'','5997001357774','','',0.00,0.00,'','','2021-06-16','2023-10-05 22:14:34'),
(2147289,396029,0,0,'0.9690635502050291','','','',0,1000,'','',0.000,'','нет','нет',1,'','4823060800306','','',0.00,0.00,'','','2022-11-22','2023-10-05 22:14:34'),
(2167110,19866,0,0,'0.543660725041908','','','',0,1000,'','',0.000,'','нет','нет',1,'','4029799124144','','',0.00,0.00,'','','2020-09-08','2023-10-05 22:14:34'),
(2208114,0,0,0,'0.8111130053280974','','','',0,1000,'','',0.000,'','нет','нет',1,'','2000001321058','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2237942,2177861,0,0,'0.42458288224840807','','','',0,1000,'','',0.000,'','нет','нет',1,'','4620002180577','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2238056,440296,0,0,'0.6895754259913931','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810183008719','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2245949,2276288,0,0,'0.17412851394538628','','','',0,1000,'','',0.000,'','нет','нет',1,'','4815068007665','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2252328,4503566,0,0,'0.8019163224863972','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812635002818','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2304007,2348658,0,0,'0.487196101329472','','','',0,1000,'','',0.000,'','нет','нет',1,'','4602242006923','','',0.00,0.00,'','','2022-02-22','2023-10-05 22:14:34'),
(2304037,341821,0,0,'0.030231569921813504','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810133005850','','',0.00,0.00,'','','2021-07-27','2023-10-05 22:14:34'),
(2320272,0,12,0,'0.6895695763542965','','','',0,1,'','',0.000,'нет','нет','нет',1,'','8608808142124','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(2339593,2385453,0,0,'0.35715320273968687','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810183013454','','',0.00,0.00,'','','2020-11-09','2023-10-05 22:14:34'),
(2370309,2301436,3,0,'0.71705731536919','','','',0,1,'','',0.000,'','нет','нет',1,'','4008600316954','','',0.00,0.00,'','','2021-10-12','2023-10-05 22:14:34'),
(2406206,562768,0,0,'0.5138269993605343','','','',0,1000,'','',0.000,'','нет','нет',1,'','4811949000091','','',0.00,0.00,'','','2021-12-10','2023-10-05 22:14:34'),
(2494497,2479760,0,0,'0.4179630814287468','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-11','2023-10-05 22:14:34'),
(2582760,2501401,0,0,'0.5483344397957758','','','',0,1000,'','',0.000,'','нет','нет',1,'','4815636000999','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2601036,1505700,0,0,'0.48778298542628346','','','',0,1000,'','',0.000,'','нет','нет',1,'','4815377001040','','',0.00,0.00,'','','2021-04-02','2023-10-05 22:14:34'),
(2607159,1565865,0,0,'0.7939116384777349','','','',0,1000,'','',0.000,'','нет','нет',1,'','2000001248638','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2607399,2499982,0,0,'0.5062092668434691','','','',0,1000,'','',0.000,'','нет','нет',1,'','2000001252154','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2649241,2067434,0,0,'0.149311449517786','','','',0,1000,'','',0.000,'','нет','нет',1,'','8600222200121','','',0.00,0.00,'','','2022-06-02','2023-10-05 22:14:34'),
(2671623,602294,0,0,'0.22792947779216755','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810368011602','','',0.00,0.00,'','','2021-02-17','2023-10-05 22:14:34'),
(2675222,1442189,0,0,'0.6917130711411248','','','',0,1000,'','',0.000,'','нет','нет',1,'','2000001208977','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(2747729,5050931,0,0,'0.7747769530627662','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810133002101','','',0.00,0.00,'','','2022-11-30','2023-10-05 22:14:34'),
(2783967,5066801,0,0,'0.7987455826241017','','','',0,1000,'','',0.000,'','да','нет',1,'','2002003570540','','',0.00,0.00,'','','2022-11-28','2023-10-05 22:14:34'),
(2792963,5197541,0,0,'0.6693970846658546','','','',0,1000,'','',0.000,'','нет','нет',1,'','4030674011701','','',0.00,0.00,'','','2022-03-29','2023-10-05 22:14:34'),
(2847801,0,0,0,'0.9507487061906128','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3002804,504110,0,0,'0.7455523076891455','','','',0,1000,'','',0.000,'','нет','нет',1,'','3800010612708','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3033406,3281273,0,0,'0.875515450607534','','','',0,1000,'','',0.000,'','нет','нет',1,'','8433042012977','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3044269,464544,0,0,'0.14092036070387845','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812635001026','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3174833,3209908,12,0,'0.07805548243043524','','','',0,1,'','',0.000,'нет','нет','нет',1,'','4810598000131','','',0.00,0.00,'','','2021-07-21','2023-10-05 22:14:34'),
(3213372,732236,0,0,'0.9675163607741858','','','',0,1000,'','',0.000,'','нет','нет',1,'','4601834004620','','',0.00,0.00,'','','2022-07-12','2023-10-05 22:14:34'),
(3257505,3141014,0,0,'0.6034153873132685','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810368013699','','',0.00,0.00,'','','2022-01-04','2023-10-05 22:14:34'),
(3331145,1739632,0,0,'0.11452788497743','','','',0,1000,'','',0.000,'','нет','нет',1,'','4815377001002','','',0.00,0.00,'','','2021-09-28','2023-10-05 22:14:34'),
(3512913,3512529,3,0,'0.7623932936809894','','','',0,1,'','',0.000,'','нет','нет',1,'','4605370023343','','',0.00,0.00,'','','2021-10-20','2023-10-05 22:14:34'),
(3514248,26659,0,0,'0.4683828442063023','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3562201,0,3,0,'0.05473437072218803','','','',0,1,'','',0.000,'','нет','нет',1,'','4607011667435','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3644791,0,12,0,'0.8685233517256783','','','',0,1,'','',0.000,'нет','нет','нет',1,'','4607039975932','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3798056,0,3,0,'0.17841367719547235','','','',0,1,'','',0.000,'','нет','нет',1,'','4650001790071','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(3830426,2750628,0,0,'0.28649836153397185','','','',0,1000,'','',0.000,'','нет','нет',1,'','4013054017500','','',0.00,0.00,'','','2022-02-01','2023-10-05 22:14:34'),
(3865951,2251671,2,0,'0.8972508068170871','','','',0,1,'','',0.000,'','нет','нет',1,'','4607034475123','','',0.00,0.00,'','','2022-08-09','2023-10-05 22:14:34'),
(3986258,461867,0,0,'0.6267589802171653','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810201015088','','',0.00,0.00,'','','2022-07-05','2023-10-05 22:14:34'),
(4100597,3586554,0,0,'0.44204251136821','','','',0,1000,'','',0.000,'','нет','нет',1,'','4607013589889','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4178435,0,3,0,'0.329935646923199','','','',0,1,'','',0.000,'','нет','нет',1,'','4690419015700','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4190600,0,2,0,'0.32355073124500994','','','',0,1,'','',0.000,'','нет','нет',1,'','4680019290089','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(4261206,0,5,0,'0.6279467461890976','','','',0,1,'','',0.000,'','нет','нет',1,'','2000001484357','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4269378,0,99,0,'0.16908156794410345','','','',0,1,'','',0.000,'','нет','нет',1,'','2000001486191','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:14:34'),
(4272416,0,0,0,'0.9615676318868693','','','',0,1000,'','',0.000,'','нет','нет',1,'','2000001453247','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4344718,0,0,0,'0.3005934863356813','','','',0,1000,'','',0.000,'','нет','нет',1,'','8058090003687','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4385636,2254539,0,0,'0.6182645667514434','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-06-16','2023-10-05 22:14:34'),
(4453693,2416877,0,0,'0.18954240548381807','','','',0,1000,'','',0.000,'','нет','нет',1,'','5901121009772','','',0.00,0.00,'','','2022-07-05','2023-10-05 22:14:34'),
(4460099,21493,0,0,'0.09291835789840515','','','',0,1000,'','',0.000,'','нет','нет',1,'','4742225001450','','',0.00,0.00,'','','2022-12-26','2023-10-05 22:14:34'),
(4464925,403455,0,0,'0.8959646037742166','','','',0,1000,'','',0.000,'','нет','нет',1,'','3574661104522','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4464963,3823144,0,0,'0.20106797590951248','','','',0,1000,'','',0.000,'','нет','нет',1,'','4640001815911','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4468982,0,0,0,'0.3174460989585576','','','',0,1000,'','',0.000,'','нет','нет',1,'','5411416066149','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4504282,2348761,0,0,'0.9840265977978954','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2022-12-16','2023-10-05 22:14:34'),
(4623574,5197629,0,0,'0.9677947228474494','','','',0,1000,'','',0.000,'','нет','нет',1,'','5900516311575','','',0.00,0.00,'','','2022-12-08','2023-10-05 22:14:34'),
(4643838,26239,0,0,'0.8868938515772055','','','',0,1000,'','',0.000,'','нет','нет',1,'','9088880087886','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(4670176,286124,0,0,'0.5310851200773242','','','',0,1000,'','',0.000,'','нет','нет',1,'','8594739229365','','',0.00,0.00,'','','2022-10-06','2023-10-05 22:14:34'),
(4775709,70939,12,0,'0.9947440763886497','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','0000-00-00','2023-10-05 22:14:34'),
(4867143,433718,0,0,'0.3804650524449209','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810201018416','','',0.00,0.00,'','','2023-01-16','2023-10-05 22:14:34'),
(4867228,2479759,0,0,'0.9180930637923005','','','',0,1000,'','',0.000,'','нет','нет',1,'','4810243006280','','',0.00,0.00,'','','2023-01-16','2023-10-05 22:14:34'),
(4871848,2112559,0,0,'0.4490701923603846','','','',0,1000,'','',0.000,'','нет','нет',1,'','4812608011960','','',0.00,0.00,'','','2023-01-16','2023-10-05 22:14:34'),
(4899683,0,3,0,'0.49107180115866644','','','',0,1,'','',0.000,'','нет','нет',1,'','5907609305916','','',0.00,0.00,'','','2023-04-04','2023-10-05 22:15:00'),
(4941530,341029,0,0,'0.10814845944582341','','','',0,1000,'','',0.000,'','нет','нет',1,'','4814183003217','','',0.00,0.00,'','','2023-01-16','2023-10-05 22:14:34'),
(5051683,4769644,0,0,'0.06752692448676277','','','',0,1000,'','',0.000,'','нет','нет',1,'','4811580000023','','',0.00,0.00,'','','2023-01-16','2023-10-05 22:14:34'),
(5098920,0,11,0,'0.013189274829988624','','','',0,1,'','',0.000,'','нет','нет',1,'','4600890020292','','',0.00,0.00,'','','0000-00-00','2023-10-05 22:14:34'),
(5105823,2475157,0,0,'0.8633656314232998','','','',0,1000,'','',0.000,'','нет','нет',1,'','4032855906103','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34'),
(5181715,483476,0,0,'0.27726036336017806','','','',0,1000,'','',0.000,'','нет','нет',1,'','','','',0.00,0.00,'','','2023-01-09','2023-10-05 22:14:34'),
(5197372,0,1,0,'0.7962049532646359','','','',0,1,'','',0.000,'','нет','нет',1,'','4814575000411','','',0.00,0.00,'','','0000-00-00','2023-10-05 22:14:34'),
(5201897,1520379,0,0,'0.14924370697629052','','','',0,1000,'','',0.000,'','нет','нет',1,'','4815068003759','','',0.00,0.00,'','','2023-01-19','2023-10-05 22:14:34');
/*!40000 ALTER TABLE `testtbl` ENABLE KEYS */;
UNLOCK TABLES;

