--source include/have_innodb.inc

--disable_query_log
DROP TABLE IF EXISTS `day_position`;
CREATE TABLE  `day_position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` int(10) unsigned DEFAULT NULL,
  `sort_index` int(11) DEFAULT NULL,
  `ivehicle_day_id` int(10) unsigned DEFAULT NULL,
  `dirty_data` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `day_position__trans` (`transaction_id`),
  KEY `day_position__is` (`ivehicle_day_id`,`sort_index`),
  KEY `day_position__id` (`ivehicle_day_id`,`dirty_data`)
) ENGINE=InnoDB AUTO_INCREMENT=343476849 DEFAULT CHARSET=utf8 PACK_KEYS=0;

INSERT INTO `day_position` VALUES  (41138,41138,0,733,0),
 (41139,41139,0,734,0),
 (41140,41140,0,735,0),
 (41142,41142,0,737,0),
 (41143,41143,0,738,0),
 (41144,41144,0,739,0),
 (41145,41145,1,738,0),
 (41146,41146,0,740,0),
 (41147,41147,1,740,0),
 (41148,41148,2,740,0),
 (41149,41149,3,740,0),
 (41150,41150,4,740,0),
 (41151,41151,5,740,0),
 (41152,41152,6,740,0),
 (41153,41153,7,740,0),
 (41154,41154,8,740,0),
 (41155,41155,9,740,0),
 (41156,41156,10,740,0),
 (41157,41157,11,740,0),
 (41158,41158,12,740,0),
 (41159,41159,13,740,0),
 (41160,41160,14,740,0),
 (41161,41161,15,740,0),
 (41162,41162,16,740,0),
 (41163,41163,17,740,0),
 (41164,41164,18,740,0),
 (41165,41165,19,740,0),
 (41166,41166,20,740,0),
 (41167,41167,21,740,0),
 (41168,41168,22,740,0),
 (41814,41814,0,744,0),
 (41815,41815,1,744,0),
 (41816,41816,2,744,0),
 (41817,41817,3,744,0),
 (41818,41818,4,744,0),
 (41819,41819,5,744,0),
 (41820,41820,6,744,0),
 (41821,41821,7,744,0),
 (41822,41822,8,744,0),
 (41823,41823,9,744,0),
 (41824,41824,10,744,0),
 (41825,41825,11,744,0),
 (41826,41826,12,744,0),
 (41827,41827,13,744,0),
 (41828,41828,14,744,0),
 (41829,41829,15,744,0),
 (41830,41830,16,744,0),
 (41831,41831,17,744,0),
 (41832,41832,18,744,0),
 (41833,41833,19,744,0),
 (41834,41834,20,744,0),
 (41835,41835,21,744,0),
 (41836,41836,22,744,0),
 (41837,41837,23,744,0),
 (41838,41838,24,744,0),
 (41839,41839,25,744,0),
 (41840,41840,26,744,0),
 (41841,41841,27,744,0),
 (41842,41842,28,744,0),
 (41843,41843,29,744,0),
 (41844,41844,30,744,0),
 (41845,41845,31,744,0),
 (41846,41846,32,744,0),
 (41847,41847,33,744,0),
 (41848,41848,34,744,0),
 (41849,41849,35,744,0),
 (41850,41850,36,744,0),
 (41851,41851,37,744,0),
 (41852,41852,38,744,0),
 (41853,41853,39,744,0),
 (41854,41854,40,744,0),
 (41855,41855,41,744,0),
 (41856,41856,0,745,0),
 (41857,41857,1,745,0),
 (41858,41858,2,745,0),
 (41859,41859,3,745,0),
 (41860,41860,4,745,0),
 (41861,41861,5,745,0),
 (41862,41862,6,745,0),
 (41863,41863,7,745,0),
 (41864,41864,8,745,0),
 (41865,41865,9,745,0),
 (41866,41866,10,745,0),
 (41867,41867,11,745,0),
 (41868,41868,12,745,0),
 (41869,41869,13,745,0),
 (41870,41870,0,746,0),
 (41871,41871,0,747,0),
 (41872,41872,1,747,0),
 (41873,41873,0,748,0),
 (41874,41874,0,749,0),
 (41875,41875,0,750,0),
 (41876,41876,0,751,0),
 (41877,41877,0,752,0),
 (41878,41878,0,753,0),
 (41879,41879,0,754,0),
 (41880,41880,0,755,0),
 (41881,41881,0,756,0),
 (41882,41882,0,757,0),
 (41883,41883,0,758,0),
 (41884,41884,0,759,0),
 (41885,41885,0,760,0),
 (41886,41886,0,761,0),
 (41887,41887,0,762,0),
 (41888,41888,0,763,0),
 (41889,41889,1,763,0),
 (41890,41890,2,763,0),
 (41891,41891,0,764,0),
 (41892,41892,0,765,0),
 (41893,41893,1,765,0),
 (41894,41894,0,766,0),
 (41895,41895,0,767,0),
 (41896,41896,0,768,0),
 (41897,41897,0,769,0),
 (41898,41898,0,770,0),
 (41899,41899,0,771,0),
 (41900,41900,0,772,0),
 (41901,41901,0,773,0),
 (41902,41902,0,774,0),
 (41903,41903,1,774,0),
 (41904,41904,2,774,0),
 (41905,41905,0,775,0),
 (41906,41906,1,775,0),
 (41907,41907,0,776,0),
 (41908,41908,1,776,0),
 (41909,41909,0,777,0),
 (41910,41910,0,778,0),
 (41911,41911,0,779,0),
 (41912,41912,0,780,0),
 (41913,41913,1,780,0),
 (41914,41914,2,780,0),
 (41915,41915,3,780,0),
 (41916,41916,0,781,0),
 (41917,41917,0,782,0),
 (41918,41918,0,783,0),
 (41919,41919,0,784,0),
 (41920,41920,0,785,0),
 (41921,41921,0,786,0),
 (41922,41922,1,786,0),
 (41923,41923,0,787,0),
 (41924,41924,0,788,0),
 (41925,41925,0,789,0),
 (41926,41926,0,790,0),
 (41927,41927,1,734,0),
 (41928,41928,42,744,0),
 (41929,41929,1,764,0),
 (41930,41930,23,740,0),
 (41932,41932,24,740,0),
 (41933,41933,25,740,0),
 (41934,41934,43,744,0),
 (41935,41935,44,744,0),
 (41936,41936,45,744,0),
 (41937,41937,26,740,0),
 (41938,41938,0,792,0),
 (41939,41939,1,792,0),
 (41940,41940,27,740,0),
 (41941,41941,2,792,0),
 (41942,41942,0,844,0),
 (41944,41944,28,740,0),
 (41945,41945,0,794,0),
 (41946,41946,0,795,0),
 (41947,41947,0,796,0),
 (41948,41948,0,797,0),
 (41949,41949,0,798,0),
 (41950,41950,0,799,0),
 (41951,41951,0,800,0),
 (41952,41952,0,801,0),
 (41953,41953,1,801,0),
 (41954,41954,2,801,0),
 (41955,41955,0,802,0),
 (41956,41956,29,740,0),
 (41957,41957,30,740,0),
 (41958,41958,31,740,0),
 (41959,41959,32,740,0),
 (41960,41960,33,740,0),
 (41961,41961,34,740,0),
 (41962,41962,35,740,0),
 (41963,41963,36,740,0),
 (41964,41964,37,740,0),
 (41965,41965,38,740,0),
 (41966,41966,39,740,0),
 (41967,41967,40,740,0),
 (41968,41968,41,740,0),
 (41969,41969,42,740,0),
 (41970,41970,43,740,0),
 (41971,41971,44,740,0),
 (41972,41972,45,740,0),
 (41973,41973,46,740,0),
 (41974,41974,47,740,0),
 (41975,41975,0,803,0),
 (41977,41977,1,803,0),
 (41978,41978,2,803,0),
 (41979,41979,3,803,0),
 (41980,41980,4,803,0),
 (41981,41981,5,803,0),
 (41982,41982,6,803,0),
 (41983,41983,0,804,0),
 (41984,41984,1,804,0),
 (42130,42130,7,803,0),
 (42131,42131,8,803,0),
 (42132,42132,9,803,0),
 (42133,42133,10,803,0),
 (42134,42134,2,804,0),
 (42135,42135,11,803,0),
 (42136,42136,0,806,0),
 (42137,42137,0,807,0),
 (42138,42138,0,808,0),
 (42139,42139,1,808,0),
 (42140,42140,12,803,0),
 (42142,42142,13,803,0),
 (42144,42144,14,803,0),
 (42145,42145,0,811,0),
 (42146,42146,2,808,0),
 (42147,42147,15,803,0),
 (42148,42148,0,812,0),
 (42149,42149,0,813,0),
 (42150,42150,1,813,0),
 (42151,42151,0,814,0),
 (42152,42152,0,815,0),
 (46366,46366,16,803,0),
 (46368,46368,0,834,0),
 (46369,46369,17,803,0),
 (46370,46370,0,835,0),
 (46371,46371,0,836,0),
 (46372,46372,1,836,0),
 (46373,46373,0,837,0),
 (46374,46374,0,838,0),
 (46375,46375,1,838,0),
 (46376,46376,2,838,0),
 (46377,46377,3,838,0),
 (46378,46378,0,839,0),
 (46379,46379,1,806,0),
 (46380,46380,2,806,0),
 (46381,46381,3,806,0),
 (46382,46382,4,806,0),
 (46383,46383,5,806,0),
 (46384,46384,6,806,0),
 (46385,46385,7,806,0),
 (46386,46386,1,807,0),
 (46387,46387,2,807,0),
 (46388,46388,3,807,0),
 (46389,46389,4,807,0),
 (46390,46390,5,807,0),
 (46391,46391,1,811,0),
 (46392,46392,2,811,0),
 (46393,46393,3,811,0),
 (46394,46394,4,811,0),
 (46395,46395,5,811,0),
 (46396,46396,6,811,0),
 (46397,46397,1,812,0),
 (46398,46398,2,812,0),
 (46399,46399,3,812,0),
 (46400,46400,4,812,0),
 (46401,46401,5,812,0),
 (46402,46402,6,812,0),
 (46403,46403,1,834,0),
 (46404,46404,2,834,0),
 (46405,46405,3,834,0),
 (46406,46406,2,813,0),
 (46407,46407,3,813,0),
 (46408,46408,1,814,0),
 (46409,46409,2,814,0),
 (46410,46410,3,814,0),
 (46411,46411,4,814,0),
 (46412,46412,5,814,0),
 (46413,46413,1,815,0),
 (46414,46414,2,815,0),
 (46415,46415,3,815,0),
 (46416,46416,4,815,0),
 (46417,46417,5,815,0),
 (46418,46418,6,815,0),
 (46419,46419,18,803,0),
 (46420,46420,19,803,0),
 (46421,46421,4,834,0),
 (46422,46422,5,834,0),
 (46423,46423,20,803,0),
 (46424,46424,8,806,0),
 (46425,46425,6,807,0),
 (46426,46426,9,806,0),
 (46427,46427,10,806,0),
 (46428,46428,11,806,0),
 (46429,46429,12,806,0),
 (46430,46430,13,806,0),
 (46431,46431,14,806,0),
 (46432,46432,6,834,0),
 (46433,46433,7,834,0),
 (46434,46434,3,804,0),
 (46435,46435,4,804,0),
 (46436,46436,2,738,0),
 (46437,46437,3,738,0),
 (46438,46438,4,738,0),
 (46439,46439,5,738,0),
 (46440,46440,3,808,0),
 (46441,46441,0,840,0),
 (46442,46442,1,840,0),
 (46443,46443,0,841,0),
 (46444,46444,0,842,0),
 (46445,46445,0,843,0),
 (46446,46446,1,835,0),
 (46447,46447,5,804,0),
 (46448,46448,15,806,0),
 (46449,46449,7,807,0),
 (46450,46450,7,811,0),
 (46451,46451,7,812,0),
 (46452,46452,8,834,0),
 (46453,46453,6,814,0),
 (46454,46454,1,837,0),
 (46455,46455,4,838,0),
 (46456,46456,7,815,0),
 (46457,46457,1,839,0),
 (46458,46458,6,804,0),
 (46459,46459,21,803,0),
 (46460,46460,22,803,0),
 (46461,46461,23,803,0),
 (46462,46462,24,803,0),
 (46463,46463,25,803,0),
 (46464,46464,26,803,0),
 (46465,46465,8,811,0),
 (46466,46466,9,811,0),
 (46467,46467,27,803,0),
 (46468,46468,28,803,0),
 (46469,46469,29,803,0),
 (46470,46470,30,803,0),
 (46471,46471,31,803,0),
 (46472,46472,32,803,0),
 (46473,46473,9,834,0),
 (46474,46474,10,834,0),
 (46475,46475,11,834,0),
 (46476,46476,12,834,0),
 (46477,46477,13,834,0),
 (46478,46478,14,834,0),
 (46479,46479,15,834,0),
 (46480,46480,16,834,0),
 (46481,46481,17,834,0),
 (46482,46482,18,834,0),
 (46483,46483,19,834,0),
 (46484,46484,20,834,0),
 (46485,46485,21,834,0),
 (46486,46486,33,803,0),
 (46487,46487,6,738,0),
 (46488,46488,34,803,0),
 (46489,46489,35,803,0),
 (46490,46490,22,834,0),
 (46491,46491,7,738,0),
 (46492,46492,23,834,0),
 (46493,46493,24,834,0),
 (46494,46494,36,803,0),
 (46495,46495,37,803,0),
 (46496,46496,38,803,0),
 (46497,46497,39,803,0),
 (46498,46498,40,803,0),
 (46499,46499,41,803,0),
 (46500,46500,8,738,0),
 (46501,46501,42,803,0),
 (46502,46502,48,740,0),
 (46503,46503,9,738,0),
 (46504,46504,10,738,0),
 (46505,46505,11,738,0),
 (46506,46506,43,803,0),
 (46507,46507,44,803,0),
 (46508,46508,45,803,0),
 (46509,46509,46,803,0),
 (46510,46510,47,803,0),
 (46511,46511,48,803,0),
 (46512,46512,49,803,0),
 (46513,46513,50,803,0),
 (46514,46514,51,803,0),
 (46515,46515,0,845,0),
 (46516,46516,1,845,0),
 (46517,46517,2,845,0),
 (46518,46518,3,845,0),
 (46524,46524,4,845,0),
 (46526,46526,5,845,0),
 (46527,46527,6,845,0),
 (46528,46528,0,847,0),
 (46529,46529,1,847,0),
 (46530,46530,2,847,0),
 (46536,46536,0,848,0),
 (46537,46537,1,848,0),
 (46538,46538,2,848,0),
 (46539,46539,3,848,0),
 (46540,46540,4,848,0),
 (46541,46541,0,849,0),
 (46542,46542,1,849,0),
 (46543,46543,2,849,0),
 (46544,46544,3,849,0),
 (46545,46545,4,849,0),
 (46546,46546,5,849,0),
 (46547,46547,6,849,0),
 (46548,46548,0,850,0),
 (46549,46549,0,851,0),
 (46550,46550,1,851,0),
 (46551,46551,0,852,0),
 (46552,46552,0,853,0),
 (46553,46553,1,853,0),
 (46554,46554,2,853,0),
 (46555,46555,3,853,0),
 (46556,46556,4,853,0),
 (46557,46557,5,853,0),
 (46558,46558,0,854,0),
 (46559,46559,1,854,0),
 (46560,46560,2,854,0),
 (46561,46561,3,854,0),
 (46562,46562,0,855,0),
 (46563,46563,1,855,0),
 (46564,46564,2,855,0),
 (46565,46565,3,855,0),
 (46566,46566,4,855,0),
 (46567,46567,5,855,0),
 (46568,46568,6,855,0),
 (46569,46569,7,855,0),
 (46570,46570,0,856,0),
 (46571,46571,1,856,0),
 (46572,46572,2,856,0),
 (46573,46573,3,856,0),
 (46574,46574,4,856,0),
 (46575,46575,5,856,0),
 (46576,46576,6,856,0),
 (46577,46577,7,856,0),
 (46578,46578,8,856,0),
 (46579,46579,9,856,0),
 (46580,46580,10,856,0),
 (46581,46581,11,856,0),
 (46582,46582,12,856,0),
 (46583,46583,13,856,0),
 (46584,46584,14,856,0),
 (46585,46585,15,856,0),
 (46586,46586,0,857,0),
 (46587,46587,1,857,0),
 (46588,46588,2,857,0),
 (46589,46589,0,858,0),
 (46590,46590,0,859,0),
 (46591,46591,7,845,0),
 (46592,46592,8,845,0),
 (46593,46593,9,845,0),
 (46594,46594,10,845,0),
 (46595,46595,11,845,0),
 (46596,46596,12,845,0),
 (46597,46597,13,845,0),
 (46598,46598,14,845,0),
 (46599,46599,15,845,0),
 (46623,46623,3,847,0),
 (46654,46654,4,847,0),
 (46775,46775,5,847,0),
 (46776,46776,6,847,0),
 (46777,46777,7,847,0),
 (46778,46778,8,847,0),
 (46779,46779,9,847,0),
 (46780,46780,10,847,0),
 (46781,46781,11,847,0),
 (46782,46782,12,847,0),
 (46783,46783,13,847,0),
 (46784,46784,14,847,0),
 (46785,46785,15,847,0),
 (46786,46786,16,847,0),
 (46803,46803,17,847,0),
 (46804,46804,18,847,0),
 (46805,46805,19,847,0),
 (46806,46806,20,847,0),
 (46807,46807,21,847,0),
 (46808,46808,22,847,0),
 (46809,46809,23,847,0),
 (46810,46810,24,847,0),
 (46811,46811,25,847,0),
 (46812,46812,26,847,0),
 (46813,46813,27,847,0),
 (46814,46814,28,847,0),
 (46815,46815,29,847,0),
 (46989,46989,0,894,1),
 (46990,46990,0,895,1),
 (47016,47016,0,912,1),
 (47191,47191,0,958,0),
 (47192,47192,1,958,0),
 (47193,47193,2,958,0),
 (47194,47194,3,958,0),
 (47195,47195,4,958,0),
 (47196,47196,5,958,0),
 (47197,47197,6,958,0),
 (47198,47198,7,958,0),
 (47199,47199,8,958,0),
 (47200,47200,9,958,0),
 (47201,47201,0,959,0),
 (47202,47202,1,959,0),
 (47203,47203,2,959,0),
 (47204,47204,3,959,0),
 (47205,47205,4,959,0),
 (47206,47206,5,959,0),
 (47207,47207,6,959,0),
 (47208,47208,7,959,0),
 (47209,47209,8,959,0),
 (47210,47210,9,959,0),
 (47211,47211,10,958,0),
 (47212,47212,11,958,0),
 (47213,47213,12,958,0),
 (47214,47214,13,958,0),
 (47215,47215,14,958,0),
 (47216,47216,15,958,0),
 (47217,47217,16,958,0),
 (47218,47218,17,958,0),
 (47219,47219,18,958,0),
 (47220,47220,19,958,0),
 (47221,47221,10,959,0),
 (47222,47222,11,959,0),
 (47223,47223,12,959,0),
 (47224,47224,13,959,0),
 (47225,47225,14,959,0),
 (47226,47226,15,959,0),
 (47227,47227,16,959,0),
 (47228,47228,17,959,0),
 (47229,47229,18,959,0),
 (47230,47230,19,959,0),
 (47231,47231,0,960,0),
 (47232,47232,1,960,0),
 (47233,47233,2,960,0),
 (47234,47234,0,961,0),
 (47235,47235,1,961,0),
 (47236,47236,2,961,0),
 (47237,47237,0,962,0),
 (47238,47238,0,963,0),
 (47239,47239,0,964,0),
 (47240,47240,1,964,0),
 (47241,47241,2,964,0),
 (47242,47242,3,964,0),
 (47243,47243,4,964,0),
 (47244,47244,5,964,0),
 (47245,47245,6,964,0),
 (47246,47246,7,964,0),
 (47247,47247,8,964,0),
 (47248,47248,0,965,0),
 (47249,47249,1,965,0),
 (47250,47250,2,965,0),
 (47251,47251,3,965,0),
 (47252,47252,4,965,0),
 (47253,47253,5,965,0),
 (47254,47254,6,965,0),
 (47255,47255,7,965,0),
 (47256,47256,8,965,0),
 (47257,47257,0,966,0),
 (47258,47258,1,966,0),
 (47259,47259,2,966,0),
 (47260,47260,3,966,0),
 (47261,47261,4,966,0),
 (47262,47262,5,966,0),
 (47263,47263,6,966,0),
 (47608,47608,0,967,0),
 (47609,47609,0,968,0),
 (47610,47610,1,968,0),
 (47611,47611,2,968,0),
 (47612,47612,3,968,0),
 (47613,47613,4,968,0),
 (47614,47614,5,968,0),
 (47615,47615,0,969,0),
 (47616,47616,1,969,0),
 (47617,47617,2,969,0),
 (47618,47618,3,969,0),
 (47619,47619,4,969,0),
 (47620,47620,5,969,0),
 (47621,47621,6,969,0),
 (47622,47622,7,969,0),
 (47623,47623,8,969,0),
 (47624,47624,0,970,0),
 (47625,47625,1,970,0),
 (47626,47626,2,970,0),
 (47627,47627,3,970,0),
 (47628,47628,4,970,0),
 (47629,47629,5,970,0),
 (47630,47630,6,970,0),
 (47631,47631,6,968,0),
 (47632,47632,7,968,0),
 (47633,47633,8,968,0),
 (47634,47634,0,971,0),
 (47635,47635,1,967,0),
 (47636,47636,2,967,0),
 (47637,47637,3,967,0),
 (47638,47638,1,962,0),
 (47639,47639,20,958,0),
 (47640,47640,21,958,0),
 (47641,47641,22,958,0),
 (47642,47642,23,958,0),
 (47643,47643,24,958,0),
 (47644,47644,25,958,0),
 (47645,47645,26,958,0),
 (47646,47646,27,958,0),
 (47647,47647,28,958,0),
 (47648,47648,29,958,0),
 (47649,47649,3,960,0),
 (47650,47650,4,960,0),
 (47651,47651,5,960,0),
 (47652,47652,4,967,0),
 (47653,47653,5,967,0),
 (47654,47654,1,963,0),
 (47655,47655,3,961,0),
 (47656,47656,4,961,0),
 (47657,47657,5,961,0),
 (47658,47658,20,959,0),
 (47659,47659,21,959,0),
 (47660,47660,22,959,0),
 (47661,47661,23,959,0),
 (47662,47662,24,959,0),
 (47663,47663,25,959,0),
 (47664,47664,26,959,0),
 (47665,47665,27,959,0),
 (47666,47666,28,959,0),
 (47667,47667,29,959,0),
 (47668,47668,9,964,0),
 (47669,47669,10,964,0),
 (47670,47670,11,964,0),
 (47671,47671,12,964,0),
 (47672,47672,13,964,0),
 (47673,47673,14,964,0),
 (47674,47674,15,964,0),
 (47675,47675,16,964,0),
 (47676,47676,17,964,0),
 (47677,47677,9,965,0),
 (47678,47678,10,965,0),
 (47679,47679,11,965,0),
 (47680,47680,12,965,0),
 (47681,47681,13,965,0),
 (47682,47682,14,965,0),
 (47683,47683,15,965,0),
 (47684,47684,16,965,0),
 (47685,47685,17,965,0),
 (47686,47686,7,966,0),
 (47687,47687,8,966,0),
 (47688,47688,9,966,0),
 (47689,47689,10,966,0),
 (47690,47690,11,966,0),
 (47691,47691,12,966,0),
 (47692,47692,13,966,0),
 (47693,47693,9,968,0),
 (47694,47694,10,968,0),
 (47695,47695,11,968,0),
 (47696,47696,12,968,0),
 (47697,47697,13,968,0),
 (47698,47698,14,968,0),
 (47699,47699,15,968,0),
 (47700,47700,16,968,0),
 (47701,47701,17,968,0),
 (47702,47702,9,969,0),
 (47703,47703,10,969,0),
 (47704,47704,11,969,0),
 (47705,47705,12,969,0),
 (47706,47706,13,969,0),
 (47707,47707,14,969,0),
 (47708,47708,15,969,0),
 (47709,47709,16,969,0),
 (47710,47710,17,969,0),
 (47711,47711,7,970,0),
 (47712,47712,8,970,0),
 (47713,47713,9,970,0),
 (47714,47714,10,970,0),
 (47715,47715,11,970,0),
 (47716,47716,12,970,0),
 (47717,47717,13,970,0),
 (47718,47718,6,967,0),
 (47719,47719,0,972,0),
 (47720,47720,1,972,0),
 (47721,47721,2,972,0),
 (47722,47722,3,972,0),
 (47723,47723,4,972,0),
 (47724,47724,5,972,0),
 (47725,47725,6,972,0),
 (47726,47726,7,972,0),
 (47727,47727,8,972,0),
 (47728,47728,9,972,0),
 (47729,47729,10,972,0),
 (47730,47730,11,972,0),
 (47731,47731,0,973,0),
 (47732,47732,0,974,0),
 (47733,47733,0,975,0),
 (47734,47734,1,975,0),
 (47735,47735,0,976,0),
 (47736,47736,1,976,0),
 (47737,47737,2,976,0),
 (47738,47738,3,976,0),
 (47739,47739,4,976,0),
 (47740,47740,5,976,0),
 (47741,47741,6,976,0),
 (47742,47742,7,976,0),
 (47743,47743,8,976,0),
 (47744,47744,9,976,0),
 (47745,47745,10,976,0),
 (47746,47746,11,976,0),
 (47747,47747,12,976,0),
 (47748,47748,13,976,0),
 (47749,47749,12,972,0),
 (47750,47750,13,972,0),
 (47751,47751,14,972,0),
 (47752,47752,15,972,0),
 (47753,47753,16,972,0),
 (47754,47754,17,972,0),
 (47755,47755,18,972,0),
 (47756,47756,19,972,0),
 (47757,47757,20,972,0),
 (47758,47758,21,972,0),
 (47759,47759,22,972,0),
 (47760,47760,23,972,0),
 (47761,47761,24,972,0),
 (47762,47762,14,976,0),
 (47763,47763,15,976,0),
 (47764,47764,16,976,0),
 (47765,47765,17,976,0),
 (47766,47766,18,976,0),
 (47767,47767,19,976,0),
 (47768,47768,20,976,0),
 (47769,47769,21,976,0),
 (47770,47770,22,976,0),
 (47771,47771,23,976,0),
 (47772,47772,24,976,0),
 (47773,47773,25,976,0),
 (47774,47774,26,976,0),
 (47775,47775,1,974,0),
 (47776,47776,0,977,0),
 (47777,47777,1,977,0),
 (47778,47778,0,978,0),
 (47779,47779,1,978,0),
 (47780,47780,0,979,0),
 (47781,47781,1,979,0),
 (47786,47786,2,974,0),
 (47789,47789,3,974,0),
 (47790,47790,4,974,0),
 (47795,47795,5,974,0),
 (47796,47796,6,974,0),
 (47797,47797,7,974,0),
 (48025,48025,8,974,0),
 (48026,48026,9,974,0),
 (48030,48030,10,974,0),
 (48031,48031,11,974,0),
 (48315,48315,12,974,0),
 (48316,48316,13,974,0),
 (48317,48317,14,974,0),
 (48318,48318,15,974,0),
 (48319,48319,16,974,0),
 (48320,48320,17,974,0),
 (48454,48454,18,974,0),
 (49180,49180,19,974,0),
 (49181,49181,20,974,0),
 (49182,49182,21,974,0),
 (49183,49183,22,974,0),
 (49184,49184,23,974,0),
 (49185,49185,24,974,0),
 (49186,49186,25,974,0),
 (49187,49187,26,974,0),
 (49188,49188,27,974,0),
 (49189,49189,28,974,0),
 (49190,49190,29,974,0),
 (49191,49191,30,974,0),
 (49192,49192,31,974,0),
 (49193,49193,32,974,0),
 (49194,49194,33,974,0),
 (49195,49195,34,974,0),
 (49196,49196,35,974,0),
 (49197,49197,36,974,0),
 (49198,49198,37,974,0),
 (49199,49199,38,974,0),
 (49200,49200,39,974,0),
 (49201,49201,40,974,0),
 (49202,49202,41,974,0),
 (49203,49203,42,974,0),
 (49204,49204,43,974,0),
 (49205,49205,44,974,0),
 (49206,49206,45,974,0),
 (49207,49207,46,974,0),
 (49208,49208,47,974,0),
 (49209,49209,48,974,0),
 (49210,49210,49,974,0),
 (49211,49211,50,974,0),
 (49212,49212,51,974,0),
 (49213,49213,52,974,0),
 (49214,49214,53,974,0),
 (49215,49215,54,974,0),
 (49216,49216,55,974,0),
 (49217,49217,56,974,0),
 (49218,49218,57,974,0),
 (49373,49373,58,974,0),
 (49374,49374,59,974,0),
 (49375,49375,60,974,0),
 (49376,49376,61,974,0),
 (49380,49380,62,974,0),
 (49381,49381,63,974,0),
 (49385,49385,64,974,0),
 (49386,49386,65,974,0),
 (49387,49387,0,1024,0),
 (49388,49388,66,974,0),
 (49389,49389,1,1024,0),
 (49390,49390,67,974,0),
 (49393,49393,2,1024,0),
 (49394,49394,3,1024,0),
 (49396,49396,4,1024,0),
 (49397,49397,68,974,0),
 (49399,49399,0,1025,0),
 (49400,49400,1,1025,0),
 (49401,49401,2,1025,0),
 (49402,49402,3,1025,0),
 (49403,49403,4,1025,0),
 (49404,49404,5,1025,0),
 (49405,49405,6,1025,0),
 (49406,49406,7,1025,0),
 (49407,49407,8,1025,0),
 (49408,49408,9,1025,0),
 (49409,49409,10,1025,0),
 (49410,49410,11,1025,0),
 (49411,49411,12,1025,0),
 (49412,49412,13,1025,0),
 (49413,49413,0,1026,0),
 (49414,49414,1,1026,0),
 (49415,49415,2,1026,0),
 (49416,49416,3,1026,0),
 (49417,49417,4,1026,0),
 (49418,49418,5,1026,0),
 (49419,49419,6,1026,0),
 (49420,49420,7,1026,0),
 (49421,49421,8,1026,0),
 (49422,49422,9,1026,0),
 (49423,49423,10,1026,0),
 (49424,49424,11,1026,0),
 (49425,49425,12,1026,0),
 (49426,49426,13,1026,0),
 (49441,49441,69,974,0),
 (49442,49442,14,1025,0),
 (49443,49443,15,1025,0),
 (49444,49444,16,1025,0),
 (49445,49445,17,1025,0),
 (49446,49446,18,1025,0),
 (49447,49447,19,1025,0),
 (49448,49448,20,1025,0),
 (49449,49449,21,1025,0),
 (49450,49450,22,1025,0),
 (49451,49451,23,1025,0),
 (49452,49452,24,1025,0),
 (49453,49453,25,1025,0),
 (49454,49454,26,1025,0),
 (49455,49455,27,1025,0),
 (49456,49456,14,1026,0),
 (49457,49457,15,1026,0),
 (49458,49458,16,1026,0),
 (49459,49459,17,1026,0),
 (49460,49460,18,1026,0),
 (49461,49461,19,1026,0),
 (49462,49462,20,1026,0),
 (49463,49463,21,1026,0),
 (49464,49464,22,1026,0),
 (49465,49465,23,1026,0),
 (49466,49466,24,1026,0),
 (49467,49467,25,1026,0),
 (49468,49468,26,1026,0),
 (49469,49469,27,1026,0),
 (49506,49506,28,1025,0),
 (49507,49507,29,1025,0),
 (49508,49508,30,1025,0),
 (49509,49509,31,1025,0),
 (49510,49510,32,1025,0),
 (49511,49511,33,1025,0),
 (49512,49512,34,1025,0),
 (49513,49513,35,1025,0),
 (49514,49514,36,1025,0),
 (49515,49515,37,1025,0),
 (49516,49516,38,1025,0),
 (49517,49517,39,1025,0),
 (49518,49518,40,1025,0),
 (49519,49519,41,1025,0),
 (49520,49520,28,1026,0),
 (49521,49521,29,1026,0),
 (49522,49522,30,1026,0),
 (49523,49523,31,1026,0),
 (49524,49524,32,1026,0),
 (49525,49525,33,1026,0),
 (49526,49526,34,1026,0),
 (49527,49527,35,1026,0),
 (49528,49528,36,1026,0),
 (49529,49529,37,1026,0),
 (49530,49530,38,1026,0),
 (49531,49531,39,1026,0),
 (49532,49532,40,1026,0),
 (49533,49533,41,1026,0),
 (49553,49553,1,1029,0),
 (49554,49554,2,1029,0),
 (49555,49555,3,1029,0),
 (49556,49556,4,1029,0),
 (49557,49557,5,1029,0),
 (49560,49560,42,1025,0),
 (49561,49561,43,1025,0),
 (49562,49562,44,1025,0),
 (49563,49563,45,1025,0),
 (49564,49564,46,1025,0),
 (49565,49565,47,1025,0),
 (49566,49566,48,1025,0),
 (49567,49567,49,1025,0),
 (49568,49568,50,1025,0),
 (49569,49569,51,1025,0),
 (49570,49570,52,1025,0),
 (49571,49571,53,1025,0),
 (49572,49572,54,1025,0),
 (49573,49573,55,1025,0),
 (49574,49574,56,1025,0),
 (49575,49575,57,1025,0),
 (49576,49576,58,1025,0),
 (49577,49577,59,1025,0),
 (49578,49578,60,1025,0),
 (49579,49579,61,1025,0),
 (49580,49580,62,1025,0),
 (49581,49581,63,1025,0),
 (49582,49582,64,1025,0),
 (49583,49583,65,1025,0),
 (49584,49584,66,1025,0),
 (49585,49585,42,1026,0),
 (49586,49586,43,1026,0),
 (49587,49587,44,1026,0),
 (49588,49588,45,1026,0),
 (49589,49589,46,1026,0),
 (49590,49590,47,1026,0),
 (49591,49591,48,1026,0),
 (49592,49592,49,1026,0),
 (49593,49593,50,1026,0),
 (49594,49594,51,1026,0),
 (49595,49595,52,1026,0),
 (49596,49596,53,1026,0),
 (49597,49597,54,1026,0),
 (49598,49598,55,1026,0),
 (49599,49599,56,1026,0),
 (49600,49600,57,1026,0),
 (49601,49601,58,1026,0),
 (49602,49602,59,1026,0),
 (49603,49603,60,1026,0),
 (49604,49604,61,1026,0),
 (49605,49605,62,1026,0),
 (49606,49606,63,1026,0),
 (49607,49607,64,1026,0),
 (49608,49608,65,1026,0),
 (49609,49609,66,1026,0),
 (49635,49635,0,1030,0),
 (49636,49636,6,1029,0),
 (49687,49687,1,971,0),
 (49688,49688,0,1032,0),
 (49689,49689,1,1032,0),
 (49690,49690,2,1032,0),
 (49691,49691,3,1032,0),
 (49692,49692,4,1032,0),
 (49693,49693,5,1032,0),
 (49694,49694,0,1033,0),
 (49695,49695,1,1033,0),
 (49696,49696,2,1033,0),
 (49697,49697,3,1033,0),
 (49702,49702,0,1035,0),
 (49703,49703,1,1035,0),
 (49704,49704,2,1035,0),
 (49705,49705,3,1035,0),
 (49706,49706,4,1035,0),
 (49707,49707,5,1035,0),
 (49708,49708,6,1035,0),
 (49709,49709,7,1035,0),
 (49710,49710,4,1033,0),
 (49711,49711,5,1033,0),
 (49712,49712,0,1036,0),
 (49713,49713,1,1036,0),
 (49716,49716,8,1035,0),
 (49717,49717,9,1035,0),
 (49738,49738,70,974,0),
 (50445,50445,71,974,0),
 (50446,50446,72,974,0),
 (50447,50447,73,974,0),
 (50448,50448,0,1043,0),
 (50449,50449,1,1043,0),
 (50450,50450,6,1033,0),
 (50451,50451,7,1033,0),
 (50454,50454,67,1025,0),
 (50455,50455,68,1025,0),
 (50456,50456,67,1026,0),
 (50457,50457,68,1026,0),
 (50460,50460,69,1025,0),
 (50461,50461,70,1025,0),
 (50462,50462,71,1025,0),
 (50463,50463,69,1026,0),
 (50464,50464,70,1026,0),
 (50465,50465,71,1026,0),
 (50471,50471,0,1044,0),
 (50472,50472,72,1025,0),
 (50473,50473,8,1033,0),
 (50474,50474,0,1045,0),
 (50475,50475,0,1046,0),
 (50476,50476,0,1047,0),
 (50477,50477,72,1026,0),
 (50478,50478,0,1048,0),
 (50483,50483,73,1025,0),
 (50484,50484,74,1025,0),
 (50485,50485,75,1025,0),
 (50486,50486,73,1026,0),
 (50487,50487,74,1026,0),
 (50488,50488,75,1026,0),
 (50500,50500,76,1025,0),
 (50501,50501,77,1025,0),
 (50502,50502,78,1025,0),
 (50747,50747,79,1025,0),
 (50748,50748,80,1025,0),
 (50749,50749,81,1025,0),
 (50750,50750,82,1025,0),
 (50751,50751,83,1025,0),
 (50752,50752,84,1025,0),
 (50753,50753,76,1026,0),
 (50754,50754,77,1026,0),
 (50755,50755,78,1026,0),
 (50756,50756,79,1026,0),
 (50757,50757,80,1026,0),
 (50758,50758,81,1026,0),
 (50774,50774,85,1025,0),
 (50775,50775,86,1025,0),
 (50776,50776,87,1025,0),
 (50777,50777,88,1025,0),
 (50778,50778,89,1025,0),
 (50779,50779,90,1025,0),
 (50780,50780,74,974,0),
 (50781,50781,91,1025,0),
 (50782,50782,92,1025,0),
 (50783,50783,93,1025,0),
 (50784,50784,82,1026,0),
 (50785,50785,83,1026,0),
 (50786,50786,84,1026,0),
 (50787,50787,85,1026,0),
 (50788,50788,86,1026,0),
 (50789,50789,87,1026,0),
 (50799,50799,1,1045,0),
 (50800,50800,2,1045,0),
 (50801,50801,3,1045,0),
 (50802,50802,4,1045,0),
 (50803,50803,5,1045,0),
 (50807,50807,6,1045,0),
 (50813,50813,0,1054,0),
 (50814,50814,1,1054,0),
 (50815,50815,2,1054,0),
 (50816,50816,3,1054,0),
 (50999,50999,4,1054,0),
 (51000,51000,5,1054,0),
 (52028,52028,0,1062,0),
 (52029,52029,1,1062,0),
 (52043,52043,75,974,0),
 (52044,52044,76,974,0),
 (52045,52045,77,974,0),
 (52046,52046,1,1044,0),
 (52047,52047,2,1044,0),
 (52048,52048,3,1044,0),
 (52049,52049,1,1047,0),
 (52050,52050,2,1047,0),
 (52051,52051,3,1047,0),
 (52059,52059,6,1054,0),
 (52060,52060,7,1054,0),
 (52062,52062,8,1054,0),
 (52063,52063,9,1054,0),
 (52074,52074,10,1054,0),
 (56153,56153,0,1116,0),
 (56154,56154,1,1116,0),
 (56160,56160,81,974,0),
 (56161,56161,82,974,0),
 (57621,57621,83,974,0),
 (57628,57628,78,974,0),
 (57629,57629,86,974,0),
 (57630,57630,79,974,0),
 (57665,57665,10,1035,0),
 (57666,57666,11,1035,0),
 (57667,57667,12,1035,0),
 (57672,57672,80,974,0),
 (57675,57675,84,974,0),
 (57678,57678,85,974,0),
 (70461,70461,0,1551,0),
 (70462,70462,1,1551,0),
 (157108,157108,0,2583,0),
 (158181,158181,133,974,0),
 (158242,158242,0,2591,0),
 (158265,158265,0,2595,0),
 (158273,158273,2,1116,0),
 (163057,163058,87,974,0),
 (163060,163061,0,2702,0),
 (163061,163062,88,974,0),
 (163829,163830,0,2707,0),
 (163830,163831,118,974,0),
 (163831,163832,113,974,0),
 (163832,163833,117,974,0),
 (163833,163834,114,974,0),
 (163834,163835,102,974,0),
 (163835,163836,104,974,0),
 (163836,163837,92,974,0),
 (163837,163838,116,974,0),
 (163838,163839,91,974,0),
 (163839,163840,103,974,0),
 (163840,163841,115,974,0),
 (163841,163842,125,974,0),
 (163842,163843,106,974,0),
 (163843,163844,105,974,0),
 (163844,163845,107,974,0),
 (163845,163846,122,974,0),
 (163846,163847,98,974,0),
 (163847,163848,123,974,0),
 (163848,163849,96,974,0),
 (163849,163850,124,974,0),
 (163850,163851,97,974,0),
 (163851,163852,109,974,0),
 (163852,163853,110,974,0),
 (163853,163854,119,974,0),
 (163854,163855,99,974,0),
 (163855,163856,94,974,0),
 (163856,163857,90,974,0),
 (163857,163858,95,974,0),
 (163858,163859,101,974,0),
 (163859,163860,89,974,0),
 (163860,163861,120,974,0),
 (163861,163862,93,974,0),
 (163862,163863,108,974,0),
 (163863,163864,111,974,0),
 (163864,163865,121,974,0),
 (163865,163866,100,974,0),
 (163866,163867,112,974,0),
 (163987,163988,4,2946,0),
 (163988,163989,15,2711,0),
 (163989,163990,13,2711,0),
 (163990,163991,6,2711,0),
 (163991,163992,12,2711,0),
 (163992,163993,7,2711,0),
 (163993,163994,16,2711,0),
 (163994,163995,6,2946,0),
 (163995,163996,5,2946,0),
 (163996,163997,17,2711,0),
 (163997,163998,18,2711,0),
 (163998,163999,10,2711,0),
 (163999,164000,3,2711,0),
 (164000,164001,19,2711,0),
 (164001,164002,4,2711,0),
 (164002,164003,1,2946,0),
 (164003,164004,5,2711,0),
 (164004,164005,11,2711,0),
 (164005,164006,3,2946,0),
 (164006,164007,20,2711,0),
 (164007,164008,3,2945,0),
 (164008,164009,21,2711,0),
 (164009,164010,4,2945,0),
 (164010,164011,1,2711,0),
 (164011,164012,6,2945,0),
 (164012,164013,2,2946,0),
 (164013,164014,7,2945,0),
 (164014,164015,8,2945,0),
 (164015,164016,2,2711,0),
 (164016,164017,5,2945,0),
 (164017,164018,7,2946,0),
 (164018,164019,9,2945,0),
 (164019,164020,9,2711,0),
 (164020,164021,14,2711,0),
 (164021,164022,1,2945,0),
 (164022,164023,2,2945,0),
 (164023,164024,8,2711,0),
 (164035,164036,25,2712,0),
 (164036,164037,9,2712,0),
 (164037,164038,24,2712,0),
 (164038,164039,23,2712,0),
 (164039,164040,11,2712,0),
 (164040,164041,0,2712,0),
 (164041,164042,10,2712,0),
 (164042,164043,1,2712,0),
 (164043,164044,13,2712,0),
 (164044,164045,22,2712,0),
 (164045,164046,12,2712,0),
 (164046,164047,21,2712,0),
 (164047,164048,2,2712,0),
 (164048,164049,14,2712,0),
 (164049,164050,3,2712,0),
 (164050,164051,4,2712,0),
 (164051,164052,19,2712,0),
 (164052,164053,32,2712,0),
 (164053,164054,20,2712,0),
 (164054,164055,5,2712,0),
 (164055,164056,30,2712,0),
 (164056,164057,18,2712,0),
 (164057,164058,33,2712,0),
 (164058,164059,34,2712,0),
 (164059,164060,31,2712,0),
 (164060,164061,29,2712,0),
 (164061,164062,35,2712,0),
 (164062,164063,7,2712,0),
 (164063,164064,37,2712,0),
 (164064,164065,28,2712,0),
 (164065,164066,16,2712,0),
 (164066,164067,17,2712,0),
 (164067,164068,27,2712,0),
 (164068,164069,8,2712,0),
 (164069,164070,36,2712,0),
 (164070,164071,26,2712,0),
 (164071,164072,6,2712,0),
 (164072,164073,15,2712,0),
 (164073,164074,19,2713,0),
 (164074,164075,37,2713,0),
 (164075,164076,7,2713,0),
 (164076,164077,6,2713,0),
 (164077,164078,18,2713,0),
 (164078,164079,26,2713,0),
 (164079,164080,28,2713,0),
 (164080,164081,27,2713,0),
 (164081,164082,8,2713,0),
 (164082,164083,17,2713,0),
 (164083,164084,10,2713,0),
 (164084,164085,22,2713,0),
 (164085,164086,34,2713,0),
 (164086,164087,11,2713,0),
 (164087,164088,9,2713,0),
 (164088,164089,35,2713,0),
 (164089,164090,21,2713,0),
 (164090,164091,36,2713,0),
 (164091,164092,20,2713,0),
 (164092,164093,25,2713,0),
 (164093,164094,5,2713,0),
 (164094,164095,14,2713,0),
 (164095,164096,12,2713,0),
 (164096,164097,24,2713,0),
 (164097,164098,32,2713,0),
 (164098,164099,3,2713,0),
 (164099,164100,33,2713,0),
 (164100,164101,13,2713,0),
 (164101,164102,4,2713,0),
 (164102,164103,23,2713,0),
 (164103,164104,1,2713,0),
 (164104,164105,2,2713,0),
 (164105,164106,31,2713,0),
 (164106,164107,29,2713,0),
 (164107,164108,15,2713,0),
 (164108,164109,0,2713,0),
 (164109,164110,16,2713,0),
 (164110,164111,30,2713,0),
 (168666,168667,22,2711,0),
 (176119,176120,126,974,0),
 (176120,176121,127,974,0),
 (176121,176122,128,974,0),
 (176124,176125,129,974,0),
 (178127,178128,38,2713,0),
 (178147,178148,48,2713,0),
 (178148,178149,58,2713,0),
 (178149,178150,47,2713,0),
 (178150,178151,59,2713,0),
 (178151,178152,61,2713,0),
 (178152,178153,71,2713,0),
 (178153,178154,60,2713,0),
 (178154,178155,44,2713,0),
 (178155,178156,49,2713,0),
 (178156,178157,63,2713,0),
 (178157,178158,62,2713,0),
 (178158,178159,65,2713,0),
 (178159,178160,55,2713,0),
 (178160,178161,64,2713,0),
 (178161,178162,56,2713,0),
 (178162,178163,66,2713,0),
 (178163,178164,46,2713,0),
 (178164,178165,45,2713,0),
 (178165,178166,57,2713,0),
 (178166,178167,68,2713,0),
 (178167,178168,67,2713,0),
 (178168,178169,40,2713,0),
 (178169,178170,53,2713,0),
 (178170,178171,39,2713,0),
 (178171,178172,54,2713,0),
 (178172,178173,69,2713,0),
 (178173,178174,74,2713,0),
 (178174,178175,43,2713,0),
 (178175,178176,52,2713,0),
 (178176,178177,70,2713,0),
 (178177,178178,50,2713,0),
 (178178,178179,73,2713,0),
 (178179,178180,41,2713,0),
 (178180,178181,42,2713,0),
 (178181,178182,72,2713,0),
 (178182,178183,51,2713,0),
 (179573,179574,92,2713,0),
 (179574,179575,83,2713,0),
 (179575,179576,98,2713,0),
 (179576,179577,78,2713,0),
 (179577,179578,82,2713,0),
 (179578,179579,91,2713,0),
 (179579,179580,89,2713,0),
 (179580,179581,79,2713,0),
 (179581,179582,85,2713,0),
 (179582,179583,94,2713,0),
 (179583,179584,84,2713,0),
 (179584,179585,80,2713,0),
 (179585,179586,93,2713,0),
 (179586,179587,81,2713,0),
 (179587,179588,95,2713,0),
 (179588,179589,90,2713,0),
 (179589,179590,86,2713,0),
 (179590,179591,75,2713,0),
 (179591,179592,97,2713,0),
 (179592,179593,88,2713,0),
 (179593,179594,76,2713,0),
 (179594,179595,87,2713,0),
 (179595,179596,96,2713,0),
 (179596,179597,77,2713,0),
 (181035,181036,94,1025,0),
 (181036,181037,95,1025,0),
 (181197,181198,88,1026,0),
 (181198,181199,89,1026,0),
 (181199,181200,90,1026,0),
 (181218,181220,11,1054,0),
 (181219,181221,12,1054,0),
 (181228,181230,0,2711,0),
 (181229,181231,0,2945,0),
 (181230,181232,0,2946,0),
 (181233,181235,0,2947,0),
 (181234,181237,0,1029,0),
 (181235,181238,0,2948,0),
 (181368,181371,21,1029,0),
 (181369,181372,19,1029,0),
 (181370,181373,12,1029,0),
 (181371,181374,9,1029,0),
 (181372,181375,18,1029,0),
 (181373,181376,30,1029,0),
 (181374,181377,7,1029,0),
 (181375,181378,13,1029,0),
 (181376,181379,22,1029,0),
 (181377,181380,20,1029,0),
 (181378,181381,14,1029,0),
 (181379,181382,8,1029,0),
 (181380,181383,23,1029,0),
 (181381,181384,24,1029,0),
 (181382,181385,16,1029,0),
 (181383,181386,29,1029,0),
 (181384,181387,25,1029,0),
 (181385,181388,15,1029,0),
 (181386,181389,27,1029,0),
 (181387,181390,10,1029,0),
 (181388,181391,17,1029,0),
 (181389,181392,11,1029,0),
 (181390,181393,28,1029,0),
 (181391,181394,26,1029,0),
 (181656,181659,48,1029,0),
 (181657,181660,31,1029,0),
 (181658,181661,38,1029,0),
 (181659,181662,35,1029,0),
 (181660,181663,49,1029,0),
 (181661,181664,37,1029,0),
 (181662,181665,36,1029,0),
 (181663,181666,32,1029,0),
 (181664,181667,43,1029,0),
 (181665,181668,47,1029,0),
 (181666,181669,42,1029,0),
 (181667,181670,33,1029,0),
 (181668,181671,41,1029,0),
 (181669,181672,53,1029,0),
 (181670,181673,44,1029,0),
 (181671,181674,52,1029,0),
 (181672,181675,40,1029,0),
 (181673,181676,46,1029,0),
 (181674,181677,50,1029,0),
 (181675,181678,54,1029,0),
 (181676,181679,34,1029,0),
 (181677,181680,51,1029,0),
 (181678,181681,39,1029,0),
 (181679,181682,45,1029,0),
 (191007,191012,130,974,0),
 (191027,191032,131,974,0),
 (191066,191071,132,974,0),
 (212952,212957,0,3578,0),
 (212953,212958,1,3578,0),
 (212961,212966,0,3579,0),
 (212962,212967,1,3579,0),
 (212972,212977,0,3580,0),
 (212973,212978,1,3580,0),
 (212974,212979,0,3581,0),
 (212975,212980,1,3581,0),
 (212980,212985,0,3582,0),
 (212981,212986,1,3582,0),
 (212982,212987,0,3583,0),
 (212983,212988,1,3583,0),
 (212997,213002,0,3584,0),
 (212998,213003,1,3584,0),
 (212999,213004,0,3585,0),
 (213000,213005,1,3585,0),
 (213001,213006,0,3586,0),
 (213002,213007,1,3586,0),
 (213003,213008,0,3587,0),
 (213004,213009,1,3587,0),
 (309315,309321,0,5168,1),
 (309318,309324,0,5169,1),
 (309319,309325,0,5174,1),
 (309321,309327,0,5170,1),
 (309326,309332,0,5171,1),
 (309340,309346,0,5176,1),
 (309358,309364,0,5172,1),
 (309366,309372,0,5173,1),
 (309369,309375,1,5176,1),
 (309378,309384,0,5175,1),
 (309392,309398,0,5167,1),
 (309436,309442,2,5176,1),
 (309448,309454,0,5194,1),
 (309522,309528,1,5175,1),
 (309535,309541,0,5211,1),
 (309541,309547,1,5173,1),
 (309545,309551,0,5207,1),
 (309547,309553,0,5209,1),
 (309548,309554,1,5168,1),
 (309556,309562,4,5176,1),
 (309559,309565,0,5208,1),
 (309561,309567,0,5210,1),
 (309562,309568,1,5209,1),
 (309563,309569,0,5205,1),
 (309565,309571,0,5206,1),
 (309566,309572,3,5176,1),
 (309592,309598,2,5173,1),
 (309594,309600,1,5210,1),
 (309597,309603,0,5212,1),
 (348131,348137,0,7621,0),
 (348132,348138,0,7620,0),
 (348133,348139,0,7622,0),
 (348134,348140,0,7623,0),
 (348135,348141,0,7624,0),
 (348136,348142,0,7625,0),
 (348145,348151,0,7640,0),
 (348146,348152,0,7641,0),
 (348147,348153,0,7642,0),
 (348153,348159,0,7643,0),
 (348154,348160,0,7644,0),
 (348155,348161,0,7645,0),
 (348156,348162,0,7646,0),
 (348161,348167,0,7647,0),
 (348162,348168,0,7648,0),
 (83268602,83268602,7,83199124,0),
 (83268604,83268604,0,83199124,0),
 (83268607,83268607,1,83199124,0),
 (83268608,83268608,2,83199124,0),
 (83268609,83268609,3,83199124,0),
 (83268610,83268610,4,83199124,0),
 (83268611,83268611,5,83199124,0),
 (83268614,83268614,0,83199130,0),
 (83268632,83268632,1,83199130,0),
 (83268633,83268633,0,83199131,0),
 (83268634,83268634,6,83199124,0),
 (83268635,83268635,1,83199131,0),
 (83268637,83268637,8,83199124,0),
 (83268638,83268638,9,83199124,0),
 (83268639,83268639,10,83199124,0),
 (83268641,83268641,11,83199124,0),
 (83268643,83268643,2,83199130,0),
 (83268644,83268644,12,83199124,0),
 (83268646,83268646,0,83199133,0),
 (83268648,83268648,3,83199130,0),
 (83269201,83269201,4,83199130,0),
 (83289659,83289659,13,83199124,0),
 (83289660,83289660,5,83199130,0),
 (83289664,83289664,14,83199124,0),
 (83306816,83306816,6,83199130,0),
 (83306823,83306823,0,83199697,0),
 (83306824,83306824,7,83199130,0),
 (83307471,83307471,8,83199130,0),
 (83318958,83318958,15,83199124,0),
 (83326295,83326295,9,83199130,0),
 (83373310,83373311,0,83200391,0);

DROP TABLE IF EXISTS `ivehicle_days`;
CREATE TABLE  `ivehicle_days` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `d` date DEFAULT NULL,
  `sort_index` int(11) DEFAULT NULL,
  `ivehicle_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ivehicle_days__is` (`ivehicle_id`,`sort_index`),
  KEY `ivehicle_days__d` (`d`)
) ENGINE=InnoDB AUTO_INCREMENT=343025530 DEFAULT CHARSET=utf8 PACK_KEYS=0;

INSERT INTO `ivehicle_days` VALUES  (130,'2009-12-31',30,2),
 (131,'2009-10-01',7,2),
 (132,'2008-04-25',0,2),
 (133,'2008-05-02',1,2),
 (134,'2008-08-01',2,2),
 (135,'2008-08-19',3,2),
 (136,'2009-03-01',4,2),
 (199,'2009-09-01',6,2),
 (200,'2009-10-21',8,2),
 (201,'2009-10-29',12,2),
 (202,'2009-11-06',16,2),
 (203,'2009-11-12',17,2),
 (204,'2009-11-13',18,2),
 (205,'2009-11-19',20,2),
 (206,'2009-11-20',21,2),
 (207,'2009-11-24',22,2),
 (208,'2009-12-04',23,2),
 (209,'2009-12-07',24,2),
 (210,'2009-12-09',25,2),
 (211,'2010-01-12',34,2),
 (212,'2010-01-22',42,2),
 (213,'2010-01-29',44,2),
 (255,'2010-01-31',45,2),
 (257,'2010-01-04',32,2),
 (258,'2010-01-15',37,2),
 (259,'2010-01-26',43,2),
 (260,'2009-10-26',9,2),
 (261,'2009-10-27',10,2),
 (262,'2009-10-28',11,2),
 (263,'2009-10-30',13,2),
 (264,'2009-11-03',14,2),
 (265,'2009-11-04',15,2),
 (266,'2009-11-18',19,2),
 (267,'2010-01-18',38,2),
 (268,'2010-01-20',40,2),
 (269,'2010-01-19',39,2),
 (271,'2010-01-06',33,2),
 (272,'2010-01-21',41,2),
 (273,'2010-02-04',49,2),
 (274,'2010-01-13',35,2),
 (275,'2010-01-14',36,2),
 (276,'2009-12-18',26,2),
 (277,'2009-12-29',29,2),
 (279,'2009-04-24',5,2),
 (280,'2009-12-25',27,2),
 (282,'2010-02-19',56,2),
 (283,'2010-01-01',31,2),
 (285,'2010-02-18',55,2),
 (286,'2010-02-17',54,2),
 (289,'2009-12-28',28,2),
 (314,'2010-02-11',51,2),
 (315,'2010-02-12',52,2),
 (316,'2010-02-22',57,2),
 (318,'2010-02-01',46,2),
 (319,'2010-02-02',47,2),
 (320,'2010-02-03',48,2),
 (321,'2010-02-16',53,2),
 (325,'2010-02-26',59,2),
 (326,'2010-02-25',58,2),
 (378,'2010-02-05',50,2),
 (733,'2007-11-01',1,13),
 (734,'2008-02-01',3,13),
 (735,'2009-05-01',33,13),
 (737,'2009-10-01',51,13),
 (738,'2010-01-01',64,13),
 (739,'2009-01-01',24,13),
 (740,'2009-12-31',63,13),
 (744,'2007-09-11',0,13),
 (745,'2007-11-09',2,13),
 (746,'2008-02-04',4,13),
 (747,'2008-02-06',5,13),
 (748,'2008-02-21',6,13),
 (749,'2008-02-27',7,13),
 (750,'2008-03-11',8,13),
 (751,'2008-04-07',9,13),
 (752,'2008-04-09',10,13),
 (753,'2008-04-10',11,13),
 (754,'2008-04-11',12,13),
 (755,'2008-04-17',13,13),
 (756,'2008-04-21',14,13),
 (757,'2008-04-29',15,13),
 (758,'2008-06-24',16,13),
 (759,'2008-07-17',17,13),
 (760,'2008-09-10',18,13),
 (761,'2008-10-02',19,13),
 (762,'2008-10-09',20,13),
 (763,'2008-11-04',21,13),
 (764,'2008-12-10',22,13),
 (765,'2009-01-02',25,13),
 (766,'2009-01-13',26,13),
 (767,'2009-01-27',27,13),
 (768,'2009-02-09',28,13),
 (769,'2009-02-20',29,13),
 (770,'2009-03-09',30,13),
 (771,'2009-04-17',31,13),
 (772,'2009-04-24',32,13),
 (773,'2009-05-04',34,13),
 (774,'2009-05-22',35,13),
 (775,'2009-05-27',36,13),
 (776,'2009-06-15',37,13),
 (777,'2009-06-17',38,13),
 (778,'2009-06-19',39,13),
 (779,'2009-06-22',40,13),
 (780,'2009-07-08',42,13),
 (781,'2009-07-17',43,13),
 (782,'2009-08-18',44,13),
 (783,'2009-09-08',46,13),
 (784,'2009-09-11',47,13),
 (785,'2009-09-16',49,13),
 (786,'2009-10-21',52,13),
 (787,'2009-10-22',53,13),
 (788,'2009-11-25',56,13),
 (789,'2009-11-30',57,13),
 (790,'2009-12-11',60,13),
 (792,'2008-12-31',23,13),
 (794,'2009-06-30',41,13),
 (795,'2009-08-27',45,13),
 (796,'2009-09-21',50,13),
 (797,'2009-10-27',54,13),
 (798,'2009-11-23',55,13),
 (799,'2009-12-01',58,13),
 (800,'2009-12-08',59,13),
 (801,'2009-12-18',61,13),
 (802,'2009-12-22',62,13),
 (803,'2010-01-31',84,13),
 (804,'2010-01-07',68,13),
 (806,'2010-01-11',70,13),
 (807,'2010-01-12',71,13),
 (808,'2010-01-04',65,13),
 (811,'2010-01-13',72,13),
 (812,'2010-01-15',74,13),
 (813,'2010-01-21',77,13),
 (814,'2010-01-22',78,13),
 (815,'2010-01-28',82,13),
 (834,'2010-01-19',75,13),
 (835,'2010-01-05',66,13),
 (836,'2010-01-08',69,13),
 (837,'2010-01-26',80,13),
 (838,'2010-01-27',81,13),
 (839,'2010-01-29',83,13),
 (840,'2010-01-06',67,13),
 (841,'2010-01-14',73,13),
 (842,'2010-01-20',76,13),
 (843,'2010-01-25',79,13),
 (844,'2009-09-15',48,13),
 (845,'2010-02-23',96,13),
 (847,'2010-02-01',85,13),
 (848,'2010-02-04',86,13),
 (849,'2010-02-05',87,13),
 (850,'2010-02-09',88,13),
 (851,'2010-02-11',89,13),
 (852,'2010-02-12',90,13),
 (853,'2010-02-16',91,13),
 (854,'2010-02-17',92,13),
 (855,'2010-02-18',93,13),
 (856,'2010-02-19',94,13),
 (857,'2010-02-22',95,13),
 (858,'2010-02-24',97,13),
 (859,'2010-02-25',98,13),
 (894,'2008-08-01',4,16),
 (895,'2008-10-01',5,16),
 (912,'2010-01-01',19,16),
 (958,'2008-04-01',22,18),
 (959,'2008-04-18',24,18),
 (960,'2007-12-20',15,18),
 (961,'2007-12-28',16,18),
 (962,'2007-05-09',1,18),
 (963,'2007-05-30',4,18),
 (964,'2007-05-11',2,18),
 (965,'2007-06-18',6,18),
 (966,'2007-09-12',9,18),
 (967,'2007-11-28',14,18),
 (968,'2007-05-18',3,18),
 (969,'2007-06-26',8,18),
 (970,'2007-09-19',11,18),
 (971,'2009-12-30',31,18),
 (972,'2008-01-29',20,18),
 (973,'2008-08-31',25,18),
 (974,'2009-12-31',32,18),
 (975,'2008-01-28',19,18),
 (976,'2008-02-22',21,18),
 (977,'2007-06-08',5,18),
 (978,'2007-09-18',10,18),
 (979,'2007-06-22',7,18),
 (1024,'2009-12-04',27,18),
 (1025,'2010-01-15',39,18),
 (1026,'2010-02-15',50,18),
 (1029,'2010-01-31',44,18),
 (1030,'2009-01-01',26,18),
 (1032,'2010-01-14',38,18),
 (1033,'2010-02-01',45,18),
 (1035,'2010-01-06',36,18),
 (1036,'2010-02-08',47,18),
 (1043,'2010-01-04',34,18),
 (1044,'2010-01-12',37,18),
 (1045,'2010-02-05',46,18),
 (1046,'2010-02-10',48,18),
 (1047,'2010-02-12',49,18),
 (1048,'2010-02-16',51,18),
 (1054,'2010-01-20',40,18),
 (1062,'2010-01-05',35,18),
 (1116,'2010-01-01',33,18),
 (1551,'2010-01-01',0,19),
 (2583,'2008-01-01',18,18),
 (2584,'2007-01-01',0,18),
 (2591,'2007-10-15',13,18),
 (2595,'2008-04-17',23,18),
 (2702,'2007-12-31',17,18),
 (2707,'2007-10-14',12,18),
 (2711,'2009-12-25',30,18),
 (2712,'2010-01-25',41,18),
 (2713,'2010-02-25',52,18),
 (2945,'2009-12-24',29,18),
 (2946,'2009-12-23',28,18),
 (2947,'2010-01-29',42,18),
 (2948,'2010-02-26',53,18),
 (3510,'2010-01-30',43,18),
 (3578,'2009-09-29',4,50),
 (3579,'2009-10-15',5,50),
 (3580,'2009-11-16',6,50),
 (3581,'2009-12-15',7,50),
 (3582,'2010-01-19',8,50),
 (3583,'2010-01-28',9,50),
 (3584,'2007-10-31',0,50),
 (3585,'2007-12-21',1,50),
 (3586,'2008-04-30',2,50),
 (3587,'2008-06-10',3,50),
 (5167,'2006-07-03',0,16),
 (5168,'2006-07-05',1,16),
 (5169,'2006-07-28',2,16),
 (5170,'2006-08-01',3,16),
 (5171,'2009-02-02',8,16),
 (5172,'2009-06-30',13,16),
 (5173,'2009-09-01',15,16),
 (5174,'2009-12-01',18,16),
 (5175,'2010-01-04',20,16),
 (5176,'2010-02-01',21,16),
 (5194,'2009-06-01',12,16),
 (5205,'2008-10-02',6,16),
 (5206,'2009-01-02',7,16),
 (5207,'2009-03-06',9,16),
 (5208,'2009-04-01',10,16),
 (5209,'2009-05-01',11,16),
 (5210,'2009-07-01',14,16),
 (5211,'2009-09-04',16,16),
 (5212,'2009-10-01',17,16),
 (7620,'2009-06-19',10,79),
 (7621,'2009-06-18',9,79),
 (7622,'2009-11-13',11,79),
 (7623,'2009-12-11',12,79),
 (7624,'2010-01-11',13,79),
 (7625,'2010-01-20',14,79),
 (7640,'2007-05-09',0,79),
 (7641,'2007-05-15',1,79),
 (7642,'2007-05-16',2,79),
 (7643,'2007-05-17',3,79),
 (7644,'2007-05-18',4,79),
 (7645,'2007-06-06',5,79),
 (7646,'2007-06-27',6,79),
 (7647,'2007-07-03',7,79),
 (7648,'2008-11-04',8,79),
 (83199124,'2010-01-01',2,83197581),
 (83199129,'2008-12-31',0,83197581),
 (83199130,'2010-01-01',1,83197580),
 (83199131,'2010-01-01',0,83197579),
 (83199133,'2009-12-31',1,83197581),
 (83199697,'2009-12-31',0,83197580),
 (83200391,'2010-02-18',3,83197581),
 (108096943,'2008-06-30',0,108096943),
 (108096944,'2009-10-01',64,108096943),
 (108096945,'2009-11-01',79,108096943),
 (108096946,'2010-01-01',121,108096943),
 (108096947,'2010-02-01',143,108096943),
 (108096948,'2009-12-31',120,108096943),
 (108096949,'2008-12-31',4,108096943),
 (108096950,'2009-09-30',63,108096943),
 (108096951,'2009-10-31',78,108096943),
 (108096952,'2009-11-30',98,108096943),
 (108096953,'2010-01-31',142,108096943),
 (108096955,'2008-12-12',1,108096943),
 (108096956,'2008-12-17',2,108096943),
 (108096957,'2008-12-30',3,108096943),
 (108096958,'2009-01-05',5,108096943),
 (108096959,'2009-01-07',6,108096943),
 (108096960,'2009-01-09',7,108096943),
 (108096961,'2009-01-13',8,108096943),
 (108096962,'2009-01-28',9,108096943),
 (108096963,'2009-01-30',10,108096943),
 (108096964,'2009-02-02',11,108096943),
 (108096965,'2009-02-03',12,108096943),
 (108096966,'2009-02-12',13,108096943),
 (108096967,'2009-02-17',14,108096943),
 (108096968,'2009-02-18',15,108096943),
 (108096969,'2009-02-20',16,108096943),
 (108096970,'2009-02-23',17,108096943),
 (108096971,'2009-02-25',18,108096943),
 (108096972,'2009-02-26',19,108096943),
 (108096973,'2009-02-27',20,108096943),
 (108096974,'2009-03-02',21,108096943),
 (108096975,'2009-03-03',22,108096943),
 (108096976,'2009-03-04',23,108096943),
 (108096977,'2009-03-05',24,108096943),
 (108096978,'2009-03-10',25,108096943),
 (108096979,'2009-03-16',26,108096943),
 (108096980,'2009-03-17',27,108096943),
 (108096981,'2009-03-18',28,108096943),
 (108096982,'2009-03-19',29,108096943),
 (108096983,'2009-03-23',30,108096943),
 (108096984,'2009-03-25',31,108096943),
 (108096985,'2009-04-17',32,108096943),
 (108096986,'2009-04-21',33,108096943),
 (108096987,'2009-04-27',34,108096943),
 (108096988,'2009-05-01',35,108096943),
 (108096989,'2009-05-07',36,108096943),
 (108096990,'2009-06-18',37,108096943),
 (108096991,'2009-06-19',38,108096943),
 (108096992,'2009-06-22',39,108096943),
 (108096993,'2009-07-02',40,108096943),
 (108096994,'2009-07-21',41,108096943),
 (108096995,'2009-07-28',42,108096943),
 (108096996,'2009-07-30',43,108096943),
 (108096997,'2009-08-03',44,108096943),
 (108096998,'2009-08-10',45,108096943),
 (108096999,'2009-08-20',46,108096943),
 (108097000,'2009-08-21',47,108096943),
 (108097001,'2009-08-31',48,108096943),
 (108097002,'2009-09-01',49,108096943),
 (108097003,'2009-09-02',50,108096943),
 (108097004,'2009-09-03',51,108096943),
 (108097005,'2009-09-04',52,108096943),
 (108097006,'2009-09-08',53,108096943),
 (108097007,'2009-09-09',54,108096943),
 (108097008,'2009-09-11',55,108096943),
 (108097009,'2009-09-15',56,108096943),
 (108097010,'2009-09-16',57,108096943),
 (108097011,'2009-09-17',58,108096943),
 (108097012,'2009-09-18',59,108096943),
 (108097013,'2009-09-21',60,108096943),
 (108097014,'2009-09-28',61,108096943),
 (108097015,'2009-09-29',62,108096943),
 (108097016,'2009-10-02',65,108096943),
 (108097017,'2009-10-05',66,108096943),
 (108097018,'2009-10-06',67,108096943),
 (108097019,'2009-10-07',68,108096943),
 (108097020,'2009-10-12',69,108096943),
 (108097021,'2009-10-13',70,108096943),
 (108097022,'2009-10-14',71,108096943),
 (108097023,'2009-10-19',72,108096943),
 (108097024,'2009-10-20',73,108096943),
 (108097025,'2009-10-21',74,108096943),
 (108097026,'2009-10-23',75,108096943),
 (108097027,'2009-10-27',76,108096943),
 (108097028,'2009-10-29',77,108096943),
 (108097029,'2009-11-02',80,108096943),
 (108097030,'2009-11-03',81,108096943),
 (108097031,'2009-11-04',82,108096943),
 (108097032,'2009-11-05',83,108096943),
 (108097033,'2009-11-06',84,108096943),
 (108097034,'2009-11-09',85,108096943),
 (108097035,'2009-11-10',86,108096943),
 (108097036,'2009-11-11',87,108096943),
 (108097037,'2009-11-12',88,108096943),
 (108097038,'2009-11-13',89,108096943),
 (108097039,'2009-11-16',90,108096943),
 (108097040,'2009-11-17',91,108096943),
 (108097041,'2009-11-18',92,108096943),
 (108097042,'2009-11-19',93,108096943),
 (108097043,'2009-11-20',94,108096943),
 (108097044,'2009-11-23',95,108096943),
 (108097045,'2009-11-24',96,108096943),
 (108097046,'2009-11-27',97,108096943),
 (108097047,'2009-12-01',99,108096943),
 (108097048,'2009-12-02',100,108096943),
 (108097049,'2009-12-03',101,108096943),
 (108097050,'2009-12-04',102,108096943),
 (108097051,'2009-12-07',103,108096943),
 (108097052,'2009-12-08',104,108096943),
 (108097053,'2009-12-09',105,108096943),
 (108097054,'2009-12-10',106,108096943),
 (108097055,'2009-12-11',107,108096943),
 (108097056,'2009-12-14',108,108096943),
 (108097057,'2009-12-15',109,108096943),
 (108097058,'2009-12-16',110,108096943),
 (108097059,'2009-12-17',111,108096943),
 (108097060,'2009-12-18',112,108096943),
 (108097061,'2009-12-21',113,108096943),
 (108097062,'2009-12-22',114,108096943),
 (108097063,'2009-12-23',115,108096943),
 (108097064,'2009-12-24',116,108096943),
 (108097065,'2009-12-28',117,108096943),
 (108097066,'2009-12-29',118,108096943),
 (108097067,'2009-12-30',119,108096943),
 (108097068,'2010-01-04',122,108096943),
 (108097069,'2010-01-15',131,108096943),
 (108097070,'2010-01-20',134,108096943),
 (108097071,'2010-01-25',137,108096943),
 (108097118,'2010-01-05',123,108096943),
 (108097119,'2010-01-06',124,108096943),
 (108097120,'2010-01-07',125,108096943),
 (108097121,'2010-01-08',126,108096943),
 (108097122,'2010-01-11',127,108096943),
 (108097123,'2010-01-12',128,108096943),
 (108097124,'2010-01-13',129,108096943),
 (108097125,'2010-01-14',130,108096943),
 (108097126,'2010-01-18',132,108096943),
 (108097127,'2010-01-19',133,108096943),
 (108097128,'2010-01-21',135,108096943),
 (108097129,'2010-01-22',136,108096943),
 (108097130,'2010-01-26',138,108096943),
 (108097131,'2010-01-27',139,108096943),
 (108097132,'2010-01-28',140,108096943),
 (108097133,'2010-01-29',141,108096943),
 (108097134,'2010-02-02',144,108096943),
 (108097135,'2010-02-03',145,108096943),
 (108097136,'2010-02-09',149,108096943),
 (108097137,'2010-02-12',152,108096943),
 (108097138,'2010-02-15',153,108096943),
 (108097139,'2010-02-19',157,108096943),
 (108097140,'2010-02-26',162,108096943),
 (108097156,'2010-02-04',146,108096943),
 (108097157,'2010-02-05',147,108096943),
 (108097158,'2010-02-08',148,108096943),
 (108097159,'2010-02-10',150,108096943),
 (108097160,'2010-02-11',151,108096943),
 (108097161,'2010-02-16',154,108096943),
 (108097162,'2010-02-17',155,108096943),
 (108097163,'2010-02-18',156,108096943),
 (108097164,'2010-02-22',158,108096943),
 (108097165,'2010-02-23',159,108096943),
 (108097166,'2010-02-24',160,108096943),
 (108097167,'2010-02-25',161,108096943);

DROP TABLE IF EXISTS `proc_warnings`;
CREATE TABLE  `proc_warnings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(10) unsigned NOT NULL,
  `warning` varchar(2048) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `proc_warnings__transaction` (`transaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 PACK_KEYS=0;

INSERT INTO `proc_warnings` VALUES  (53,46989,'A'),
 (54,46990,'B');
 
--enable_query_log

connect(con1, localhost, root,,test,,);
connect(con2, localhost, root,,test,,);
connection default;

set transaction isolation level read committed;
set autocommit=0;
begin;
select count(*) from proc_warnings ;
DELETE pw 
FROM proc_warnings pw 
INNER JOIN day_position dp 
    ON dp.transaction_id = pw.transaction_id 
INNER JOIN ivehicle_days vd 
    ON vd.id = dp.ivehicle_day_id 
WHERE vd.ivehicle_id=2 AND dp.dirty_data=1;
select count(*) from proc_warnings ;

connection con1;

set transaction isolation level read committed;
set autocommit=0;
begin;
--send DELETE pw  FROM proc_warnings pw  INNER JOIN day_position dp     ON dp.transaction_id = pw.transaction_id INNER JOIN ivehicle_days vd     ON vd.id = dp.ivehicle_day_id WHERE vd.ivehicle_id=13 AND dp.dirty_data=1;

sleep 3;

connection con2;

SELECT * FROM information_schema.INNODB_LOCKS;
#WHERE LOCK_TABLE = 'test.proc_warnings';