--
-- Host: localhost    Database: frota
-- ------------------------------------------------------


--
-- Table structure for table `abastecimento`
--

CREATE TABLE `abastecimento` (
  `id_abastecimento` int(10) NOT NULL AUTO_INCREMENT,
  `id_veiculo` int(10) DEFAULT NULL,
  `id_motorista` int(10) DEFAULT NULL,
  `id_empresa` int(10) DEFAULT NULL,
  `data` date DEFAULT NULL,
  `km` int(10) DEFAULT NULL,
  `litros` float DEFAULT NULL,
  `preco_litro` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  PRIMARY KEY (`id_abastecimento`)
) ENGINE=InnoDB AUTO_INCREMENT=1359 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `abastecimento`
--

INSERT INTO `abastecimento` VALUES (14,3,20,5,'2016-10-24',123036,3710,3.858,14313.2),(15,4,12,4,'2016-10-24',73898,3586,3.849,13802.5),(16,5,23,3,'2016-10-24',68454,45.911,3.899,179.007),(17,6,20,3,'2016-10-24',NULL,30,3.229,96.87),(18,10,14,2,'2016-10-25',118142,35.8,3.799,136.004),(19,12,19,2,'2016-10-25',42165,31.07,3.799,118.035),(20,11,9,5,'2016-10-25',67207,45.901,3.914,179.657),(21,13,2,5,'2016-10-24',102107,41.48,3.858,160.03),(22,15,7,3,'2016-10-27',42524,26.683,3.899,104.037),(23,13,2,5,'2016-10-27',102519,42.44,3.858,163.734),(24,14,17,3,'2016-10-27',89617,54.121,3.899,211.018),(27,4,12,4,'2016-10-28',74348,37.43,3.849,144.068),(28,16,2,4,'2016-10-28',62649,20,3.95,79),(29,17,11,4,'2016-10-28',37529,35.912,3.849,138.225),(30,10,13,2,'2016-10-29',118597,36.071,3.799,137.034),(31,18,10,2,'2016-10-29',30097,42.002,3.799,159.566),(32,5,1,3,'2016-10-31',69052,23.6,3.899,92.0164),(33,13,2,5,'2016-11-01',103028,51.331,3.858,198.035),(34,3,20,5,'2016-11-01',123453,39,3.858,150.462),(35,19,18,4,'2016-11-01',73588,37.941,3.849,146.035),(36,4,12,4,'2016-11-01',74768,3794,37.941,143948),(37,5,23,3,'2016-11-03',69574,57.4,3.899,223.803),(38,12,19,2,'2016-11-03',42434,30.012,3.799,114.016),(39,7,16,2,'2016-11-04',36461,55.231,3.799,209.823),(40,10,14,2,'2016-11-04',118960,30.022,3.799,114.054),(41,15,7,3,'2016-11-04',42888,38.812,3.899,151.328),(42,13,2,5,NULL,NULL,NULL,NULL,0),(43,13,2,5,'2016-11-05',103390,42.12,3.858,162.499),(44,14,17,3,'2016-11-05',85066,47.712,3.899,186.029),(45,10,14,2,'2016-11-08',119470,37.872,3.799,143.876),(46,4,12,4,'2016-11-08',75277,41.31,3.849,159.002),(47,15,7,3,'2016-11-09',43339,41.633,3.899,162.327),(48,19,8,4,'2016-11-09',73904,31.181,3.849,120.016),(49,12,19,2,'2016-11-09',42730,30,3.799,113.97),(50,17,11,4,'2016-11-10',37808,29.892,3.849,115.054),(51,5,31,3,'2016-11-10',NULL,NULL,NULL,0),(52,24,23,3,'2016-11-10',NULL,5.132,3.899,20.0097),(53,11,9,5,'2016-11-11',67719,48.99,3.858,189.003),(54,18,10,2,'2016-11-11',30491,37.65,3.799,143.032),(55,19,8,4,'2016-11-11',74304,48.071,3.849,185.025),(56,25,16,3,'2016-11-11',37577,50.93,3.849,196.03),(57,10,14,2,'2016-11-11',119886,35.542,3.799,135.024),(58,4,12,4,'2016-11-12',75622,35.74,3.849,137.563),(59,3,11,5,'2016-11-14',NULL,NULL,NULL,0),(60,13,2,5,'2016-11-14',104150,49.9,3.858,192.514),(61,14,18,3,'2016-11-16',85495,50.923,3.849,196.003),(62,7,16,2,'2016-11-16',37007,56.882,3.799,216.095),(63,10,14,2,'2016-11-16',120372,38.782,3.799,147.333),(64,15,7,3,'2016-11-16',43687,33.412,3.849,128.603),(65,4,12,4,'2016-11-17',76063,36.821,3.849,141.724),(66,15,7,3,'2016-11-18',44045,35.453,3.849,136.459),(67,25,2,3,'2016-11-20',38087,50.402,3.849,193.997),(68,17,11,4,'2016-11-18',38136,42.36,3.849,163.044),(69,12,19,2,'2016-11-18',42992,29.5,3.799,112.071),(70,15,7,3,'2016-11-21',44252,20.78,3.849,79.9822),(71,18,10,2,'2016-11-21',30961,39.43,3.799,149.795),(72,4,12,4,'2016-11-22',76404,31.25,3.849,120.281),(74,13,6,5,'2016-11-23',104505,42.9,3.858,165.508),(75,15,7,3,'2016-11-23',44655,40.792,3.849,157.008),(76,19,8,4,'2016-11-23',74663,37.432,3.849,144.076),(77,25,2,3,'2016-11-24',38988,41.57,3.849,160.003),(78,10,14,2,'2016-11-24',120764,32.002,3.799,121.576),(79,14,18,3,'2016-11-24',85981,51.182,3.849,197),(80,9,20,5,'2016-11-24',21732,37.33,3.858,144.019),(81,5,23,3,'2016-11-24',70326,52.221,3.849,200.999),(82,4,12,4,'2016-11-25',76922,42.36,3.849,163.044),(83,13,2,5,'2016-11-28',104821,36.011,3.858,138.93),(84,11,9,5,'2016-11-28',68230,46.68,3.858,180.091),(85,17,11,4,'2016-11-29',38489,38.2,3.849,147.032),(86,15,7,3,'2016-11-29',45011,40.63,3.849,156.385),(87,10,14,2,'2016-11-29',121251,37.271,3.799,141.593),(88,4,12,4,'2016-11-30',77335,33.012,3.849,127.063),(89,19,8,4,'2016-11-30',75037,49.11,3.849,189.024),(90,15,18,3,'2016-11-30',45367,33.061,3.849,127.252),(91,14,7,3,'2016-11-30',86204,31.63,3.849,121.744),(92,7,16,2,'2016-11-30',37459,54.452,3.799,206.863),(93,10,14,2,'2016-12-01',121633,31.852,3.799,121.006),(94,18,10,2,'2016-12-02',31439,42.91,3.799,163.015),(95,9,20,5,'2016-12-02',22046,34.48,3.858,133.024),(96,4,12,4,'2016-12-02',77640,30.93,3.849,119.05),(97,12,19,2,'2016-12-03',43283,39,3.799,148.161),(98,13,6,5,'2016-12-05',105516,51.84,3.858,199.999),(99,27,1,3,'2016-12-05',58240,48.962,3.229,158.098),(100,25,22,3,'2016-12-05',39356,38.973,3.849,150.007),(101,26,24,5,'2016-12-05',51512,42.51,3.858,164.004),(102,19,8,4,'2016-12-06',75469,41.57,3.849,160.003),(103,15,7,3,'2016-12-06',45655,26.502,3.849,102.006),(105,4,12,4,'2016-12-07',78049,37.432,3.849,144.076),(106,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(107,8,9,5,'2016-12-07',57367,37,3.958,146.446),(108,10,14,2,'2016-12-08',122082,37.511,3.899,146.255),(109,17,11,4,'2016-12-08',38806,40.111,3.899,156.393),(110,13,3,5,'2016-12-09',105947,51.041,3.958,202.02),(111,15,7,3,'2016-12-09',45978,31.521,3.969,125.107),(112,13,2,5,'2016-12-12',106141,21.58,3.858,83.2556),(113,16,18,4,'2016-12-12',63424,59.98,3.969,238.061),(114,10,12,4,'2016-12-12',78407,31.85,3.899,124.183),(115,19,8,4,'2016-12-12',75690,26.45,3.899,103.129),(116,18,10,2,'2016-12-12',31845,37.452,3.899,146.025),(117,12,19,2,'2016-12-13',43695,37962,3.899,148014),(118,25,23,3,'2016-12-13',39879,50.392,3.969,200.006),(119,9,20,5,'2016-12-13',22386,38.912,3.958,154.014),(120,10,14,2,'2016-12-14',122574,39.252,3.899,153.044),(121,15,7,3,'2016-12-14',46306,31.25,3.969,124.031),(122,4,12,4,'2016-12-15',78808,27.972,3.899,109.063),(123,7,16,2,'2016-12-15',37910,54.092,3.899,210.905),(124,10,13,2,'2016-12-16',123002,35.53,3.899,138.531),(125,15,7,3,'2016-12-16',46590,27.122,3.969,107.647),(126,8,9,5,'2016-12-16',57714,37.74,3.958,149.375),(128,19,8,2,'2016-12-19',76031,33.861,3.899,132.024),(129,15,7,2,'2016-12-19',46756,14.952,3.949,59.0454),(130,10,14,2,'2016-12-19',123401,31.07,3.899,121.142),(131,14,18,3,'2016-12-19',86626,50.391,3.969,200.002),(132,4,12,4,'2016-12-20',79189,36.26,3.899,141.378),(133,10,14,2,'2016-12-21',123904,29.242,3.899,114.015),(134,26,23,5,'2016-12-21',33800,46.892,3.969,186.114),(135,25,31,3,'2016-12-20',40100,26.822,3.969,106.457),(136,29,1,3,'2016-12-21',50491,31.24,3.969,123.992),(137,18,10,2,'2016-12-21',32319,42,3.899,163.758),(138,12,19,2,'2016-12-21',44048,34.882,3.899,136.005),(140,30,21,5,'2016-12-22',34802,38.212,3.958,151.243),(141,24,16,3,'2016-12-22',14876,4.032,3.969,16.003),(142,10,14,2,'2016-12-23',124303,30.781,3.899,120.015),(143,15,7,3,'2016-12-23',47327,32.76,3.969,130.024),(144,13,3,5,'2016-12-23',107449,53.31,3.958,211.001),(145,15,7,3,'2016-12-21',46961,20.162,3.969,80.023),(146,25,1,3,'2016-12-23',40886,42.083,3.969,167.027),(147,4,12,4,'2016-12-23',79627,36.941,3.899,144.033),(148,17,11,4,'2016-12-23',39132,40,3.899,155.96),(149,27,2,2,'2016-12-26',58466,40.773,3.099,126.356),(150,19,8,4,'2016-12-26',76917,45.41,3.898,177.008),(151,19,8,4,'2016-12-21',76355,35.62,3.899,138.882),(152,10,14,2,'2016-12-26',124705,32.3,3.949,127.553),(153,8,9,5,'2016-12-27',58061,37.411,3.958,148.073),(154,14,15,3,'2016-12-27',81046,48.132,3.969,191.036),(155,7,16,2,'2016-12-27',38288,45.92,3.899,179.042),(156,15,7,3,'2016-12-28',47641,29.012,3.969,115.149),(157,4,12,4,'2016-12-28',80012,34.64,3.899,135.061),(158,12,19,2,'2016-12-29',44355,32,3.899,124.768),(159,18,10,2,'2016-12-29',32752,39.242,3.899,153.005),(160,10,14,2,'2016-12-29',125113,31.36,3.899,122.273),(161,9,20,5,'2016-12-30',22758,40,3.958,158.32),(162,10,13,2,'2016-12-31',125453,26.931,3.899,105.004),(163,19,8,4,'2017-01-02',77269,39.07,3.969,155.069),(164,12,19,2,'2017-01-02',44684,27.462,3.899,107.074),(165,10,14,2,'2017-01-03',125832,32.071,3.899,125.045),(166,27,2,2,'2017-01-03',59152,42.941,3.099,133.074),(168,18,10,2,'2017-01-04',33179,35.972,3.899,140.255),(169,15,7,3,'2017-01-04',47906,30.262,3.969,120.11),(170,8,9,5,'2017-01-04',58418,36.03,3.998,144.048),(171,14,15,3,'2017-01-04',87507,50.901,3.969,202.026),(172,10,12,2,'2017-01-04',80474,42.73,3.899,166.604),(173,27,2,2,'2017-01-05',59371,31,3.071,95.201),(174,17,11,4,'2017-01-05',39845,39.511,3.899,154.053),(175,13,31,5,'2017-01-05',108319,50.75,3.958,200.868),(177,19,8,4,'2017-01-07',77861,35.141,3.899,137.015),(178,27,1,2,'2017-01-07',59671,33.462,3.071,102.762),(180,27,2,2,'2017-01-09',60245,34.032,3.099,105.465),(181,10,14,2,'2017-01-09',126302,32.071,3.899,125.045),(182,18,10,2,'2017-01-09',33597,35.41,3.899,138.064),(183,12,19,2,'2017-01-09',44959,35.661,3.899,139.042),(184,13,14,5,'2017-01-10',108869,49.11,3.998,196.342),(185,19,8,4,'2017-01-11',78489,43.112,3.899,168.094),(186,25,23,3,'2017-01-11',41354,51.461,3.969,204.249),(187,7,16,2,'2017-01-12',38787,56.682,3.899,221.003),(188,13,2,5,'2016-12-20',106897,49.69,3.958,196.673),(189,18,10,2,'2017-01-13',33957,31.3,3.899,122.039),(190,13,14,5,'2017-01-13',109368,48.78,3.998,195.022),(191,8,9,5,'2017-01-13',58813,39.27,3.998,157.001),(192,9,11,5,'2017-01-13',23175,41.031,3.998,164.042),(193,29,25,3,'2017-01-13',55308,38.513,3.969,152.858),(194,12,19,2,'2017-01-16',45289,32.2,3.899,125.548),(195,27,2,2,'2017-01-16',61007,50.021,3.099,155.015),(196,14,18,3,'2017-01-17',87965,54.882,3.969,217.827),(197,13,13,5,'2017-01-17',109929,49.53,3.998,198.021),(198,18,10,2,'2017-01-18',34401,38.042,3.899,148.326),(199,30,29,2,'2017-01-18',34865,NULL,NULL,0),(200,27,2,2,'2017-01-19',61436,50.01,3.099,154.981),(201,19,8,4,'2017-01-19',78859,42.34,3.899,165.084),(202,17,11,4,'2017-01-19',39827,40.04,3.899,156.116),(203,13,13,5,'2017-01-20',110382,44.8,3.998,179.11),(204,12,19,2,'2017-01-20',45592,27.19,3.899,106.014),(205,7,16,2,'2017-01-20',39256,50.591,3.899,197.254),(206,4,12,4,'2017-01-23',80882,38.752,3.899,151.094),(207,18,10,2,'2017-01-23',34836,36.931,3.899,143.994),(208,27,2,2,'2017-01-24',61834,58.791,3.099,182.193),(209,9,3,5,'2017-01-24',23432,28.07,3.998,112.224),(210,15,13,3,'2017-01-24',48202,28.472,3.969,113.005),(211,25,1,3,'2017-01-24',41748,32.76,3.969,130.024),(212,19,8,4,'2017-01-26',79285,44.37,3.899,172.999),(213,12,19,2,'2017-01-27',45913,31.291,3.899,122.004),(214,13,13,5,'2017-01-25',110873,52.362,3.998,209.343),(215,29,25,3,'2017-01-27',55695,41.322,3.969,164.007),(216,13,13,5,'2017-01-28',111274,39.93,3.958,158.043),(217,27,2,2,'2017-01-30',62299,48.41,3.099,150.023),(218,9,2,2,'2017-01-30',23849,35.141,3.899,137.015),(219,18,10,2,'2017-01-31',35260,36.1,3.899,140.754),(220,4,12,4,'2017-01-31',81267,34.382,3.899,134.055),(221,14,17,3,'2017-01-31',88403,45.862,3.969,182.026),(222,15,7,3,'2017-01-31',48518,32.252,3.969,128.008),(223,44,1,2,'2017-02-01',68903,52.392,3.099,162.363),(224,25,1,2,'2017-02-01',42489,41.76,3.899,162.822),(225,13,14,5,'2017-02-01',111733,44.47,3.958,176.012),(226,7,15,2,'2017-02-01',39782,57.472,3.899,224.083),(227,17,11,4,'2017-02-01',40169,40.27,3.899,157.013),(228,27,2,2,'2017-02-01',62688,55.1,3.099,170.755),(229,9,2,2,'2017-02-01',24292,35.4,3.899,138.025),(230,12,19,2,'2017-02-02',46248,31.04,3.899,121.025),(231,4,12,4,'2017-02-03',81649,33.861,3.899,132.024),(232,13,14,5,'2017-02-04',112241,51.451,3.958,203.643),(233,6,22,4,'2017-02-04',NULL,30,3.229,96.87),(234,15,18,3,'2017-02-06',NULL,NULL,NULL,0),(235,8,9,5,'2017-02-06',59549,38.72,3.958,153.254),(236,27,2,2,'2017-02-07',62977,30.75,3.099,95.2943),(237,4,12,4,'2017-02-07',81829,26.1,3.899,101.764),(238,19,8,4,'2017-02-07',79538,29.501,3.899,115.024),(239,18,10,2,'2017-02-08',35706,37.09,3.899,144.614),(240,14,7,3,'2017-02-08',NULL,NULL,NULL,0),(241,13,13,5,'2017-02-09',112696,44.22,3.958,175.023),(242,19,8,4,'2017-02-09',79971,41.301,3.899,161.033),(243,7,15,2,'2017-02-10',40222,52.581,3.899,205.013),(244,45,1,5,'2017-02-10',78880,42.1,3.958,166.632),(245,27,2,28,'2017-02-10',63554,58.761,2.849,167.41),(246,13,14,5,'2017-02-13',113202,47.08,3.958,186.343),(247,29,25,3,'2017-02-13',55972,41.321,3.969,164.003),(248,18,10,2,'2017-02-14',36051,38.731,3.899,151.012),(249,15,7,3,'2017-02-14',49546,37.2,3.969,147.647),(250,27,2,2,'2017-02-15',63737,50.011,3.099,154.984),(251,19,8,4,'2017-02-16',80345,43.351,3.899,169.026),(252,8,9,5,'2017-02-16',59835,33.611,3.958,133.032),(253,8,9,5,'2017-01-25',59189,40.991,3.998,163.882),(254,13,14,5,'2017-02-17',113595,43,3.958,170.194),(255,14,17,4,'2017-02-17',89184,51.301,3.899,200.023),(256,25,1,3,'2017-02-17',42927,45.963,3.969,182.427),(257,17,11,5,'2017-02-17',40491,37.901,3.958,150.012),(258,13,13,5,'2017-02-20',114008,42.451,3.958,168.021),(259,27,2,2,'2017-02-20',64072,53.031,3.099,164.343),(261,25,8,3,'2017-02-21',43239,30.133,3.969,119.598),(262,18,10,2,'2017-02-21',36493,36.19,3.899,141.105),(263,12,19,2,'2017-02-21',46608,36.172,3.899,141.035),(264,13,13,5,'2017-02-22',114493,41.701,3.958,165.053),(265,7,17,2,'2017-02-22',40670,53.651,3.899,209.185),(266,15,7,3,'2017-02-22',49795,32.622,3.969,129.477),(267,9,22,5,'2017-02-22',24679,36,3.958,142.488),(268,29,31,3,'2017-02-23',56114,25.021,3.969,99.3083),(269,27,2,28,'2017-02-24',64471,41.071,2.84,116.642),(270,19,18,4,'2017-02-24',81113,42.85,3.899,167.072),(271,18,10,2,'2017-02-25',36986,38.042,3.899,148.326),(272,13,13,5,'2017-02-25',114939,46.742,3.958,185.005),(273,25,22,3,'2017-02-27',43942,54.37,3.969,215.795),(274,19,18,28,'2017-02-24',81216,13.162,3.799,50.0024),(275,15,7,3,'2017-03-01',50135,30.239,3.969,120.019),(276,27,2,2,'2017-03-01',64757,46.071,3.099,142.774),(277,8,9,5,'2017-03-01',60205,38.912,3.958,154.014),(278,12,19,2,'2017-03-01',46995,35.282,3.899,137.565),(279,13,14,5,'2017-03-01',115393,46,3.958,182.068),(280,14,15,3,'2017-03-01',89569,50.431,3.969,200.161),(281,7,16,2,'2017-03-03',41196,53.092,3.899,207.006),(282,17,20,4,'2017-03-03',40851,39.159,3.899,152.681),(283,19,8,4,'2017-03-03',81497,39.259,3.899,153.071),(284,4,12,30,'2017-03-03',82352,41.312,3.742,154.59),(285,18,10,2,'2017-03-03',37472,41.971,3.899,163.645),(286,9,14,5,'2017-03-04',25106,31.812,3.898,124.003),(287,25,22,3,'2017-03-05',44179,18.872,3.969,74.903),(290,13,14,5,'2017-03-06',115763,43.79,3.898,170.693),(291,12,19,2,'2017-03-07',47378,35.4,3.899,138.025),(292,15,7,30,'2017-03-08',50399,27.59,3.743,103.269),(293,14,15,3,'2017-03-09',89952,43.902,3.969,174.247),(294,8,9,5,'2017-03-09',60507,36.79,3.898,143.407),(295,18,10,2,'2017-03-09',37976,39.27,3.899,153.114),(296,29,25,3,'2017-03-09',56444,39.812,3.969,158.014),(297,13,13,30,'2017-03-09',116369,54.16,3.743,202.721),(298,7,16,2,'2017-03-10',51715,56.31,3.899,219.553),(299,25,22,28,'2017-03-09',45263,63.6,3.969,252.428),(300,19,11,4,'2017-03-11',82005,43.86,3.899,171.01),(301,27,2,2,'2017-03-13',65479,33,2.999,98.967),(302,18,10,2,'2017-03-14',38419,38.741,3.899,151.051),(303,13,14,30,'2017-03-14',116869,47.59,3.743,178.129),(304,15,7,30,'2017-03-14',50736,37.461,3.743,140.217),(305,17,11,4,'2017-03-15',41178,36.171,3.899,141.031),(306,4,12,30,'2017-03-15',82776,37.45,3.743,140.175),(307,12,19,2,'2017-03-15',47721,33.691,3.899,131.361),(308,25,22,3,'2017-03-15',45279,45.861,3.969,182.022),(309,27,2,2,'2017-03-15',65949,48.78,2.999,146.291),(310,8,9,5,'2017-03-17',60806,35.202,3.978,140.034),(311,13,13,30,'2017-03-18',117298,34.609,3.74,129.438),(312,25,14,28,'2017-03-17',NULL,NULL,NULL,0),(313,14,15,3,'2017-03-18',NULL,NULL,NULL,0),(314,4,12,30,'2017-03-20',83139,32.711,3.743,122.437),(315,25,22,28,'2017-03-17',45788,25.063,3.99,100.001),(316,19,8,4,'2017-03-20',82376,44.75,3.899,174.48),(317,27,3,2,'2017-03-21',66275,40.031,2.999,120.053),(318,29,25,3,'2017-03-21',56724,38.551,3.969,153.009),(319,25,22,3,'2017-03-22',45966,36.791,3.969,146.023),(320,15,7,30,'2017-03-23',51032,32.929,3.743,123.253),(321,12,19,2,'2017-03-23',48059,33.201,3.899,129.451),(322,7,16,2,'2017-03-24',42223,55.471,3.899,216.281),(323,4,12,30,'2017-03-24',83580,41.06,3.743,153.688),(324,17,11,4,'2017-03-24',NULL,NULL,NULL,0),(325,19,8,4,'2017-03-24',83139,35.93,3.899,140.091),(327,18,10,2,'2017-03-25',38857,39.459,3.899,153.851),(328,13,13,30,'2017-03-25',117835,56.01,3.743,209.645),(329,15,7,30,'2017-03-25',51318,29.89,3.743,111.878),(330,14,15,3,'2017-03-27',90816,48.881,3.969,194.009),(331,15,7,30,'2017-03-28',51598,25.21,3.743,94.361),(332,27,13,2,'2017-03-28',66227,41.631,2.999,124.851),(333,4,12,30,'2017-03-29',83949,35.999,3.743,134.744),(334,44,3,2,'2017-03-29',69233,47.35,2.999,142.003),(335,8,9,5,'2017-03-30',61161,40.292,3.898,157.058),(336,15,7,30,'2017-03-30',51892,29.942,3.743,112.073),(337,12,19,30,'2017-03-30',48378,30.731,3.899,119.82),(338,19,8,4,'2017-03-30',83437,36.961,3.775,139.528),(339,18,10,2,'2017-03-31',39325,37.579,3.899,146.521),(340,19,18,4,'2017-04-01',83967,42.119,3.799,160.01),(342,27,14,30,'2017-04-01',67299,51.302,3.089,158.472),(343,4,12,30,'2017-04-03',84351,36.8,3.743,137.742),(344,44,2,2,'2017-04-03',69581,45.849,2.999,137.501),(345,46,13,2,'2017-04-03',NULL,5,3.899,19.495),(346,25,1,3,'2017-04-03',46535,51.151,3.969,203.018),(347,7,16,2,'2017-04-04',42786,56.171,3.899,219.011),(348,19,8,28,'2017-03-31',84285,12.04,4.159,50.0744),(349,14,15,3,'2017-04-04',91777,47.883,3.969,190.048),(350,25,31,3,'2017-04-04',46642,14.371,3.969,57.0385),(351,17,11,4,'2017-04-05',41820,33.541,3.799,127.422),(352,9,31,5,'2017-04-05',25323,25.08,3.898,97.7618),(353,27,13,30,'2017-04-06',67721,38.22,3.089,118.062),(354,29,25,3,'2017-04-06',56997,41.582,3.969,165.039),(355,12,19,2,'2017-04-06',48664,28.469,3.899,111.001),(356,4,12,30,'2017-04-07',84700,33.23,3.743,124.38),(357,44,3,2,'2017-04-10',70520,51.021,2.999,153.012),(358,27,13,30,'2017-04-10',68063,34.112,3.089,105.372),(359,19,18,4,'2017-04-10',84743,40.022,3.799,152.044),(360,15,7,30,'2017-04-10',52182,30.049,3.743,112.473),(361,25,8,3,'2017-04-11',46741,13.431,3.969,53.3076),(362,7,17,2,'2017-04-11',43229,51.301,3.899,200.023),(363,4,12,30,'2017-04-11',85114,40.68,3.743,152.265),(364,44,2,2,'2017-04-12',70868,39.68,2.999,119),(365,15,7,30,'2017-04-12',52477,28.741,3.743,107.578),(366,19,18,4,'2017-04-12',85087,35.541,3.799,135.02),(367,12,19,30,'2017-04-12',48975,28.68,3.743,107.349),(368,27,14,30,'2017-04-12',68421,39,3.089,120.471),(369,18,10,2,'2017-04-13',39730,40.011,3.899,156.003),(370,17,11,4,'2017-04-13',42099,35.399,3.799,134.481),(371,14,15,3,'2017-04-13',91518,45.341,3.969,179.958),(372,8,9,5,'2017-04-13',61455,38.691,3.898,150.818),(373,27,13,30,'2017-04-15',68692,42.082,3.089,129.991),(374,15,7,30,'2017-04-17',52878,37.841,3.743,141.639),(375,19,18,4,'2017-04-17',85529,43.441,3.799,165.032),(376,25,8,3,'2017-04-17',47460,44.109,3.969,175.069),(377,13,1,2,'2017-04-17',118359,57,3.899,222.243),(378,44,2,2,'2017-04-18',71167,40.021,2.999,120.023),(379,27,14,30,'2017-04-18',69140,50.182,3.089,155.012),(380,4,12,30,'2017-04-18',85388,26.061,3.743,97.5463),(383,15,7,30,'2017-04-19',53167,29.67,3.743,111.055),(384,12,19,30,'2017-04-20',49315,33.571,3.743,125.656),(385,7,16,2,'2017-04-20',43610,43.701,3.899,170.39),(386,27,14,30,'2017-04-22',69549,36.482,3.089,112.693),(387,4,12,30,'2017-04-24',85745,35.461,3.743,132.731),(388,19,18,4,'2017-04-24',85805,29.972,3.799,113.864),(389,17,11,4,'2017-04-24',42455,38.69,3.799,146.983),(390,25,8,3,'2017-04-24',NULL,NULL,NULL,0),(391,25,31,2,'2017-04-24',48025,NULL,NULL,0),(392,18,10,2,'2017-04-25',40177,40.79,3.899,159.04),(393,29,24,4,'2017-04-25',57926,42.391,3.799,161.043),(394,18,10,2,'2017-04-25',NULL,NULL,NULL,0),(395,14,15,3,'2017-04-25',91985,46.612,3.969,185.003),(396,27,13,30,'2017-04-26',70024,49.081,3.089,151.611),(397,4,12,30,'2017-04-26',86088,32.05,3.743,119.963),(398,44,3,2,'2017-04-26',71582,52.361,2.999,157.031),(399,8,9,5,'2017-04-26',61766,35.172,3.898,137.1),(400,19,18,4,'2017-04-27',86166,42.73,3.799,162.331),(401,12,19,30,'2017-04-27',48629,31.68,3.743,118.578),(402,27,13,30,'2017-04-28',70376,39.612,3.089,122.361),(403,4,12,30,'2017-04-29',86470,38.341,3.743,143.51),(404,27,13,30,'2017-04-29',70795,50,3.089,154.45),(405,13,2,2,'2017-05-02',118771,46.61,3.899,181.732),(406,25,8,3,'2017-05-02',48814,33.27,3.96,131.749),(407,44,2,2,'2017-05-03',71892,38.35,2.999,115.012),(408,6,22,2,'2017-05-03',NULL,20,2.999,59.98),(409,19,18,4,'2017-05-03',86486,33.83,3.799,128.52),(410,15,7,30,'2017-05-03',53471,33.101,3.743,123.897),(411,4,12,30,'2017-05-04',86858,38.251,3.743,143.173),(412,12,19,2,'2017-05-05',49952,27.879,3.899,108.7),(413,17,20,4,'2017-05-05',48823,41.18,3.799,156.443),(414,18,10,2,'2017-05-08',40659,42.291,3.899,164.893),(415,14,21,3,'2017-05-08',92290,51.592,3.999,206.316),(416,7,16,2,'2017-05-08',44096,57.431,3.899,223.923),(417,25,8,3,'2017-05-08',NULL,NULL,NULL,0),(418,8,9,5,'2017-05-08',62123,40.56,3.898,158.103),(419,4,12,30,'2017-05-09',87171,29.721,3.743,111.246),(420,19,18,4,'2017-05-09',86764,25.799,3.799,98.0104),(421,27,13,30,'2017-05-09',71186,48,3.089,148.272),(423,44,6,5,'2017-05-10',72355,51.71,2.99,154.613),(424,25,31,3,'2017-05-10',49410,11.372,3.999,45.4766),(425,12,19,5,'2017-05-11',50240,27.47,3.89,106.858),(426,13,6,5,'2017-05-11',119130,35.53,3.898,138.496),(427,19,18,4,'2017-05-11',87044,32.74,3.775,123.593),(428,15,7,30,'2017-05-11',53748,30.301,3.743,113.417),(429,4,12,30,'2017-05-11',87568,35.761,3.743,133.853),(430,27,13,30,'2017-05-13',71497,37.812,3.089,116.801),(431,44,2,2,'2017-05-15',72583,30.35,2.99,90.7465),(432,25,22,3,'2017-05-15',50266,37.51,3.99,149.665),(433,14,15,3,'2017-05-16',92648,44.832,3.999,179.283),(434,4,12,30,'2017-05-16',87919,36.14,3.74,135.164),(436,27,13,30,'2017-05-16',71759,25.19,3.089,77.8119),(437,18,10,2,'2017-05-17',41065,37.87,3.899,147.655),(438,19,18,4,'2017-05-17',87427,33.709,3.79,127.757),(439,13,31,2,'2017-05-17',119537,44.63,3.899,174.012),(440,12,19,2,'2017-05-17',50452,23091,3.899,90031.8),(441,15,7,30,'2017-05-17',54101,36.44,142.08,5177.4),(442,29,25,4,'2017-05-18',NULL,NULL,NULL,0),(443,8,9,5,'2017-05-18',62457,39.77,3.898,155.023),(444,17,11,4,'2017-05-18',43151,39,3.799,148.161),(445,27,14,30,'2017-05-19',72091,34.232,3.089,105.743),(446,13,1,2,'2017-05-19',119686,12.31,3.89,47.8859),(447,27,14,30,'2017-05-20',72492,48.699,3.089,150.431),(448,7,16,2,'2017-05-22',44582,54.83,3.899,213.782),(449,19,18,4,'2017-05-22',87760,41.46,3.799,157.507),(450,4,12,30,'2017-05-22',NULL,NULL,NULL,0),(451,44,2,2,'2017-05-22',73439,41.02,2.99,122.65),(452,12,19,2,'2017-05-23',50711,25.592,3.899,99.7832),(453,25,22,3,'2017-05-23',51220,52.07,NULL,0),(454,27,13,30,'2017-05-23',72851,43.73,3.089,135.082),(455,14,15,3,'2017-05-23',92988,44.033,3.999,176.088),(456,19,18,4,'2017-05-24',88016,25.07,3.799,95.2409),(457,44,2,2,'2017-05-24',73739,31.81,2.99,95.1119),(458,15,7,30,'2017-05-24',54464,35.13,3.74,131.386),(459,4,12,30,'2017-05-24',88698,39.15,3.74,146.421),(460,19,18,4,'2017-05-26',88389,36.34,3.799,138.056),(461,44,2,2,'2017-05-26',74102,43.062,2.99,128.755),(462,27,13,30,'2017-05-27',73143,21.66,3.089,66.9077),(463,4,12,30,'2017-05-29',89024,33.46,3.74,125.14),(464,18,10,2,'2017-05-29',84875,40.01,3.899,155.999),(465,17,11,4,'2017-05-29',43511,39.76,3.799,151.048),(466,8,9,5,'2017-05-30',62750,35.49,33.898,1203.04),(467,44,2,2,'2017-05-30',74513,25.009,2.99,74.7769),(468,15,7,30,'2017-05-30',54811,31.08,3.74,116.239),(469,27,13,30,'2017-05-30',73523,43.64,3.089,134.804),(471,44,3,2,'2017-05-30',74818,48.35,2.99,144.566),(472,13,8,2,'2017-05-31',119997,29.5,3.899,115.021),(473,12,19,2,'2017-05-31',51043,33.71,3.899,131.435),(474,14,15,3,'2017-05-31',93421,50.21,3.999,200.79),(475,25,31,3,'2017-06-01',51405,12.69,3.99,50.6331),(476,19,18,4,'2017-06-01',88655,26.52,3.799,100.749),(477,27,14,30,'2017-06-02',73919,43.02,3.089,132.889),(478,4,12,30,'2017-06-02',89364,44.33,3.74,165.794),(479,7,16,2,'2017-06-06',45041,53.48,3.74,200.015),(480,27,13,30,'2017-06-06',74275,41.47,2.999,124.369),(481,25,8,3,'2017-06-06',57542,20.522,4.049,83.0936),(482,4,12,30,'2017-06-06',89740,37.36,3.599,134.459),(483,15,7,30,'2017-06-06',35005,21,3.599,75.579),(484,44,3,2,'2017-06-07',75096,34.15,2.899,99.0008),(485,29,25,4,'2017-06-07',58449,40.011,3.699,148.001),(486,18,10,2,'2017-06-07',41972,43.12,3.74,161.269),(487,6,22,2,'2017-06-08',NULL,50,2.899,144.95),(488,8,9,5,'2017-06-08',NULL,NULL,NULL,0),(489,8,9,2,'2017-06-08',63060,40.57,3.848,156.113),(490,12,19,2,'2017-06-08',51381,35.31,3.74,132.059),(491,19,18,4,'2017-06-09',NULL,NULL,NULL,0),(492,6,22,4,'2017-06-09',NULL,NULL,NULL,0),(493,4,12,30,'2017-06-09',90093,36.68,3.599,132.011),(494,27,17,30,'2017-06-09',74546,34.57,2.99,103.364),(495,25,22,3,'2017-06-09',52375,31.76,3.999,127.008),(496,17,20,4,'2017-06-10',43825,36.85,3.699,136.308),(497,27,14,30,'2017-06-10',74841,29.97,2.999,89.88),(498,14,15,3,'2017-06-10',93479,44.152,3.99,176.166),(499,4,12,30,'2017-06-13',90328,24.89,3.599,89.5791),(500,44,2,2,'2017-06-13',75598,45,2.899,130.455),(501,15,7,30,'2017-06-13',55343,33.16,3.599,119.343),(502,12,19,2,'2017-06-14',51725,34.23,3.74,128.02),(503,27,13,30,'2017-06-14',74282,36.38,2.99,108.776),(504,19,18,4,'2017-06-14',89119,29.2,3.699,108.011),(505,19,18,4,'2017-06-16',89499,30.98,3.699,114.595),(506,15,7,30,'2017-06-16',55644,34.45,3.599,123.986),(507,4,12,30,'2017-06-16',91721,36.52,3.599,131.435),(508,18,10,2,'2017-06-16',82409,43.84,3.74,163.962),(509,27,13,30,'2017-06-17',75401,21.22,2.999,63.6388),(510,8,9,5,'2017-06-19',63381,38.11,3.798,144.742),(511,7,17,2,'2017-06-19',45525,55.35,3.74,207.009),(512,25,22,3,'2017-06-19',52898,46.031,3.999,184.078),(513,17,11,4,'2017-06-19',44155,36.09,3.699,133.497),(514,14,15,3,'2017-06-19',94146,41.51,3.99,165.625),(515,15,7,30,'2017-06-20',55956,32.49,3.599,116.932),(516,44,3,2,'2017-06-20',75846,43.11,2.89,124.588),(517,4,12,30,'2017-06-20',91039,34.39,3.599,123.77),(518,12,19,2,'2017-06-20',51904,19.069,3.78,72.0808),(519,13,13,3,'2017-06-20',120868,51.51,3.99,205.525),(520,27,14,30,'2017-06-21',75639,26.849,2.999,80.5201),(521,4,12,30,'2017-06-22',91313,25.53,3.599,91.8825),(522,19,18,4,'2017-06-22',89805,40.14,3.699,148.478),(523,15,7,30,'2017-06-23',56341,40.44,3.599,145.544),(524,25,22,28,'2017-06-23',NULL,NULL,NULL,0),(525,27,14,30,'2017-06-24',76028,41.06,2.99,122.769),(526,14,15,3,'2017-06-26',94482,50.36,3.999,201.39),(527,7,16,2,'2017-06-26',46003,50.03,3.74,187.112),(528,44,6,2,'2017-06-26',76386,48.3,2.899,140.022),(529,19,18,4,'2017-06-26',90050,27.64,3.699,102.24),(530,4,12,30,'2017-06-27',91733,38.94,3.599,140.145),(531,18,10,2,'2017-06-27',42759,33.93,3.74,126.898),(532,15,7,30,'2017-06-27',56601,25.01,3.599,90.011),(533,12,19,2,'2017-06-27',52252,31.979,3.78,120.881),(534,44,6,2,'2017-06-28',76775,47.789,2.899,138.54),(535,17,11,4,'2017-06-28',44435,38.94,3.699,144.039),(536,8,9,5,'2017-06-28',63727,40.58,3.798,154.123),(537,25,8,3,'2017-06-28',53980,43.771,3.99,174.646),(538,27,14,30,'2017-06-28',76428,47.58,2.999,142.692),(539,19,18,4,'2017-06-29',90428,33.13,3.699,122.548),(540,15,7,30,'2017-06-29',56938,33.44,3.599,120.351),(541,29,25,4,'2017-06-29',58212,35.031,3.799,133.083),(542,44,3,2,'2017-06-30',77184,53.129,2.8999,154.069),(543,4,12,30,'2017-06-30',92084,34.77,3.599,125.137),(544,27,13,30,'2017-07-01',76684,25.989,2.99,77.7071),(545,15,7,30,'2017-07-03',57231,31.48,3.599,113.297),(546,19,18,4,'2017-07-03',90727,34.34,3.699,127.024),(547,44,6,2,'2017-07-04',77334,19.66,2.899,56.9943),(548,25,2,3,'2017-07-05',55284,48.98,4.049,198.32),(549,27,13,30,'2017-07-04',77044,43.392,2.999,130.133),(550,12,19,2,'2017-07-04',52535,27.03,3.74,101.092),(551,25,2,3,'2017-07-04',54692,50.52,3.99,201.575),(552,19,18,4,'2017-07-05',91119,43.539,3.699,161.051),(553,7,17,2,'2017-07-05',46436,47.93,3.74,179.258),(554,13,12,2,'2017-07-05',121345,48.02,3.74,179.595),(555,14,15,3,'2017-07-06',94883,46.99,3.999,187.913),(556,19,18,3,'2017-07-06',91378,27.89,3.999,111.532),(557,8,9,5,'2017-07-06',64065,39.48,3.74,147.655),(558,15,7,30,'2017-07-06',57655,40.23,3.59,144.426),(559,4,12,30,'2017-07-07',92470,38.64,3.599,139.065),(560,18,3,2,'2017-07-07',NULL,39.741,3.74,148.631),(561,27,14,30,'2017-07-07',77463,44.82,2.99,134.012),(562,25,31,3,'2017-07-07',55360,5.78,3.99,23.0622),(563,44,2,2,'2017-07-10',78083,51.72,2.8999,149.983),(564,19,18,3,'2017-07-07',91578,23.133,3.99,92.3007),(565,17,11,3,'2017-07-08',44794,37.41,3.99,149.266),(566,13,8,2,'2017-07-08',121487,16.411,3.78,62.0336),(567,19,18,3,'2017-07-10',91749,19.31,3.99,77.0469),(568,27,13,30,'2017-07-11',77866,52.24,2.99,156.198),(569,15,7,30,'2017-07-11',58003,34.31,3.599,123.482),(570,4,12,30,'2017-07-11',92797,31.33,3.599,112.757),(571,12,19,2,'2017-07-11',52907,33.161,3.74,124.022),(572,18,10,2,'2017-07-11',NULL,31.94,3.74,119.456),(573,29,31,3,'2017-07-12',58887,22.131,3.999,88.5019),(574,48,31,2,'2017-07-13',NULL,NULL,NULL,0),(575,14,15,3,'2017-07-14',95264,50.41,3.99,201.136),(576,46,13,30,'2017-07-14',NULL,2.001,3.599,7.2016),(577,4,12,30,'2017-07-14',93176,36.52,3.59,131.107),(578,15,7,30,'2017-07-14',58375,38.76,3.599,139.497),(579,8,9,5,'2017-07-14',64408,39.2,3.74,146.608),(580,27,13,30,'2017-07-15',78243,38.73,2.99,115.803),(581,7,17,2,'2017-07-15',46901,56.39,3.68,207.515),(582,25,22,3,'2017-07-15',NULL,NULL,NULL,0),(583,13,10,2,'2017-07-17',122213,49.049,3.68,180.5),(584,44,3,2,'2017-07-18',78744,38,2.79,106.02),(585,19,18,5,'2017-07-18',92496,40.57,3.74,151.732),(586,15,7,30,'2017-07-18',58623,26.912,3.599,96.8563),(587,17,20,5,'2017-07-18',NULL,NULL,NULL,0),(588,18,10,2,'2017-07-18',53193,28.47,3.68,104.77),(589,12,19,30,'2017-07-18',NULL,NULL,NULL,0),(590,4,12,30,'2017-07-19',93558,37.33,3.599,134.351),(591,51,1,2,'2017-07-19',NULL,NULL,NULL,0),(592,19,18,5,'2017-07-20',92772,28.33,3.74,105.954),(593,15,7,30,'2017-07-20',NULL,NULL,NULL,0),(594,27,14,30,'2017-07-20',78566,36.16,2.999,108.444),(595,13,8,2,'2017-07-21',NULL,NULL,NULL,0),(596,29,31,3,'2017-07-21',59183,31.6,3.84,121.344),(597,27,14,30,'2017-07-21',78758,23.71,2.99,70.8929),(598,4,12,30,'2017-07-21',93911,32.96,3.908,128.808),(599,18,10,2,'2017-07-24',88850,38.24,4.08,156.019),(600,44,2,2,'2017-07-24',79246,51.67,2.99,154.493),(601,27,13,30,'2017-07-24',79096,31.81,3.039,96.6706),(602,15,7,30,'2017-07-24',59240,39.79,3.908,155.499),(603,8,9,5,'2017-07-24',64720,35.26,4.098,144.495),(604,17,20,5,'2017-07-25',45299,28.42,4.098,116.465),(605,4,12,30,'2017-07-25',94216,28.68,3.908,112.081),(606,12,19,30,'2017-07-25',53572,34.101,3.908,133.267),(607,49,2,5,'2017-07-25',NULL,NULL,NULL,0),(608,7,16,2,'2017-07-27',47427,60.58,4.08,247.166),(609,25,1,2,'2017-07-27',NULL,NULL,NULL,0),(610,18,10,2,'2017-07-28',88882,36.84,4.08,150.307),(611,14,15,3,'2017-07-28',NULL,NULL,NULL,0),(612,19,18,5,'2017-07-28',93250,29.77,4.048,120.509),(613,8,9,5,'2017-07-28',12343,50.55,4.048,204.626),(614,12,19,30,'2017-07-31',53953,34.05,3.908,133.067),(615,50,1,3,'2017-07-31',61907,43.66,4.04,176.386),(616,27,14,30,'2017-07-31',79947,47.62,3.039,144.717),(617,4,12,30,'2017-08-01',94899,35.96,3.908,140.532),(618,15,7,30,'2017-08-01',59520,37.6,3.908,146.941),(619,44,2,2,'2017-08-01',79705,55.86,2.99,167.021),(621,29,31,3,'2017-08-01',NULL,NULL,NULL,0),(622,18,3,2,'2017-08-02',45260,30.55,3.93,120.062),(623,19,18,5,'2017-08-02',93515,32.85,4.048,132.977),(624,7,17,2,'2017-08-02',47769,38.27,3.93,150.401),(625,8,9,5,'2017-08-02',64896,25.12,4.048,101.686),(626,17,11,5,'2017-08-02',45660,37.8,4.048,153.014),(627,27,13,30,'2017-08-04',80257,34.14,3.039,103.751),(628,18,10,2,'2017-08-04',85562,24.58,3.93,96.5994),(629,19,18,5,'2017-08-04',93729,23.64,4.048,95.6947),(630,15,7,30,'2017-08-04',59691,15.91,3.908,62.1763),(631,46,13,30,'2017-08-04',NULL,NULL,NULL,0),(632,4,12,30,'2017-08-04',95229,35.98,3.78,136.004),(633,44,6,2,'2017-08-07',79961,32,95.68,3061.76),(634,27,13,30,'2017-08-07',80541,30.81,3.089,95.1721),(635,15,7,30,'2017-08-08',60041,35.7,3.78,134.946),(636,25,22,3,'2017-08-08',57885,38.72,4.049,156.777),(637,4,12,30,'2017-08-09',95640,32.86,3.78,124.211),(638,27,13,30,'2017-08-09',80736,24.96,3.089,77.1014),(639,12,19,2,'2017-08-09',54284,33.4,3.78,126.252),(640,14,15,3,'2017-08-09',95989,45.7,4.049,185.039),(641,19,18,5,'2017-08-10',93969,26.3,4.048,106.462),(642,7,16,2,'2017-08-11',48270,52.9,3.93,207.897),(643,4,12,30,'2017-08-11',NULL,NULL,NULL,0),(644,19,18,5,'2017-08-11',94119,15.32,4.048,62.0154),(645,27,13,30,'2017-08-12',81210,43.48,3.22,140.006),(646,27,14,30,'2017-08-14',81602,45.041,3.22,145.032),(647,17,20,5,'2017-08-14',NULL,NULL,NULL,0),(648,19,18,5,'2017-08-14',94382,35.46,4.048,143.542),(649,15,7,30,'2017-08-14',60394,32.13,3.78,121.451),(650,8,9,5,'2017-08-14',65259,41.05,4.048,166.17),(651,44,2,2,'2017-08-15',80787,44.49,2.99,133.025),(652,12,19,30,'2017-08-15',54625,31.52,3.78,119.146),(653,25,31,3,'2017-08-15',NULL,29.881,4.049,120.988),(654,19,18,5,'2017-08-16',94615,23.46,4.048,94.9661),(655,15,7,30,'2017-08-16',61000,41.17,3.78,155.623),(656,4,12,30,'2017-08-17',96379,30.021,3.78,113.479),(657,7,16,2,'2017-08-17',48764,50.031,3.93,196.622),(658,19,18,5,'2017-08-17',94869,24.89,4.048,100.755),(659,27,13,30,'2017-08-17',84936,38.05,3.22,122.521),(660,25,22,3,'2017-08-21',NULL,NULL,NULL,0),(661,27,13,30,'2017-08-22',82675,52.392,3.22,168.702),(662,19,18,5,'2017-08-22',95293,25.38,4.048,102.738),(663,8,9,5,'2017-08-22',65643,38.61,4.048,156.293),(664,12,19,2,'2017-08-22',54982,34.012,3.78,128.565),(665,46,14,30,'2017-08-23',NULL,NULL,NULL,0),(666,19,18,5,'2017-08-23',95644,35.92,4.048,145.404),(668,44,2,2,'2017-08-24',81843,44.15,2.99,132.008),(669,15,7,4,'2017-08-24',61299,31.81,4.048,128.767),(670,18,10,2,'2017-08-24',86313,30.34,3.93,119.236),(671,4,12,30,'2017-08-25',97792,35.69,3.78,134.908),(672,19,18,5,'2017-08-25',95827,25.91,4.048,104.884),(674,27,13,30,'2017-08-25',83027,37.072,3.22,119.372),(675,18,10,2,'2017-08-28',86692,32.36,3.93,127.175),(676,17,11,5,'2017-08-28',46362,39.48,4.048,159.815),(677,25,2,3,'2017-08-28',59740,42.58,4.049,172.406),(678,27,13,30,'2017-08-28',NULL,NULL,NULL,0),(679,15,7,30,'2017-08-28',61489,17.43,3.78,65.8854),(680,44,3,2,'2017-08-28',82264,48,2.99,143.52),(681,19,18,5,'2017-08-28',96027,22.4,4.048,90.6752),(682,29,31,3,'2017-08-28',NULL,NULL,NULL,0),(683,7,16,30,'2017-08-29',49251,56.44,3.78,213.343),(684,15,7,4,'2017-08-29',61682,19.74,3.92,77.3808),(685,27,13,30,'2017-08-29',83590,38.64,3.22,124.421),(687,19,18,5,'2017-08-29',96218,19.67,4.048,79.6242),(688,25,2,3,'2017-08-29',60359,51.89,4.049,210.103),(689,4,12,30,'2017-08-30',97570,34.43,3.78,130.145),(690,46,3,2,'2017-08-30',NULL,NULL,3.93,0),(691,12,19,2,'2017-08-30',55308,35.929,3.93,141.201),(692,19,18,5,'2017-08-30',96530,40.8,4.048,165.158),(693,8,9,5,'2017-08-30',65984,37.2,4.048,150.586),(694,29,25,3,'2017-08-30',60314,40.012,4.04,161.648),(695,44,2,2,'2017-08-31',85608,46.83,2.99,140.022),(696,18,10,2,'2017-08-31',47216,38.46,2.99,114.995),(698,27,13,30,'2017-08-31',85620,26.14,3.22,84.1708),(699,15,7,4,'2017-08-31',61930,24.81,3.92,97.2552),(700,14,15,3,'2017-09-01',96802,52.19,4.049,211.317),(701,46,3,2,'2017-09-04',NULL,3.981,3.89,15.4861),(702,27,17,30,'2017-09-04',NULL,NULL,NULL,0),(703,15,7,4,'2017-09-04',62115,21.12,3.92,82.7904),(704,4,12,30,'2017-09-04',98018,39.91,3.78,150.86),(705,18,10,2,'2017-09-04',87595,39.56,3.89,153.888),(706,6,1,30,'2017-09-05',NULL,NULL,NULL,0),(707,13,31,3,'2017-09-05',124207,52.603,4.049,212.99),(708,19,18,5,'2017-09-06',96783,28.54,4.048,115.53),(709,8,9,5,'2017-09-06',66318,36.27,4.041,146.567),(710,44,6,2,'2017-09-06',83128,49.7,3.07,152.579),(711,27,13,30,'2017-09-08',NULL,NULL,NULL,0),(712,4,12,30,'2017-09-08',98344,32.402,3.81,123.452),(713,19,18,5,'2017-09-08',97100,33.27,4.041,134.444),(714,44,2,2,'2017-09-11',83469,NULL,NULL,0),(715,19,18,5,'2017-09-11',97288,22.71,4.041,91.7711),(716,18,10,2,'2017-09-11',88081,37.78,3.96,149.609),(717,12,19,2,'2017-09-11',55665,35.32,3.96,139.867),(718,17,11,5,'2017-09-11',46717,39.03,4.041,157.72),(719,27,13,30,'2017-09-11',84554,43.49,3.33,144.822),(720,29,25,3,'2017-09-11',60796,40.1,4.049,162.365),(721,25,8,3,'2017-09-12',60920,48.42,4.049,196.053),(722,4,12,30,'2017-09-13',98709,34.43,3.88,133.588),(723,15,7,30,'2017-09-13',62369,30.19,3.88,117.137),(724,44,2,2,'2017-09-13',83840,40.651,3.135,127.441),(725,27,17,30,'2017-09-13',84805,36.01,3.3,118.833),(726,18,10,2,'2017-09-15',88622,32.61,3.96,129.136),(727,27,17,30,'2017-09-15',85209,36.51,3.3,120.483),(728,6,27,2,'2017-09-16',NULL,40.11,4,160.44),(729,4,12,30,'2017-09-18',99094,35.52,3.88,137.818),(730,8,9,5,'2017-09-18',66631,36.54,4.041,147.658),(731,13,3,4,'2017-09-18',NULL,NULL,NULL,0),(732,44,2,2,'2017-09-18',84215,46.27,NULL,0),(733,15,7,30,'2017-09-18',62595,25.47,3.88,98.8236),(734,27,17,30,'2017-09-19',85456,31.31,3.3,103.323),(735,25,2,3,'2017-09-19',61728,40.98,4.079,167.157),(736,14,15,3,'2017-09-19',97235,53.263,4.079,217.26),(737,44,6,2,'2017-09-20',84620,50.019,3.13,156.559),(738,27,13,30,'2017-09-21',85294,35.031,3.3,115.602),(739,18,10,2,'2017-09-21',48853,37.83,3.96,149.807),(740,19,18,5,'2017-09-21',97628,41.42,3.99,165.266),(741,4,12,30,'2017-09-21',99521,39.77,3.88,154.308),(742,52,18,4,'2017-09-21',64534,53.94,3.98,214.681),(743,17,11,5,'2017-09-22',47011,36.64,3.99,146.194),(744,12,19,2,'2017-09-22',56000,35.002,3.968,138.888),(746,6,8,3,'2017-09-22',NULL,30.01,3.36,100.834),(747,27,13,30,'2017-09-23',86096,34.64,3.3,114.312),(748,13,2,4,'2017-11-17',125956,47.341,4.099,194.051),(749,44,6,2,'2017-09-25',85038,49.64,3.13,155.373),(750,18,10,2,'2017-09-25',49211,31.11,3.96,123.196),(751,53,32,4,'2017-09-25',29429,45.64,3.98,181.647),(752,7,16,30,'2017-09-25',49751,57.31,3.88,222.363),(753,4,12,30,'2017-09-26',99913,37.42,3.88,145.19),(754,25,8,3,'2017-09-26',62147,42.7,4.099,175.027),(755,25,31,3,'2017-09-27',NULL,22.56,4.07,91.8192),(756,27,14,30,'2017-09-27',NULL,NULL,NULL,0),(757,12,19,2,'2017-09-28',56244,24.09,3.96,95.3964),(758,4,12,30,'2017-09-28',100169,25.77,3.88,99.9876),(759,18,10,2,'2017-09-28',49660,38.24,3.96,151.43),(760,8,9,5,'2017-09-28',68987,38.2,3.99,152.418),(761,44,2,2,'2017-09-28',85456,18.99,3.13,59.4387),(762,14,21,3,'2017-09-30',97710,54.67,4.07,222.507),(763,4,12,30,'2017-10-02',NULL,NULL,NULL,0),(764,44,6,2,'2017-10-02',85562,39.39,3.13,123.291),(765,27,14,30,'2017-10-03',NULL,NULL,NULL,0),(766,15,7,30,'2017-10-03',62838,26.35,3.88,102.238),(767,25,31,2,'2017-10-03',62972,49.031,4.07,199.556),(768,17,11,5,'2017-10-03',47374,37.36,3.99,149.066),(769,4,3,30,'2017-10-04',100792,35.33,3.88,137.08),(770,52,18,5,'2017-10-24',66035,26.93,3.94,106.104),(771,44,2,2,'2017-10-05',85948,45.33,3.132,141.974),(772,50,13,30,'2017-10-05',62652,34.63,3.88,134.364),(773,15,7,30,'2017-10-27',NULL,NULL,NULL,0),(774,18,10,2,'2017-10-06',50038,32.39,3.89,125.997),(775,17,11,5,'2017-10-06',47715,35.86,3.99,143.081),(776,4,3,30,'2017-10-06',101073,25.96,3.81,98.9076),(777,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(778,12,19,2,'2017-10-06',56618,33.719,3.89,131.167),(779,50,13,30,'2017-10-09',62987,32.29,3.81,123.025),(780,7,16,30,'2017-10-09',50208,52.011,3.811,198.214),(781,19,18,5,'2017-11-13',NULL,NULL,NULL,0),(782,8,9,5,'2017-10-09',67347,40.54,3.94,159.728),(783,15,7,30,'2017-10-27',63680,35.79,3.81,136.36),(784,18,10,2,'2017-10-16',50831,35.79,3.89,139.223),(785,50,13,30,'2017-10-11',NULL,NULL,NULL,0),(786,17,11,5,'2017-10-11',48062,38.11,3.94,150.153),(787,44,6,2,'2017-10-16',87001,29.081,3.135,91.1689),(788,44,6,2,'2017-10-13',86703,47.659,3.135,149.411),(789,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(790,17,11,5,'2017-10-14',48391,35.41,3.94,139.515),(791,50,14,30,'2017-10-14',NULL,NULL,NULL,0),(792,14,21,3,'2017-10-16',98138,54.403,4.079,221.91),(793,7,17,30,'2017-10-16',50796,57.45,3.81,218.885),(794,29,24,3,'2017-10-16',38173,38.173,4.079,155.708),(795,12,19,2,'2017-10-17',56953,33.48,3.89,130.237),(796,52,18,5,'2017-10-17',65535,47.24,3.94,186.126),(797,17,11,5,'2017-10-18',48727,67.62,3.298,223.011),(798,50,14,30,'2017-10-18',63812,35.16,3.81,133.96),(799,25,31,3,'2017-10-18',NULL,NULL,NULL,0),(800,8,9,5,'2017-10-18',67676,37.16,3.94,146.41),(801,18,10,2,'2017-10-19',51193,31.25,3.89,121.562),(802,8,24,5,'2017-10-19',NULL,NULL,NULL,0),(803,44,3,2,'2017-10-26',NULL,NULL,NULL,0),(804,50,14,30,'2017-10-27',65930,34.02,3.81,129.616),(805,17,20,5,'2017-10-23',49077,38.42,3.94,151.375),(806,50,14,30,'2017-10-25',65561,35.09,3.81,133.693),(807,18,10,2,'2017-10-23',51559,30.26,3.89,117.711),(808,25,8,2,'2017-10-23',64267,44.1,3.89,171.549),(809,12,19,2,'2017-10-24',57315,33.021,3.89,128.452),(810,17,20,5,'2017-10-25',49410,34.38,3.94,135.457),(811,7,17,30,'2017-10-25',51292,55.649,3.81,212.023),(812,18,10,2,'2017-10-26',52057,40.829,3.89,158.825),(813,52,18,5,'2017-10-26',66293,29.38,3.94,115.757),(814,14,15,3,'2017-10-26',98608,57.131,4.079,233.037),(815,52,18,5,'2017-10-27',66691,3806,3.94,14995.6),(816,8,9,5,'2017-10-27',68030,39.25,3.94,154.645),(817,17,11,5,'2017-11-06',50350,31.57,4.04,127.543),(818,18,10,2,'2017-11-06',53170,29.97,3.91,117.183),(819,44,6,2,'2017-10-30',88247,54.721,3.135,171.55),(820,50,14,30,'2017-10-30',66381,41.36,3.87,160.063),(821,12,19,2,'2017-10-31',57709,34.32,3.89,133.505),(822,50,14,30,'2017-11-01',66842,41.19,3.81,156.934),(823,29,25,3,'2017-11-03',61527,39.022,3.999,156.049),(824,6,16,2,'2017-11-03',NULL,25.002,3.13,78.2563),(825,14,15,3,'2017-11-11',NULL,NULL,NULL,0),(826,6,2,2,NULL,NULL,NULL,NULL,0),(827,50,14,30,'2017-11-06',NULL,NULL,NULL,0),(828,15,7,4,'2017-11-13',63936,26.96,3.83,103.257),(829,50,3,3,'2017-11-06',67314,40.87,3.83,156.532),(830,52,18,5,'2017-11-06',66883,26.94,4.04,108.838),(831,8,9,5,'2017-11-06',68335,35.52,4.041,143.536),(832,44,2,2,'2017-11-07',88657,50.569,3.135,158.534),(833,50,14,30,'2017-11-08',67674,32.77,3.83,125.509),(834,17,11,5,'2017-11-08',50727,38.88,4.112,159.875),(835,25,1,5,'2017-11-08',64854,50.65,4.112,208.273),(836,46,3,2,'2017-11-09',NULL,1.972,4.008,7.90378),(837,18,10,2,'2017-11-09',53628,39.59,4.066,160.973),(838,7,16,30,'2017-11-09',51779,54.48,3.91,213.017),(839,54,1,2,'2017-11-09',NULL,NULL,NULL,0),(840,50,14,30,'2017-11-10',68065,31.381,3.916,122.888),(841,17,11,5,'2017-11-20',51636,30.73,4.112,126.362),(842,50,14,30,'2017-11-13',68540,39.621,3.916,155.156),(843,12,9,2,'2017-11-14',58070,39.01,4.008,156.352),(845,44,6,2,'2017-11-14',89154,58.509,3.23,188.984),(846,18,10,2,'2017-11-16',54094,41.11,4.008,164.769),(847,19,18,5,'2017-11-20',98807,42.92,4.112,176.487),(848,44,14,2,'2017-11-17',89478,36.681,3.233,118.59),(849,44,13,2,'2017-11-18',NULL,NULL,NULL,0),(850,50,13,30,'2017-11-24',NULL,NULL,NULL,0),(851,18,10,2,'2017-11-20',54492,32.74,4.008,131.222),(852,44,6,2,'2017-11-20',NULL,NULL,NULL,0),(853,17,11,5,'2017-11-16',51350,30.73,4.112,126.362),(854,15,7,2,'2017-11-20',64616,38.942,4.008,156.08),(855,14,15,3,'2017-11-21',NULL,NULL,NULL,0),(856,18,10,2,'2017-11-22',58857,30.58,4.008,122.565),(857,19,18,5,'2017-11-24',99110,18.82,4.112,77.3878),(858,50,7,30,'2017-11-22',69423,40.12,3.935,157.872),(859,12,9,2,'2017-11-22',58419,37.181,4.008,149.021),(860,17,11,5,'2017-11-23',53033,36.07,4.113,148.356),(861,44,6,2,'2017-11-23',NULL,NULL,NULL,0),(862,34,13,30,'2017-11-23',NULL,NULL,NULL,0),(863,7,16,30,'2017-11-23',52246,55.98,3.93,220.001),(864,44,6,2,'2017-11-28',NULL,NULL,NULL,0),(865,15,7,30,'2017-11-28',64888,28.329,4.099,116.121),(866,50,14,30,'2017-11-28',NULL,NULL,NULL,0),(867,18,10,2,'2017-11-29',55286,39.081,4.008,156.637),(868,19,18,5,'2017-11-29',99329,22.44,4.21,94.4724),(869,17,11,5,'2017-11-29',52332,34.52,4.21,145.329),(870,12,19,2,'2017-11-29',58753,29.851,4.066,121.374),(871,15,7,30,'2017-11-30',65201,31.73,4.099,130.061),(872,50,14,30,'2017-11-30',NULL,NULL,NULL,0),(873,14,15,5,'2017-12-01',NULL,NULL,NULL,0),(874,8,9,5,'2017-12-01',68675,35.341,4.113,145.358),(875,44,6,2,'2017-12-01',91214,46.031,3.233,148.818),(877,29,18,5,'2017-12-01',61744,37.8,4.11,155.358),(878,17,11,5,'2017-12-01',52697,34.32,4.11,141.055),(879,19,18,5,'2017-12-02',99622,27.67,4.11,113.724),(880,18,10,2,'2017-12-04',53706,34,4.008,136.272),(881,50,14,30,'2017-12-04',NULL,NULL,NULL,0),(882,46,3,2,'2017-12-04',NULL,NULL,NULL,0),(883,7,11,30,'2017-12-04',52521,41.93,4.099,171.871),(884,29,31,3,'2017-12-04',NULL,22.87,4.199,96.0311),(885,19,18,5,'2017-12-05',99754,18.34,4.11,75.3774),(887,44,2,2,'2017-12-06',NULL,NULL,NULL,0),(888,25,33,3,'2017-12-06',66154,27.531,4.199,115.603),(889,15,7,30,'2017-12-06',65507,32.29,4.099,132.357),(890,50,14,30,'2017-12-06',NULL,NULL,NULL,0),(891,19,18,5,'2017-12-07',100022,26.03,4.113,107.061),(892,17,20,5,'2017-12-07',NULL,NULL,NULL,0),(893,46,NULL,2,NULL,NULL,NULL,NULL,0),(894,46,3,2,'2017-12-07',NULL,NULL,NULL,0),(895,12,19,2,'2017-12-07',59140,34.1,3.9888,136.018),(896,18,10,2,'2017-12-08',56120,36,3.988,143.568),(897,15,7,30,'2017-12-08',65722,21.291,4.099,87.2718),(898,29,25,3,'2017-12-08',NULL,NULL,NULL,0),(899,50,14,30,'2017-12-08',NULL,NULL,NULL,0),(900,25,8,3,'2017-12-08',66690,51.691,4.199,217.051),(901,8,9,5,'2017-12-09',69067,39.53,4.113,162.587),(902,44,2,2,'2017-12-19',92547,56.99,3.233,184.249),(903,17,11,5,'2017-12-11',53362,31.86,4.113,131.04),(904,7,16,30,'2017-12-12',53088,52.64,4.069,214.192),(905,50,17,30,'2017-12-12',NULL,NULL,NULL,0),(906,19,18,4,'2017-12-19',100751,29.28,3.97,116.242),(907,15,7,30,'2017-12-12',66009,24.741,4.069,100.671),(908,25,31,3,'2017-12-13',57032,30.011,4.199,126.016),(909,17,11,5,'2017-12-14',53682,31.57,4.113,129.847),(910,19,18,4,'2017-12-14',100500,16.341,3.979,65.0208),(911,50,3,30,'2017-12-15',NULL,NULL,NULL,0),(912,14,21,3,'2017-12-16',100378,52.861,4.199,221.963),(913,17,20,5,'2017-12-16',54006,31.39,4.113,129.107),(914,18,10,2,'2017-12-18',56582,40.4,3.988,161.115),(915,50,3,30,'2017-12-18',NULL,NULL,NULL,0),(916,17,11,5,'2017-12-18',NULL,NULL,NULL,0),(917,12,19,2,'2017-12-18',57518,36,3.988,143.568),(918,7,17,30,'2017-12-18',53370,30.88,4.069,125.651),(919,15,7,30,'2017-12-19',66284,31.46,4.069,128.011),(920,8,9,2,'2017-12-19',69430,39.381,3.988,157.051),(921,17,20,5,'2017-12-20',54316,30.71,4.11,126.218),(922,50,3,30,'2017-12-20',NULL,NULL,NULL,0),(923,15,7,30,'2017-12-21',66538,26.029,4.069,105.912),(924,50,3,30,'2017-12-22',NULL,NULL,NULL,0),(925,17,20,5,'2017-12-22',54656,31.1,4.052,126.017),(926,44,2,2,'2017-12-22',NULL,NULL,NULL,0),(927,29,24,3,'2017-12-22',NULL,NULL,NULL,0),(928,50,17,30,'2017-12-23',73456,39.33,4.069,160.034),(929,18,10,2,'2017-12-26',36942,32.692,3.988,130.376),(930,15,7,30,'2017-12-26',66840,31.91,4.069,129.842),(931,34,8,3,'2017-12-26',82685,45.941,4.199,192.906),(932,44,17,2,'2017-12-27',93400,53.35,3.233,172.481),(933,17,20,5,'2017-12-28',35067,35.56,4.052,144.089),(934,12,19,2,'2017-12-28',59857,34.08,3.988,135.911),(935,8,9,2,'2017-12-29',69795,39.081,3.988,155.855),(936,18,10,2,'2017-12-29',57357,34.82,3.988,138.862),(937,14,15,5,'2017-12-29',NULL,NULL,NULL,0),(938,8,9,2,'2018-02-07',71229,40.92,4.02,164.498),(939,15,21,2,'2017-12-31',67138,31.94,3.98,127.121),(940,19,16,2,'2018-01-01',101328,33.34,3.988,132.96),(941,44,17,2,'2018-01-02',NULL,NULL,NULL,0),(942,17,20,5,'2018-01-02',55435,33.61,4.052,136.188),(943,25,8,3,'2018-01-02',68483,48.822,4.199,205.004),(944,18,10,2,'2018-01-03',57675,28.02,3.988,111.744),(945,15,16,30,'2018-01-03',67342,22.42,4.069,91.227),(946,7,16,30,'2018-01-04',53883,52.85,4.069,215.047),(947,19,18,4,'2018-01-05',101602,28.93,4.029,116.559),(948,17,20,5,'2018-01-05',55776,30.84,4.052,124.964),(949,50,17,30,'2018-01-05',NULL,NULL,NULL,0),(950,29,34,3,'2018-01-08',63419,41.93,4.199,176.064),(951,18,10,2,'2018-01-08',58180,40.55,3.988,161.713),(952,19,18,4,'2018-01-08',101953,28.019,4.029,112.889),(953,19,18,4,'2018-01-09',102066,19.851,4.029,79.9797),(954,12,19,2,'2018-01-09',60154,32.7,3.988,130.408),(955,50,17,30,'2018-01-09',74194,31.17,3.907,121.781),(956,8,20,5,'2018-01-10',70774,41.12,4.052,166.618),(957,17,11,5,'2018-01-11',56201,37.29,4.052,151.099),(958,15,18,30,'2018-01-11',67704,36.96,3.907,144.403),(959,44,17,2,'2018-01-11',94284,56.069,3.233,181.271),(960,13,12,3,'2018-01-11',128518,49.542,4.199,208.027),(961,14,21,3,'2018-01-12',101187,51.443,4.199,216.009),(962,50,17,30,'2018-01-12',NULL,NULL,NULL,0),(963,18,10,2,'2018-01-15',58560,35.13,4.017,141.117),(964,7,11,30,'2018-01-15',NULL,NULL,NULL,0),(965,15,18,5,'2018-01-15',102339,28.33,4.052,114.793),(966,44,6,2,'2018-01-15',94578,36.55,3.233,118.166),(967,25,12,3,'2018-01-15',69021,48.6,4.199,204.071),(968,15,18,30,'2018-01-16',102513,16.48,3.93,64.7664),(969,50,17,30,'2018-01-16',74968,36.07,3.935,141.935),(970,17,11,5,'2018-01-17',56604,36.84,4.052,149.276),(971,12,19,2,'2018-01-17',60519,36.27,4.017,145.697),(972,44,2,2,'2018-01-18',94961,45.95,3.233,148.556),(973,8,20,5,'2018-01-18',70509,40.56,4.052,164.349),(974,53,36,30,'2018-01-18',32454,31.72,4.099,130.02),(975,50,17,30,'2018-01-18',75300,30.349,3.935,119.423),(976,56,NULL,NULL,NULL,NULL,NULL,NULL,0),(977,56,35,2,'2018-01-19',129792,53.43,4.027,215.163),(978,18,10,2,'2018-01-19',59020,36.511,4.027,147.03),(979,17,11,5,'2018-01-20',57002,37.11,4.052,150.37),(980,15,7,30,'2018-01-22',67940,29,3.955,114.695),(981,19,18,30,'2018-01-22',102818,31.35,3.955,123.989),(982,7,16,5,'2018-01-22',NULL,NULL,NULL,0),(983,50,2,30,'2018-01-22',NULL,NULL,NULL,0),(984,13,37,3,'2018-01-23',129039,50.042,4.199,210.126),(985,12,19,2,'2018-01-23',60877,33.74,4.027,135.871),(986,17,11,5,'2018-01-17',NULL,NULL,NULL,0),(987,17,11,5,'2018-01-24',57368,33.84,4.052,137.12),(988,25,8,3,'2018-01-24',70432,45.38,4.19,190.142),(989,50,17,30,'2018-01-25',NULL,NULL,NULL,0),(990,44,2,2,'2018-01-25',95562,46.99,3.233,151.919),(991,53,31,5,'2018-01-25',32661,25.32,4.052,102.597),(992,8,20,5,'2018-01-26',70841,39.37,4.052,159.527),(993,19,18,30,'2018-01-26',103107,28.16,3.9555,111.387),(994,18,10,2,'2018-01-26',59433,37.379,4.027,150.525),(995,14,21,3,'2018-01-26',101591,54.57,4.199,229.139),(996,50,3,30,'2018-01-26',76214,28.359,4.119,116.811),(997,15,7,30,'2018-01-26',68145,23.59,3.955,93.2984),(998,7,16,5,'2018-01-26',NULL,NULL,NULL,0),(999,44,6,2,'2018-01-27',NULL,NULL,NULL,0),(1000,50,3,30,'2018-01-29',76558,30.6,3.955,121.023),(1001,25,31,2,'2018-01-29',NULL,30.39,4.02,122.168),(1002,13,37,3,'2018-01-30',129525,49.06,4.199,206.003),(1003,17,11,5,'2018-01-30',57756,36.35,4.052,147.29),(1004,44,2,2,'2018-01-30',96310,43.65,3.233,141.12),(1005,19,18,30,'2018-01-30',103490,34.021,3.955,134.553),(1006,18,10,2,'2018-01-30',59770,27.71,4.027,111.588),(1007,50,3,30,'2018-01-30',76995,35.431,3.955,140.13),(1008,15,7,30,'2018-01-31',68433,32.581,3.955,128.858),(1009,12,19,2,'2018-01-31',61177,32.42,4.027,130.555),(1010,29,8,3,'2018-01-31',NULL,NULL,NULL,0),(1011,7,16,5,'2018-02-01',55764,43.87,4.052,177.761),(1012,44,17,5,'2018-02-01',96727,40.922,3.233,132.301),(1013,19,18,30,'2018-02-01',103820,33.14,3.9555,131.085),(1014,17,11,5,'2018-02-01',58129,35.4,4.052,143.441),(1015,53,20,2,'2018-02-01',33134,45.761,4.027,184.28),(1016,25,8,3,'2018-02-01',71352,50.91,4.19,213.313),(1017,15,7,30,'2018-02-02',68626,18.21,3.955,72.0206),(1018,18,10,2,'2018-02-02',60136,30.589,4.027,123.182),(1019,29,34,5,'2018-02-05',64029,41.98,4.052,170.103),(1020,44,6,2,'2018-02-06',NULL,NULL,NULL,0),(1021,44,6,2,'2018-02-06',NULL,NULL,NULL,0),(1022,44,6,2,'2018-02-06',NULL,NULL,NULL,0),(1023,17,11,2,'2018-02-06',58450,32.62,4.052,132.176),(1024,7,16,5,'2018-02-06',56169,34.32,4.052,139.065),(1025,15,7,30,'2018-02-06',68963,37.47,3.955,148.194),(1026,13,37,3,'2018-02-08',129983,49.842,4.199,209.287),(1027,44,2,2,'2018-02-08',NULL,NULL,NULL,0),(1028,15,7,30,'2018-02-08',69196,27.56,3.955,109),(1029,44,17,2,'2018-02-08',97480,50.022,3.233,161.721),(1030,29,31,3,'2018-02-08',NULL,NULL,NULL,0),(1031,14,15,3,'2018-02-09',101955,48.79,4.199,204.869),(1032,19,18,30,'2018-02-09',104214,46.57,3.955,184.184),(1033,7,16,5,'2018-02-09',56668,43.55,4.052,176.465),(1034,17,11,2,'2018-02-09',58823,36.8,4.052,149.114),(1035,50,17,30,'2018-02-10',NULL,NULL,NULL,0),(1036,53,20,2,'2018-02-10',33563,51.59,4.027,207.753),(1037,6,6,2,'2018-02-10',NULL,46.69,3.23,150.809),(1038,7,16,5,'2018-02-14',57227,52.81,4.052,213.986),(1039,12,19,2,'2018-02-14',61518,36.52,4.027,147.066),(1040,29,34,5,'2018-02-14',64429,40.24,4.32,173.837),(1041,51,17,30,'2018-02-15',77719,30.22,3.955,119.52),(1042,19,18,30,'2018-02-15',104399,20.45,3.955,80.8798),(1043,8,9,2,'2018-02-15',74638,38.93,4.027,156.771),(1044,17,11,5,'2018-02-16',59154,34.1,4.052,138.173),(1045,19,18,30,'2018-02-16',104742,35.82,3.955,141.668),(1046,7,16,5,'2018-02-16',57598,31.75,4.052,128.651),(1047,44,2,2,'2018-02-16',97796,38.8,3.233,125.44),(1048,13,NULL,NULL,'2018-02-17',NULL,NULL,NULL,0),(1049,50,3,30,'2018-02-19',78048,29.11,3.955,115.13),(1050,18,20,2,'2018-02-19',60805,37.78,4.027,152.14),(1052,17,11,5,'2018-02-20',59455,31.19,4.052,126.382),(1053,50,3,30,'2018-02-21',78408,30.48,3.955,120.548),(1054,12,19,2,'2018-02-21',61871,35.78,4.027,144.086),(1055,15,7,30,'2018-02-21',69521,34.999,3.955,138.421),(1056,14,15,3,'2018-02-22',102401,54.78,4.199,230.021),(1057,44,36,2,'2018-02-22',NULL,48,3.233,155.184),(1058,15,7,30,'2018-02-22',69854,30.41,3.955,120.272),(1059,25,8,3,'2018-02-22',71825,51.68,4.19,216.539),(1060,27,13,2,'2018-02-23',NULL,NULL,NULL,0),(1061,17,11,5,'2018-02-23',59811,32.84,4.052,133.068),(1062,13,37,30,'2018-02-23',130958,51.001,3.955,201.709),(1063,50,13,30,'2018-02-23',78863,39.401,3.955,155.831),(1064,18,20,2,'2018-02-24',67753,37.24,4.027,149.965),(1065,8,9,2,'2018-02-26',72012,41.2,4.027,165.912),(1066,19,18,30,'2018-02-26',105029,31.19,3.955,123.356),(1067,44,2,2,'2018-02-27',98915,41.531,3.233,134.27),(1068,15,7,30,'2018-02-28',70150,30.811,3.955,121.858),(1069,50,13,30,'2018-02-28',79280,35.871,3.955,141.87),(1070,17,11,5,'2018-02-28',60148,35.1,4.052,142.225),(1071,12,19,2,'2018-03-01',62199,34.24,4.027,137.884),(1072,18,20,2,'2018-03-01',61472,36.48,4.027,146.905),(1073,13,37,3,'2018-03-02',131326,36.272,4.199,152.306),(1074,50,13,30,'2018-03-02',NULL,NULL,NULL,0),(1075,44,3,2,'2018-03-02',99184,47.16,3.23,152.327),(1076,19,18,30,'2018-03-02',105346,33.38,3.955,132.018),(1078,14,21,3,'2018-03-03',102886,55.55,4.199,233.254),(1079,50,13,30,'2018-03-05',80028,32.74,3.955,129.487),(1080,17,11,5,'2018-03-05',60570,38.33,4.052,155.313),(1081,19,18,30,'2018-03-05',105553,23.56,3.955,93.1798),(1082,57,38,3,'2018-03-02',NULL,NULL,NULL,0),(1083,57,38,3,'2018-03-05',NULL,NULL,NULL,0),(1084,7,13,5,'2018-03-06',NULL,NULL,NULL,0),(1085,44,2,2,'2018-03-06',99317,41.01,3.23,132.462),(1086,15,7,30,'2018-03-06',70428,29.39,3.9555,116.252),(1087,8,9,2,NULL,NULL,NULL,NULL,0),(1089,8,9,2,'2018-03-07',72426,42.12,4.027,169.617),(1090,19,18,30,'2018-03-07',105906,34.96,3.955,138.267),(1091,25,12,2,'2018-03-07',72266,51.35,4.027,206.786),(1092,15,7,30,'2018-03-08',70625,21.222,3.9555,83.9436),(1093,13,37,3,'2018-03-08',131811,46.442,4.199,195.01),(1094,17,11,5,'2018-03-08',61022,36.6,4.052,148.303),(1096,18,10,2,'2018-03-09',61897,35.17,4.027,141.63),(1097,7,13,5,'2018-03-09',NULL,NULL,NULL,0),(1098,12,19,2,'2018-03-09',62548,4.027,35.922,144.658),(1099,44,3,2,'2018-03-09',NULL,NULL,NULL,0),(1100,6,8,2,'2018-03-09',NULL,NULL,NULL,0),(1101,14,15,3,'2018-03-10',103304,46.213,4.199,194.048),(1102,15,7,30,'2018-03-12',70922,30.51,3.9555,120.682),(1103,7,13,5,'2018-03-12',NULL,NULL,NULL,0),(1104,19,18,30,'2018-03-13',106197,31.129,3.9555,123.131),(1105,50,15,3,'2018-03-13',NULL,NULL,NULL,0),(1106,44,6,2,'2018-03-14',100336,56.99,3.23,184.078),(1107,18,10,2,'2018-03-14',62380,37.4,4.027,150.61),(1108,13,37,3,'2018-03-14',132242,46.681,4.199,196.014),(1109,25,31,3,'2018-03-14',72728,37.161,4.199,156.039),(1110,7,13,5,'2018-03-15',NULL,NULL,NULL,0),(1111,50,15,3,'2018-03-16',80784,36.132,4.199,151.718),(1113,15,7,30,'2018-03-16',71246,30.62,3.955,121.102),(1114,8,9,2,'2018-03-16',72800,39.92,4.027,160.758),(1115,12,19,2,'2018-03-16',62895,35.53,4.027,143.079),(1116,29,16,3,'2018-03-17',64928,36.132,4.199,151.718),(1117,50,15,3,'2018-03-19',80966,20.602,4.199,86.5078),(1118,19,18,30,'2018-03-19',106462,31.161,3.955,123.242),(1119,44,6,2,'2018-03-19',100671,42.68,3.23,137.856),(1120,7,13,5,'2018-03-19',NULL,NULL,NULL,0),(1121,13,37,3,'2018-03-20',132644,46.94,4.199,197.101),(1122,25,8,3,'2018-03-20',73936,23.91,4.19,100.183),(1123,15,7,30,'2018-03-20',71478,23.81,3.9555,94.1805),(1124,57,38,3,'2018-03-20',127666,41.43,4.249,176.036),(1125,14,21,3,'2018-03-21',103751,46.712,4.199,196.144),(1126,50,15,3,'2018-03-21',81214,25.101,4.199,105.399),(1127,44,3,2,'2018-03-21',NULL,NULL,NULL,0),(1128,18,10,2,'2018-03-22',62769,38.47,4.027,154.919),(1129,19,18,30,'2018-03-22',106777,37.67,3.955,148.985),(1130,7,13,5,'2018-03-22',NULL,NULL,NULL,0),(1131,50,15,3,'2018-03-23',81500,25.95,4.199,108.964),(1132,13,37,3,'2018-03-24',133041,42.87,4.199,180.011),(1133,44,13,2,'2018-03-24',101266,45.22,3.23,146.061),(1134,7,13,5,'2018-03-24',NULL,NULL,NULL,0),(1135,44,6,2,'2018-03-26',101558,32.74,3.23,105.75),(1136,50,15,3,'2018-03-26',81660,17.29,4.199,72.6007),(1137,17,17,5,'2018-03-26',61755,37.89,4.16,157.622),(1138,12,19,2,'2018-03-26',63222,35.101,4.027,141.352),(1139,18,10,2,'2018-03-26',63103,29.94,4.027,120.568),(1141,8,9,3,'2018-03-26',73160,38.7,4.19,162.153),(1142,15,7,30,'2018-03-27',71832,32.062,3.955,126.805),(1143,7,13,30,'2018-03-27',NULL,NULL,NULL,0),(1145,25,31,5,'2018-03-27',74990,36,4.163,149.868),(1146,50,15,3,'2018-03-28',81878,21.2,4.199,89.0188),(1147,19,18,30,'2018-03-28',107060,29.901,3.9555,118.273),(1148,14,21,3,'2018-03-28',104183,50.38,4.199,211.546),(1149,18,10,2,'2018-03-29',63588,37.05,4.066,150.645),(1150,17,11,5,'2018-03-29',61122,36.93,4.16,153.629),(1151,44,3,2,'2018-03-29',101038,52.1,3.28,170.888),(1152,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(1153,13,37,3,'2018-03-29',133488,49.31,4.199,207.053),(1154,44,36,2,'2018-03-31',102289,44.64,3.28,146.419),(1155,50,15,3,'2018-04-02',82122,NULL,NULL,0),(1156,44,16,5,'2018-04-02',102655,4420,3.28,14497.6),(1157,7,36,30,'2018-04-02',NULL,NULL,NULL,0),(1158,15,7,30,'2018-04-02',NULL,NULL,NULL,0),(1159,25,2,5,'2018-04-03',75339,36.27,4.214,152.842),(1160,57,38,3,'2018-04-03',12865,51.78,4.24,219.547),(1161,50,15,3,'2018-04-04',82369,24.95,NULL,0),(1162,13,37,3,'2018-04-04',133818,36.68,4.199,154.019),(1163,44,36,2,'2018-04-04',103018,44.99,3.28,147.567),(1164,19,18,30,'2018-04-04',107375,33.75,3.98,134.325),(1165,25,31,5,'2018-04-04',75996,12.79,4.21,53.8459),(1166,18,10,2,'2018-04-05',63965,35.799,4.066,145.559),(1167,12,19,2,'2018-04-05',63553,35.26,4.066,143.367),(1168,44,13,2,'2018-04-05',103215,25.59,3.28,83.9352),(1169,8,9,3,'2018-04-05',73549,39.2,4.14,162.288),(1170,17,11,5,'2018-04-06',62438,30.041,4.214,126.593),(1171,15,7,30,'2018-04-06',72215,25.91,3.98,103.122),(1172,29,25,3,'2018-04-06',65272,41.46,4.14,171.644),(1173,44,13,30,'2018-04-07',103577,53.81,3.39,182.416),(1174,50,15,3,'2018-04-09',82746,35.432,4.14,146.688),(1175,27,36,2,'2018-04-09',103927,45.99,3.28,150.847),(1176,25,2,5,'2018-04-09',76345,44.61,4.21,187.808),(1177,14,21,3,'2018-04-09',104666,53.51,4.14,221.531),(1178,13,37,3,'2018-04-10',134199,45.073,4.14,186.602),(1179,17,11,5,'2018-04-10',62775,32.03,4.21,134.846),(1180,18,10,2,'2018-04-10',68349,33,4.066,134.178),(1181,19,18,30,'2018-04-10',107567,23.74,3.98,94.4852),(1182,7,8,2,'2018-04-11',NULL,NULL,NULL,0),(1183,50,15,3,'2018-04-11',80941,20.15,4.14,83.421),(1184,15,7,30,'2018-04-11',72476,26.15,3.98,104.077),(1185,18,10,2,'2018-04-12',69890,45.151,4.066,183.584),(1186,44,36,2,'2018-04-13',104248,42.06,3.39,142.583),(1187,44,2,2,'2018-04-16',104509,34.63,3.28,113.586),(1188,7,37,2,'2018-04-16',72275,46.291,4.066,188.219),(1189,8,9,5,'2018-04-13',73890,36.68,4.14,151.855),(1190,50,15,3,'2018-04-13',83232,29.233,4.14,121.025),(1191,12,19,2,'2018-04-13',63890,34.71,4.066,141.131),(1192,13,37,3,'2018-04-13',134618,45.8,4.14,189.612),(1193,19,18,30,'2018-04-14',107862,31.59,3.98,125.728),(1194,18,10,2,'2018-04-16',64588,33.43,4.066,135.926),(1195,58,1,2,'2018-04-16',NULL,55.44,4.066,225.419),(1196,15,8,30,'2018-04-16',72904,42.42,3.98,168.832),(1197,25,31,2,'2018-04-16',NULL,15.19,4.06,61.6714),(1198,29,12,2,'2018-04-16',NULL,NULL,NULL,0),(1199,15,7,30,'2018-04-17',73168,23.47,2.98,69.9406),(1200,19,18,30,'2018-04-17',108161,32.3,3.98,128.554),(1201,50,15,3,'2018-04-18',83624,36.71,4.14,151.979),(1202,44,36,2,'2018-04-18',104750,29.48,3.28,96.6944),(1203,7,37,2,'2018-04-18',62620,33.75,4.066,137.227),(1204,14,21,3,'2018-04-18',105164,53.7,4.14,222.318),(1205,29,8,2,'2018-04-18',NULL,NULL,NULL,0),(1206,17,11,5,'2018-04-18',NULL,NULL,NULL,0),(1208,18,10,2,'2018-04-19',64951,32.07,4.06,130.204),(1209,15,7,30,'2018-04-19',73461,31.85,3.98,126.763),(1210,29,34,5,'2018-04-19',66117,42.92,4.214,180.865),(1211,25,2,5,'2018-04-19',77653,35.83,4.21,150.844),(1212,50,15,3,'2018-04-20',83939,30.081,4.089,123.001),(1213,44,13,2,'2018-04-20',105029,34.93,3.28,114.57),(1214,19,18,30,'2018-04-20',108396,24.91,3.98,99.1418),(1215,7,37,2,'2018-04-23',63073,47.4,4.066,192.728),(1216,25,2,5,'2018-04-23',77925,27,4.21,113.67),(1217,29,1,2,'2018-04-23',NULL,NULL,NULL,0),(1218,12,19,2,'2018-04-24',64248,35.48,4.06,144.049),(1219,15,7,30,'2018-04-24',73794,34.71,3.98,138.146),(1220,44,16,2,'2018-04-24',105457,53.41,3.28,175.185),(1221,29,25,3,'2018-04-24',66572,41.58,4.089,170.021),(1222,8,9,3,'2018-04-24',74239,36.69,4.08,149.695),(1223,50,15,3,'2018-04-25',84267,32.04,4.08,130.723),(1224,18,10,2,'2018-04-25',NULL,36.41,4.06,147.825),(1225,25,31,5,'2018-04-25',78740,41.98,3.74,157.005),(1226,19,18,30,'2018-04-25',NULL,NULL,NULL,0),(1227,33,13,3,'2018-04-25',69614,34.01,4.08,138.761),(1228,17,11,5,'2018-04-26',63507,37.83,4.21,159.264),(1229,51,15,3,'2018-04-27',NULL,NULL,NULL,0),(1230,19,18,30,'2018-04-27',108863,22.07,3.98,87.8386),(1231,44,16,2,'2018-04-27',NULL,NULL,NULL,0),(1232,15,7,30,'2018-04-27',1740683046,30.46,3.98,121.231),(1233,19,18,30,'2018-04-30',109232,41.5,3.98,165.17),(1234,7,37,2,'2018-04-30',63571,51.1,4.06,207.466),(1235,18,10,2,'2018-05-02',65847,39.39,4.06,159.923),(1236,50,15,3,'2018-05-02',84843,29.02,4.14,120.143),(1237,44,16,2,'2018-05-02',106183,49.11,3.42,167.956),(1238,13,13,3,'2018-05-02',135064,46.18,4.14,191.185),(1239,57,38,3,'2018-05-02',NULL,49.19,4.24,208.566),(1240,12,19,2,'2018-05-02',64622,34.9,4.11,143.439),(1241,14,21,3,'2018-05-03',105590,48.35,4.14,200.169),(1242,38,12,30,'2018-05-03',45459,54.47,3.98,216.791),(1243,8,9,3,'2018-05-03',74612,38.95,4.14,161.253),(1244,50,15,3,'2018-05-04',85052,21.18,4.14,87.6852),(1245,15,7,30,'2018-05-05',74242,20.21,3.98,80.4358),(1246,44,16,2,'2018-05-05',106594,47.16,3.42,161.287),(1247,17,11,5,'2018-05-07',63875,39.21,4.21,165.074),(1248,18,10,2,'2018-05-08',66297,35.92,4.06,145.835),(1249,50,15,3,'2018-05-08',85398,35.19,4.14,145.687),(1250,25,2,5,'2018-05-08',NULL,NULL,NULL,0),(1251,44,16,2,'2018-05-08',NULL,NULL,NULL,0),(1252,15,7,30,'2018-05-08',74571,35.69,3.98,142.046),(1253,19,18,30,'2018-05-08',109460,26.67,3.98,106.147),(1254,13,37,2,'2018-05-09',135473,NULL,NULL,0),(1255,7,15,2,'2018-05-09',NULL,NULL,NULL,0),(1256,25,31,5,'2018-05-09',79041,36.17,4.21,152.276),(1257,44,36,2,'2018-05-10',107304,40.56,3.57,144.799),(1258,12,19,2,'2018-05-10',64977,36.08,4.11,148.289),(1259,18,10,2,'2018-05-11',66712,35.74,4.11,146.891),(1260,25,18,2,'2018-05-11',79173,15.24,4.11,62.6364),(1261,29,34,5,'2018-05-11',66858,41.02,4.21,172.694),(1262,44,13,2,'2018-05-12',107614,36.05,3.57,128.699),(1263,19,18,30,'2018-05-12',109851,43.64,4.02,175.433),(1264,14,21,3,'2018-05-14',105997,50.2,4.26,213.852),(1265,17,11,5,'2018-05-14',64259,36.3,4.26,154.638),(1266,44,36,2,'2018-05-15',107888,32.07,3.57,114.49),(1267,13,37,3,'2018-05-15',NULL,NULL,NULL,0),(1268,7,17,2,'2018-05-15',NULL,NULL,NULL,0),(1269,8,9,3,'2018-05-16',74966,39.53,4.26,168.398),(1270,50,13,3,'2018-05-16',NULL,NULL,NULL,0),(1271,18,10,2,'2018-05-17',67169,40.02,4.11,164.482),(1272,6,15,2,'2018-05-17',NULL,NULL,NULL,0),(1273,15,18,30,'2018-05-17',74898,38.81,4.02,156.016),(1274,25,2,5,'2018-05-17',NULL,NULL,NULL,0),(1275,12,19,2,'2018-05-18',65346,33.28,4.21,140.109),(1276,17,11,5,'2018-05-18',64671,37.01,4.26,157.663),(1277,44,15,30,'2018-05-18',108231,39.73,3.65,145.014),(1278,19,18,30,'2018-05-18',110045,32.11,4.02,129.082),(1279,44,16,2,'2018-05-19',108601,42.83,3.74,160.184),(1280,13,37,3,'2018-05-21',136225,38.89,4.39,170.727),(1281,50,15,3,'2018-05-21',NULL,NULL,NULL,0),(1282,15,7,30,'2018-05-21',75130,31.09,4.17,129.645),(1283,14,21,3,'2018-05-22',106451,46.67,4.39,204.881),(1284,36,36,2,'2018-05-22',NULL,NULL,NULL,0),(1285,17,11,5,'2018-05-22',64977,28.76,4.46,128.27),(1286,15,7,30,'2018-05-22',75337,20.94,4.22,88.3668),(1287,8,9,2,'2018-05-22',75205,28.2,4.38,123.516),(1288,7,17,2,'2018-05-22',64676,36.48,4.38,159.782),(1289,12,19,2,'2018-05-22',65477,12.2,4.34,52.948),(1290,19,18,30,'2018-05-22',111069,41.96,4.44,186.302),(1291,50,15,30,'2018-05-23',NULL,NULL,NULL,0),(1292,13,37,30,'2018-05-23',136446,24.08,4.49,108.119),(1293,18,10,30,'2018-05-23',67572,36.46,4.49,163.705),(1294,44,16,2,'2018-05-25',NULL,NULL,NULL,0),(1295,44,16,5,'2018-05-25',NULL,NULL,NULL,0),(1296,44,36,5,'2018-06-01',NULL,NULL,NULL,0),(1297,15,7,30,'2018-06-07',76028,24.58,4.449,109.356),(1298,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(1299,57,38,30,'2018-06-01',NULL,41.35,4.49,185.661),(1300,6,33,2,'2018-06-01',NULL,40.7,4.38,178.266),(1303,8,9,2,'2018-06-01',75569,31.55,4.38,138.189),(1304,13,37,30,'2018-06-01',136745,37.36,4.49,167.746),(1305,44,36,30,'2018-06-04',NULL,NULL,NULL,0),(1306,50,15,3,'2018-06-04',87249,32.85,4.49,147.497),(1307,7,17,3,'2018-06-04',40403,38.43,4.49,172.551),(1308,49,24,5,'2018-06-04',NULL,NULL,NULL,0),(1310,36,17,3,'2018-06-05',47881,47.7,4.49,214.173),(1311,44,16,30,'2018-06-06',NULL,NULL,NULL,0),(1312,18,10,2,'2018-06-06',68249,39.29,4.34,170.519),(1313,14,21,3,'2018-06-06',10726,45.01,4.59,206.596),(1314,13,37,3,'2018-06-07',137115,40.72,NULL,0),(1315,17,11,5,'2018-06-07',65713,35.92,4.57,164.154),(1316,50,36,30,'2018-06-07',NULL,NULL,NULL,0),(1317,12,19,2,'2018-06-07',65911,35.34,4.3,151.962),(1318,25,31,5,'2018-06-08',80246,44.49,4.57,203.319),(1319,44,36,30,'2018-06-08',NULL,NULL,NULL,0),(1321,6,33,2,'2018-06-08',NULL,42.65,4.34,185.101),(1322,58,22,2,'2018-06-09',NULL,NULL,NULL,0),(1323,48,2,5,'2018-06-11',NULL,NULL,NULL,0),(1324,50,13,3,'2018-06-11',NULL,NULL,NULL,0),(1325,44,36,2,'2018-06-11',NULL,NULL,NULL,0),(1326,50,13,3,'2018-06-12',NULL,NULL,NULL,0),(1327,19,18,30,'2018-06-12',111253,23.43,4.44,104.029),(1328,15,7,30,'2018-06-12',76236,23.6,4.449,104.996),(1329,8,9,3,'2018-06-12',NULL,NULL,NULL,0),(1330,18,10,2,'2018-06-12',68659,35.89,4.341,155.798),(1331,57,38,3,'2018-06-12',NULL,44.21,4.49,198.503),(1332,17,11,5,'2018-06-12',66058,31.43,4.18,131.377),(1333,13,37,3,'2018-06-13',NULL,NULL,NULL,0),(1334,44,16,2,'2018-06-13',NULL,NULL,NULL,0),(1336,12,19,2,'2018-06-13',66255,33.37,4.34,144.826),(1337,12,19,28,'2018-06-13',NULL,NULL,NULL,0),(1338,12,19,2,'2018-06-13',NULL,NULL,NULL,0),(1339,50,13,3,'2018-06-13',NULL,NULL,NULL,0),(1340,7,17,3,'2018-06-14',NULL,NULL,NULL,0),(1341,25,1,5,'2018-06-14',80877,40.23,4.46,179.426),(1342,14,21,3,'2018-06-14',107699,52.69,4.49,236.578),(1343,29,34,5,'2018-06-14',67340,39,4.46,173.94),(1344,15,7,30,'2018-06-15',76486,29.07,4.27,124.129),(1345,18,10,2,'2018-06-15',NULL,NULL,NULL,0),(1346,44,36,2,'2018-06-15',NULL,NULL,NULL,0),(1347,44,16,2,'2018-06-16',NULL,NULL,NULL,0),(1348,19,18,30,'2018-06-18',NULL,NULL,NULL,0),(1349,15,7,30,'2018-06-18',76770,30.35,4.23,128.38),(1350,50,13,3,'2018-06-18',NULL,NULL,NULL,0),(1351,17,11,5,'2018-06-18',NULL,NULL,NULL,0),(1352,44,13,2,'2018-06-19',NULL,NULL,NULL,0),(1353,7,9,2,'2018-06-19',48401,52.39,4.34,227.373),(1354,18,10,2,'2018-06-20',NULL,NULL,NULL,0),(1355,8,9,2,'2018-06-20',NULL,NULL,NULL,0),(1356,44,16,30,'2018-06-20',NULL,NULL,NULL,0),(1357,25,2,5,'2018-06-20',NULL,NULL,NULL,0),(1358,50,16,30,'2018-06-20',NULL,NULL,NULL,0);

--
-- Table structure for table `fornecedor`
--

CREATE TABLE `fornecedor` (
  `id_fornecedor` int(10) NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) DEFAULT NULL,
  `endereco` varchar(100) DEFAULT NULL,
  `telefone` varchar(50) DEFAULT NULL,
  `id_tipofornecedor` int(10) DEFAULT NULL,
  PRIMARY KEY (`id_fornecedor`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fornecedor`
--

INSERT INTO `fornecedor` VALUES (1,'MECÂNICA STOP CAR','R. FLORIANÓPOLIS, 1818','(49) 3622 8592',3),(2,'POSTO BERTAMONI','R. WILLY BARTH, 3845   ','(49) 36220680',1),(3,'POSTO DO GAROTO','R. ALMIRANTE BARROSO, 797    ','(49) 36221355',1),(4,'POSTO ITAIPÚ','AV. GETULIO VARGAS, 773        ','(49) 36228243',1),(5,'POSTO DALTOÉ','R. 7 DE SETEMBRO, 2100     ','(49) 36220670',1),(6,'DPASCHOAL        ','R. SANTOS DUMONT, 90      ','(49) 3622 2959 ',3),(7,'MÔNACO PNEUS','R. WILLY BARTY, 3630      ','(49) 36220199',3),(8,'LAVACAR OESTE','R. MARCÍLIO DIAS, 1290','(49) 91259163',3),(9,'LAVACAR DO MANINHO','R. MARECHAL BORMANN, SN','(49) 88639440',3),(10,'LAVACAR RENASCER','R. MARECHAL BORMANN, 1458','(49) 91603189',3),(12,'CONTAINER OLEO','R. ALMIRANTE TAMANDARE, 471','(49) 36224839',3),(13,'J PINTO','R. WILLY BARTH, 5500','(49) 3622 1707',3),(14,'TAISOM','R. ALMIRANTE BARROSO, SN','(49) 9155 8840',3),(15,'AR PNEUS','R. WALDEMAR RANGRAB, 4101','(49) 3622 6945',3),(16,'Exemplo - Outros','SMO','49 49 49 49 49',4),(17,'ELETRIC SOM','R. WALDEMAR RANGRAB, 315    ','(49) 36214217',3),(18,'GELLER','R. SANTOS DUMONT, 405','(49) 36220294',3),(19,'DANIEL PEÇAS','R. WALDEMAR RANGRAB, 1257','(49) 3621 1855',3),(20,'J. A. COMUNICACAO LTDA - ME ','R. FLORIANOPOLIS, 200, SÃO GOTARDO                 ','(49) 36224545',3),(21,'BORRACHARIA P4 PNEUS','R. XV de Novembro','(49) 3622 7547',3),(22,'MECÂNICA NEI','R. WILLY BARTH, SN','(49) 3622 2915',3),(23,'BETO PNEUS','R. WALDEMAR RANGRAB','(49) 3622 7100',3),(24,'ESTOFARIA CHIQUE','R. XV DE NOVEMBRO','(49) 3622 1125',3),(25,'MECÂNICA JWV DO JAJÁ','R. 21 DE ABRIL, 1680','(49) 3622 7284',3),(26,'MILTON PNEUS','AV. GETULIO VARGAS, 50       ','(49) 3621 3152',3),(27,'METALÚRGICA FACCIO','R. PADRE AURELIO CANZI, SN','(49) 3622 5072',3),(28,'ABASTECIMENTO EXTERNO','EXTERNO',NULL,1),(29,'LÍDER ESCAPAMENTOS','R. WALDEMAR RANGRAB, SN','(49) 3622 2937',3),(30,'POSTO VOLTA GRANDE','R. WILLY BARTH, SN',NULL,1),(31,'AUTOELÉTRICA BALBINOT','R. OIAPOQUE','(49) 3621 1014',3),(32,'RUDIGER','R. WALEMAR RANGRAB','(49) 3631 7500',3),(33,'SINUELO','R. WILLY BARTH',NULL,3),(34,'MECANICA ALBATER','R. WILLY BARTH',' 3622 1201',3);

--
-- Table structure for table `motorista`
--

CREATE TABLE `motorista` (
  `id_motorista` int(10) NOT NULL AUTO_INCREMENT,
  `motorista` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id_motorista`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `motorista`
--

INSERT INTO `motorista` VALUES (1,'FERNANDO POHL'),(2,'DANIEL EDGAR CAVALHEIRO'),(3,'TIAGO SENGER'),(4,'CLAUDECIR RENATO GODOIS'),(6,'JOSEMAR DE ASSIS PINTO'),(7,'MARCELO MULLER'),(8,'RAFAEL FAQUI'),(9,'RAFAEL GUSTAVO DRESCH'),(10,'MARCELO SIGNORI'),(11,'LUIS ALEXANDRE WILLE'),(12,'JOSEMAR PIRES DA SILVA'),(13,'JAISON FELIPE RODRIGUES'),(14,'HEMERSOM BRANCO'),(15,'GABRIEL MARCOS PEREIRA'),(16,'FABIANO DOMINGOS PAVONI'),(17,'OENDEL MAGRINI'),(18,'MATEUS GEOVANI GRANELLA'),(19,'TAIVAN SCHAEFFER DE OLIVEIRA'),(20,'ALAERTI RICARDO ZORZI'),(21,'ALAN KOEFENDER'),(22,'GEVERSON MATEUS RODRIGUES'),(23,'FERNANDO SIMIONI'),(24,'ALVARO MONARETTO'),(25,'JEAN CHINI'),(27,'CARRO NOVO'),(29,'VANDOIR'),(30,'MAGNOS'),(31,'THALES OGLIARI'),(32,'PLINIO'),(33,'CARTNEY MAGRINI'),(34,'DIEGO PIVETTA'),(35,'CARLOS'),(36,'JUNIOR'),(37,'OSEIAS'),(38,'DIEGO ALEX PELISSARI');

--
-- Table structure for table `relatorios`
--

CREATE TABLE `relatorios` (
  `id_relatorio` int(10) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_relatorio`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `relatorios`
--

INSERT INTO `relatorios` VALUES (1,'Veiculos','pdf/relatorios.php?tipo=tecnico'),(2,'Motorista','pdf/relatorios.php?tipo=motorista'),(3,'Fornecedor','pdf/relatorios.php?tipo=fornecedor'),(4,'Veiculo','pdf/relatorios.php?tipo=veiculo');

--
-- Table structure for table `requisicoes`
--

CREATE TABLE `requisicoes` (
  `id_requisicao` int(10) NOT NULL AUTO_INCREMENT,
  `id_motorista` int(10) DEFAULT NULL,
  `id_empresa` int(10) DEFAULT NULL,
  `data` date DEFAULT NULL,
  `descricao` text,
  `valor` float DEFAULT NULL,
  PRIMARY KEY (`id_requisicao`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `requisicoes`
--


--
-- Table structure for table `servico`
--

CREATE TABLE `servico` (
  `id_servico` int(10) NOT NULL AUTO_INCREMENT,
  `id_tiposervico` int(10) DEFAULT NULL,
  `id_fornecedor` int(10) DEFAULT NULL,
  `id_veiculo` int(11) DEFAULT NULL,
  `id_motorista` int(10) DEFAULT NULL,
  `dia` date DEFAULT NULL,
  `km` float DEFAULT NULL,
  `preco` float DEFAULT NULL,
  `descricao` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_servico`)
) ENGINE=InnoDB AUTO_INCREMENT=604 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servico`
--

INSERT INTO `servico` VALUES (5,5,1,7,16,'2016-10-24',36067,NULL,'REVISÃO. Foi feito geometria e balanceamento'),(6,1,12,7,16,'2016-10-19',NULL,NULL,'TROCA DE ÓLEO'),(7,5,1,8,27,'2016-10-21',57096,168,'REVISÃO: discos, pastilhas, correia, barra, '),(8,3,6,8,27,'2016-10-21',57096,NULL,'CONSERTO DE PNEU'),(9,5,14,14,17,'2016-10-26',84536,40,'CONSERTO DO TAMPÃO'),(10,5,13,8,16,'2016-10-26',57101,350,'Colocar suporte de escada'),(11,2,15,10,14,'2016-10-26',118181,410,'TROCAR 2 PNEUS DIANTEIROS. Trocado 2 pneus'),(12,1,12,18,10,'2016-10-29',30090,116,'Feito troca de oleo e do filtro'),(13,4,10,12,19,'2016-10-29',42315,15,'Lavagem de aparência'),(14,4,10,19,8,'2016-10-29',73556,15,'Lavagem de aparência'),(15,4,10,18,10,'2016-10-29',30090,15,'Lavagem de aparência'),(16,4,10,14,18,'2016-10-29',84767,15,'Lavagem de aparência'),(17,1,12,10,14,'2016-10-31',118694,104,'Trocado óleo'),(18,5,17,10,13,'2016-11-01',118843,5,'Trocar lâmpada do freio'),(19,5,17,3,20,'2016-10-03',NULL,145,'Troca de lâmpadas, palheta'),(20,5,17,17,11,'2016-10-14',NULL,30,'Trocado lâmpada'),(24,5,17,16,11,'2016-10-20',NULL,200,'Bateria D Mark '),(25,5,17,20,2,'2016-10-20',NULL,90,'trocado lâmpadas e mão de obra'),(26,5,17,20,2,'2016-10-24',NULL,45,'mão de obra'),(27,5,1,7,16,'2016-10-24',NULL,391,'balanceamento, geometria, molas, bandeja, amortecedor, buchas, mão de obra'),(28,5,1,16,16,'2016-10-19',NULL,40,'VAZAMENTO DE ÁGU'),(29,5,1,16,2,'2016-10-05',NULL,420,'Conserto alavanca de marcha; mão de obra'),(30,5,1,21,2,'2016-10-13',NULL,736.7,'REVISÃO: junta coletor escape; torno; sensor abs traseiro; passar aparelho e mão de obra'),(31,5,1,9,27,'2016-10-10',NULL,310,'REVISÃO: limpeza de bicos; passe nos discos; conserto chicote painel; mão de obra'),(33,5,18,8,16,'2016-11-04',NULL,NULL,'Trocar vidro lateral traseiro'),(34,1,1,22,29,'2016-11-04',NULL,NULL,'TROCA DE ÓLEO'),(35,4,10,23,30,'2016-11-04',NULL,NULL,NULL),(36,4,10,4,12,'2016-11-04',75063,20,'Lavação'),(37,4,10,13,2,'2016-11-05',103390,15,'Lavagem de aparência'),(39,5,17,11,9,'2016-11-08',67575,5,'Lâmpada'),(40,4,10,22,29,'2016-11-09',NULL,15,'lavação de aparência'),(41,5,19,17,11,'2016-11-14',38083,280,'Troca do parabrisa'),(43,5,17,18,10,'2016-11-16',30635,40,'Trocar lâmpada'),(44,5,1,19,8,'2016-11-18',NULL,NULL,'Verificar amortecedor traseiro'),(45,4,10,4,12,'2016-11-19',NULL,NULL,NULL),(46,4,10,17,11,'2016-11-19',38129,20,'Lavação'),(47,4,8,11,9,'2016-11-19',NULL,NULL,NULL),(48,5,1,3,20,'2016-11-21',NULL,NULL,'Revisão'),(49,5,17,26,27,'2016-11-21',51180,185,'Troca do retrovisor'),(50,5,1,26,27,'2016-11-22',NULL,NULL,'Revisão'),(51,5,17,26,27,'2016-11-21',NULL,NULL,'Buzina, lâmpada e limpadores'),(52,5,17,3,20,'2016-11-22',NULL,NULL,'Troca de lâmpada do farol e lanterna traseira'),(53,5,1,12,19,'2016-11-23',43200,350,'Vazamento de gasolina. Ver correia dentada. Boia/sensor de combustivel'),(54,5,13,26,27,'2016-11-23',51200,350,'Suporte de escada'),(55,5,20,26,27,'2016-11-24',51204,NULL,'Adesivar '),(56,2,6,15,7,'2016-11-23',44655,313,'Troca de dois pneus'),(57,4,10,15,7,'2016-11-23',44252,20,'Lavação'),(58,4,10,7,16,'2016-11-23',37265,20,'Lavação'),(59,4,10,22,29,'2016-11-23',NULL,20,'Lavação'),(60,3,21,8,9,'2016-11-24',68111,15,'Conserto de pneu'),(61,1,12,13,3,'2016-11-26',104810,281.4,'Filtro oleo, oleo motor, filtro ar, filtro cabine'),(62,4,10,13,3,'2016-11-26',NULL,NULL,NULL),(63,2,7,13,3,'2016-11-25',NULL,983,'Troca dos 4 pneus'),(64,5,17,10,14,'2016-11-28',NULL,NULL,'Arrumar limpador de parabrisa'),(65,2,6,19,8,'2016-11-29',NULL,507.66,'Trocado 2 pneus'),(66,4,10,15,18,'2016-12-01',NULL,NULL,NULL),(67,5,17,9,20,'2016-12-01',21993,320,'Piscas não funcionam. 01 chave de seta, 2 lampada nº 148.'),(68,5,1,14,18,'2016-12-03',86439,238,'Rodízio de pneus; geometria; balanceamento; verificar freios'),(69,4,9,22,29,'2016-12-02',NULL,NULL,'Lavação'),(70,4,9,4,12,'2016-12-02',NULL,NULL,NULL),(71,4,9,15,7,'2016-12-02',45510,15,'Lavação'),(72,5,14,4,12,'2016-12-05',78678,80,'Arrumar fechadura'),(73,5,22,27,2,'2016-12-05',58255,NULL,'Revisão'),(74,5,14,8,9,'2016-12-05',57309,NULL,'Vidro não abre'),(75,5,18,27,2,'2016-12-05',58244,NULL,'Reboque'),(76,5,17,8,9,'2016-12-05',57287,5,'Trocar lâmpada '),(77,2,23,27,2,'2016-12-08',58271,1897.5,'Troca de 2 pneus'),(78,5,1,17,11,'2016-12-09',38817,60,'Erguer suspensão traseira'),(79,4,9,18,10,'2016-12-10',31832,15,'Lavação'),(80,4,9,16,18,'2016-12-10',63408,15,'Lavação'),(81,4,9,9,20,'2016-12-10',22321,15,'Lavação'),(82,5,17,7,16,'2016-12-12',37793,200,'Trocar bateria'),(83,4,9,7,16,'2016-12-12',37850,15,'Lavação'),(84,5,24,27,2,'2016-12-12',NULL,350,'Encosto do banco carona'),(86,4,9,25,18,'2016-12-14',86460,15,'Lavação'),(87,4,9,22,29,'2016-12-14',NULL,NULL,NULL),(88,3,23,15,7,'2016-12-15',46445,28,'Conserto de 01 pneu'),(89,4,9,8,9,'2016-12-17',57744,15,'lavação'),(90,5,13,20,22,'2016-12-20',NULL,NULL,'Arrumar suporte da carretinha'),(91,5,1,10,14,'2016-12-21',NULL,NULL,'Verificar vazamento de gasolina'),(92,5,13,28,27,'2016-12-22',NULL,350,'Colocar suporte de escada'),(93,5,13,30,27,'2016-12-22',NULL,350,'Colocar suporte de escada'),(94,4,9,13,3,'2016-12-23',NULL,NULL,NULL),(95,1,12,28,27,'2016-12-23',NULL,NULL,NULL),(96,1,12,30,27,'2016-12-23',NULL,NULL,NULL),(97,4,9,4,12,'2016-12-23',29828,15,'Lavação'),(98,4,9,10,14,'2016-12-24',NULL,NULL,NULL),(99,4,9,12,19,'2016-12-24',NULL,NULL,NULL),(100,5,6,19,8,'2016-12-26',76919,450,'Verificar freios'),(101,4,9,13,14,'2016-12-26',107682,15,'lavação'),(102,4,9,9,20,'2016-12-27',22725,15,'Lavação'),(103,4,9,17,11,'2016-12-27',39202,15,'lavação'),(104,5,25,10,14,'2016-12-28',NULL,NULL,'Solda da proteção do motor'),(105,2,26,29,23,'2016-12-29',50877,465,'Troca dos pneus dianteiros'),(106,4,9,15,7,'2016-12-29',47810,15,'Lavação'),(107,4,9,19,8,'2016-12-29',77168,15,'lavação'),(110,1,12,10,14,'2016-12-30',NULL,NULL,'Troca de óleo'),(111,4,9,18,10,'2016-12-31',32843,15,'lavação'),(112,5,14,27,2,'2017-01-02',59148,NULL,'Colocação de película e manutenção na parte elétrica'),(113,5,1,12,19,'2017-01-03',44700,100,'Verificar vazamento de gasolina'),(114,5,1,15,7,'2017-01-03',47903,140,'Verificar calço do motor'),(115,4,9,24,10,'2017-01-03',1501,10,'lavação'),(116,5,1,10,13,'2017-01-04',NULL,NULL,'Motor está subindo a temperatura'),(117,5,27,20,2,'2017-01-04',60250,NULL,'Arrumar carretinha'),(118,5,1,10,14,'2017-01-06',126295,140,'Verificar aquecimento no motor'),(119,2,15,7,16,'2017-01-06',38657,530,'Troca dos dois pneus traseiros'),(120,4,9,7,16,'2017-01-07',38666,15,'lavação'),(121,4,9,12,19,'2017-01-07',44895,15,'lavação'),(122,5,1,30,27,'2017-01-10',34800,177,'Revisão'),(123,1,12,19,8,'2017-01-10',78480,NULL,'troca de oleo'),(124,5,14,13,14,'2017-01-10',NULL,NULL,'Trocar lâmpada e palheta'),(125,5,1,17,11,'2017-01-12',39668,NULL,'Revisão'),(126,4,9,8,9,'2017-01-14',58864,15,'lavação'),(127,5,20,30,18,'2017-01-17',34865,NULL,'Colocação de adesivos'),(128,4,9,4,11,'2017-01-19',80494,15,'Lavação'),(129,5,29,18,10,'2017-01-20',34760,130,'Verificar freios'),(130,4,9,14,18,'2017-01-19',88051,20,'Lavação'),(131,1,12,12,19,'2017-01-21',45850,NULL,'Troca de óleo'),(132,5,20,28,11,'2017-01-20',NULL,NULL,'Colocação de adesivos'),(133,2,15,4,12,'2017-01-23',80637,720,'Troca dos 4 pneus'),(134,4,9,18,10,'2017-01-23',34825,20,'Lavação'),(136,5,29,13,14,'2017-01-24',110865,NULL,'Verificar mangueira do combustível'),(137,2,15,18,10,'2017-01-27',35081,NULL,'Troca de 2 pneus'),(138,4,9,25,1,'2017-01-27',42442,20,'Lavação'),(139,4,9,7,16,'2017-01-28',39650,20,'Lavação'),(140,4,9,22,29,'2017-01-31',NULL,20,'Lavação'),(141,5,22,44,1,'2017-01-30',68891,2724,'REVISÃO'),(142,2,15,17,11,'2017-01-31',40155,360,'Troca de 2 pneus'),(143,1,12,14,18,'2017-01-31',88450,144.3,'Troca de óleo'),(144,1,12,17,11,'2017-02-02',40169,104,'Troca de óleo'),(145,5,1,12,19,'2017-02-04',46361,105,'Trocar pastilhas de freio. Mão de obra R$ 45,00 e pastilhas R$ 60,00 pegas na Sinuelo'),(146,5,14,44,1,'2017-02-02',NULL,NULL,'Verificar vidro, película e luzes internas '),(147,5,1,45,1,'2017-02-06',78850,2397.4,'Revisão'),(148,5,22,27,2,'2017-02-07',62977,3220,'Verificar caixa de marcha'),(149,4,9,13,14,'2017-02-07',112502,20,'lavação'),(150,5,13,45,1,'2017-02-08',NULL,420,'Colocação de suporte de escada'),(151,5,20,45,1,'2017-02-09',78865,520,'Colocação de adesivos'),(152,2,15,45,1,'2017-02-11',78865,1030,'Troca dos 4 pneus e geometria'),(153,5,25,13,14,'2017-02-09',112833,30,'Arrumar proteção do motor. Trocado parafusos e desentortado proteção do motor.'),(154,5,1,18,10,'2017-02-10',36224,420,'Verificar vazamento de gasolina. R$ 120,00 mão de obra + R$ 300,00 (+-) do tanque na Sinuelo'),(156,2,15,7,15,'2017-02-14',40382,500,'Troca dos pneus dianteiros'),(157,4,9,7,15,'2017-02-18',40670,20,'lavação'),(159,4,9,27,15,'2017-02-18',63737,20,'Lavação'),(160,5,13,25,8,NULL,NULL,NULL,'Suporte de escada'),(161,5,13,25,8,'2017-02-20',43236,120,'Suporte de escada'),(162,5,1,29,1,'2017-02-20',56100,165,'Verificar aquecimento'),(163,4,9,17,11,'2017-02-25',40738,20,'Lavação'),(164,2,15,15,7,'2017-02-23',49925,500,'Troca dos 2 pneus dianteiros'),(166,2,15,8,9,'2017-02-25',60187,750,'Troca dos 4 pneus'),(167,4,9,22,29,'2017-02-24',NULL,NULL,NULL),(168,1,12,13,14,'2017-02-24',114890,164,'Troca de óleo'),(169,4,9,19,18,'2017-02-24',81116,20,'Lavação'),(170,4,9,7,16,'2017-02-25',40670,20,'Lavação'),(171,4,9,18,10,'2017-02-25',36972,20,'Lavação'),(172,4,9,14,15,'2017-02-25',89451,20,'lavação'),(173,4,9,8,19,'2017-02-27',60195,20,'Lavação'),(174,2,15,12,19,'2017-03-01',46980,430,'Troca dos 2 pneus dianteiros'),(175,2,15,18,10,'2017-03-01',37200,360,'Troca dos 2 pneus dianteiros'),(176,5,14,7,16,'2017-03-01',41137,70,'Trocar luz de freio e farol'),(177,5,1,4,12,'2017-03-04',82455,417.45,'Verificar suspensão, freios e barulho na direção. Trocado kit correia, bucha de bandeja'),(178,4,9,12,19,'2017-03-04',47259,20,'Lavação'),(179,4,9,13,2,'2017-03-04',115703,20,'Lavação'),(180,5,1,14,15,'2017-03-11',NULL,NULL,'Verificar freios e suspensão. Revisão geral.'),(181,4,9,4,12,'2017-03-07',32457,20,'Lavação'),(182,1,12,4,12,'2017-03-07',82460,120.3,'Troca de óleo'),(183,4,9,29,12,'2017-03-07',56420,20,'LAVAÇÃO'),(184,4,9,22,29,'2017-03-08',NULL,20,'Lavação'),(185,4,9,9,12,'2017-03-08',25218,20,'Lavação'),(186,4,9,44,12,'2017-03-08',68961,25,'Lavação'),(187,5,17,12,19,'2017-03-11',47562,40,'Trocar lâmpada do farol'),(188,4,9,7,16,'2017-03-11',41728,20,'Lavação'),(189,5,17,13,14,'2017-03-13',116787,205,'Troca de Bateria e Lampada de Freio'),(191,5,17,12,19,'2017-03-17',47800,200,'Troca da bateria'),(192,4,9,25,22,'2017-03-18',45943,20,'Lavação'),(193,5,32,15,7,'2017-03-20',50937,275,'Trocar interruptor'),(194,5,13,44,2,'2017-03-21',69008,180,'Ajustes no suporte de escada'),(195,5,29,13,14,'2017-03-21',NULL,NULL,'Verificar ventoinha'),(197,5,17,13,13,'2017-03-22',117659,40,'Trocar lâmpada do farol'),(198,5,17,18,10,'2017-03-22',38688,195,'Testar alternador ou efetuar troca da bateria/ Trocado bateria e uma lâmpada'),(199,5,18,25,22,'2017-03-23',45966,180,'Polimento do parabrisa'),(200,5,18,25,2,'2017-03-23',46241,40,'Troca das palhetas'),(201,5,13,44,2,'2017-03-24',69087,120,'Ajustes no suporte de escada'),(202,2,15,13,14,'2017-03-24',NULL,NULL,'Troca dos dois pneus dianteiros'),(203,5,1,8,9,'2017-03-31',61222,40,'Verificar barulho no motor (correia ou alternador) - TROCADO CORREIA'),(204,4,9,4,12,'2017-03-25',83649,20,'Lavação'),(205,4,9,14,15,'2017-03-25',90716,20,'Lavação'),(206,4,9,8,9,'2017-03-25',61034,20,'Lavação'),(208,4,9,18,10,'2017-03-25',38883,20,'Lavação'),(209,5,13,20,2,'2017-03-27',66763,50,'Fazer eixo para a Carretinha'),(210,4,9,13,14,'2017-03-27',NULL,NULL,'Lavação'),(211,3,15,12,19,'2017-03-23',48059,0,'Conserto de pneu'),(212,1,12,7,16,'2017-03-31',42700,128,'TROCA DE ÓLEO'),(213,5,22,27,1,'2017-03-29',NULL,NULL,'Verificar embreagem'),(215,5,1,12,19,'2017-03-29',48368,120,'Trocar o filtro e manga de combustível '),(216,5,15,7,16,'2017-03-29',NULL,40,'Balanceamento e alinhamento do Agile do cliente Gustavo Freitas ref. falta de sinalização na entrada do Ed. Santorini'),(217,2,15,44,2,'2017-04-01',NULL,NULL,'Troca dos 4 pneus'),(218,5,14,44,2,'2017-03-31',69420,70,'Tomada elétrica, luzes e tomada da carretinha. FEITO INSTALAÇÃO DO REBOQUE'),(219,1,22,27,14,'2017-03-31',67299,207,'Troca do óleo e filtro'),(220,4,9,22,29,'2017-03-31',NULL,20,'Lavação'),(221,3,15,27,14,'2017-04-04',67682,20,'Colocar pneu antigo como step'),(222,5,18,18,10,'2017-04-04',39406,40,'Trocar palhetas'),(223,5,18,9,31,'2017-04-05',25323,40,'Troca de palhetas'),(224,5,1,8,9,'2017-04-10',61443,1250,'Verificar barulho no motor'),(225,5,1,4,12,'2017-04-11',85035,200,'Troca de pinça de freio'),(227,3,7,12,19,'2017-04-11',NULL,NULL,'Verificar pneu'),(228,4,9,4,12,'2017-04-12',85269,20,'Lavação'),(229,4,9,22,29,'2017-04-12',NULL,NULL,'Lavação'),(230,5,29,13,1,'2017-04-17',NULL,168,'Verificar bomba de combustível'),(231,4,9,18,10,'2017-04-18',39883,20,'Lavação'),(232,2,15,17,11,'2017-04-20',42278,NULL,'Troca dos pneus dianteiros'),(233,5,15,29,25,'2017-04-18',NULL,NULL,'Geometria e balanceamento'),(234,4,9,15,7,'2017-04-20',53330,20,'Lavação'),(235,4,9,29,25,'2017-04-20',57844,20,'Lavação'),(236,5,1,12,19,'2017-04-20',49347,336,'Verificar sensor do acelerador'),(237,5,29,14,15,'2017-04-22',91823,175,'Trocar pastilhas de freio; revisão do freio - Trocado pastilha do freio dianteiro e só limpado e regulado freio de trás'),(238,4,9,44,2,'2017-04-24',71560,20,'Lavação'),(239,2,15,25,8,'2017-04-24',47997,590,'Troca dos pneus dianteiros'),(240,5,1,17,11,'2017-04-26',42485,70,'Verificar vazamento de água'),(241,5,29,13,2,'2017-04-25',NULL,440,'Verificar freios'),(242,5,22,44,1,'2017-04-27',NULL,NULL,'Verificar aquecimento; Troca da bomba d\'água'),(243,4,9,22,29,'2017-04-27',NULL,20,'lavação'),(244,5,17,12,19,'2017-04-28',49659,40,'trocar lampada do farol'),(245,4,9,12,19,'2017-04-29',49757,20,'LAVAÇÃO'),(246,5,14,44,1,'2017-04-29',NULL,NULL,'instalar gps'),(247,5,14,27,13,'2017-05-02',NULL,NULL,'troca da meia luz e luz da placa'),(248,4,9,8,9,'2017-05-06',62101,20,'Lavação'),(250,4,9,4,12,'2017-05-06',87044,20,'Lavação'),(251,5,14,13,2,'2017-05-08',NULL,NULL,'Arrumar tomada de energia'),(252,5,22,44,2,'2017-05-08',NULL,NULL,'Trocar Kit de Rolamento de ponta de Eixo.'),(253,5,17,44,1,'2017-05-11',72554,20,'Ajustar esguicho direito do limpador do para-brisa. '),(254,4,9,19,18,'2017-05-13',87149,20,'lavação'),(255,4,9,25,22,'2017-05-15',50249,20,'lavação'),(256,4,9,7,16,'2017-05-20',44579,20,'LAVACAO'),(257,5,14,27,1,'2017-05-05',NULL,NULL,'Instalação de GPS nas duas Ranger. '),(258,1,12,18,10,'2017-05-23',41305,119,'Troca de óleo'),(259,5,14,4,12,'2017-05-23',88508,110,'Trocar palhetas e lâmpada'),(260,5,14,47,13,'2017-05-26',NULL,45,'Colocar tomada'),(261,5,14,44,2,'2017-05-29',NULL,NULL,'Ajeitar lâmpada interna e lâmpada da placa do reboque'),(262,5,17,17,11,'2017-05-29',43417,120,'Trocar lâmpada'),(263,5,14,47,8,'2017-05-30',NULL,NULL,'Arrumar luzes'),(264,4,9,13,8,'2017-05-30',0,20,'LAVAÇÃO'),(265,1,12,14,15,'2017-06-01',93426,16.55,'Emendar o óleo'),(266,1,12,19,18,'2017-06-01',88573,244,'Troca de óleo'),(267,1,12,15,7,'2017-06-01',54895,244,'Troca de óleo'),(268,4,9,44,1,'2017-06-01',NULL,NULL,'Lavação de aparência'),(269,4,9,22,15,'2017-06-02',NULL,NULL,'LAVAÇÃO'),(270,4,9,8,9,'2017-06-10',0,20,'Lavação'),(271,4,9,27,13,'2017-06-13',NULL,NULL,'Lavação'),(272,1,22,27,14,'2017-06-13',0,452,NULL),(273,5,15,4,12,'2017-06-13',91491,70,'Geometria, balanceamento e rodízio'),(274,2,15,19,18,'2017-06-16',89299,540,'Troca dos pneus traseiros'),(275,4,9,18,10,'2017-06-16',42418,20,'Lavação'),(276,4,9,4,12,'2017-06-17',90864,20,'LAVACAO'),(277,4,9,7,16,'2017-06-17',45522,20,NULL),(278,3,15,4,12,'2017-06-19',NULL,100,'Conserto de pneu'),(279,5,22,27,13,'2017-06-20',75554,396,'Manutenção nos freios'),(280,4,9,22,29,'2017-06-20',NULL,NULL,'Lavação'),(281,4,9,46,29,'2017-06-20',NULL,NULL,'Lavação'),(282,4,9,44,29,'2017-06-20',0,0,'Lavação'),(283,5,22,27,13,'2017-06-22',0,0,'Manutenção nos canos da direção hidráulica'),(284,5,22,44,2,'2017-06-22',NULL,NULL,'Verificar Cardan e efetuar troca de Óleo.'),(285,3,15,12,19,'2017-06-23',52068,50,'CONSERTO DE PNEUS'),(286,4,9,25,8,'2017-06-23',53957,20,'lavacao'),(287,5,17,27,13,'2017-06-29',76550,40,'trocar lampada'),(288,5,1,12,19,'2017-07-01',52504,0,'Manutenção no escapamento e no disco de freio'),(289,4,9,22,29,'2017-07-03',NULL,NULL,'Lavação'),(290,5,1,4,12,'2017-07-04',92204,60,'Troca do jogo de pastilhas e disco de freio'),(291,1,12,4,12,'2017-07-04',90470,113,'troca de oleo'),(292,4,9,4,12,'2017-07-05',NULL,20,'Lavação'),(293,1,12,25,14,'2017-07-06',55303,138,'Troca de óleo'),(294,5,15,18,10,'2017-07-12',43604,70,'Rodízio de pneus, alinhamento e balanceamento'),(295,5,18,23,1,'2017-07-12',NULL,NULL,'Retirar reboque'),(296,5,1,48,1,'2017-07-12',NULL,NULL,'Revisão'),(297,5,1,49,1,'2017-07-13',NULL,NULL,'Revisão'),(298,5,1,51,1,'2017-07-15',NULL,NULL,'Revisão'),(299,5,1,50,1,'2017-07-15',NULL,NULL,'Revisão'),(300,5,13,49,1,'2017-07-14',88610,370,'Instalar suporte de escada'),(301,5,20,49,1,'2017-07-14',NULL,NULL,'Colocar adesivos Clic'),(302,4,9,12,19,'2017-07-15',NULL,NULL,'Lavação'),(303,2,15,48,1,'2017-07-14',NULL,NULL,'Troca de 2 pneus'),(304,5,18,18,10,'2017-07-17',NULL,NULL,'arrumar a busina e a luz do Air beg'),(305,5,20,49,1,'2017-07-19',NULL,NULL,'Colocar adesivos Clic Rápido'),(306,5,1,12,19,'2017-07-20',NULL,NULL,'verificar vazamento de oleo'),(307,5,29,7,16,'2017-07-22',NULL,NULL,'troca de pastilha de freio'),(308,4,9,15,7,'2017-07-22',NULL,NULL,NULL),(309,5,17,8,9,'2017-07-25',NULL,NULL,'troca da chave'),(310,5,13,51,1,'2017-06-27',NULL,NULL,'Colocar Suporte de Escada'),(311,5,1,8,9,'2017-07-28',NULL,NULL,'Troca de catalizador'),(312,1,12,14,15,'2017-07-29',NULL,NULL,'Troca de óleo'),(313,4,9,4,12,'2017-07-29',NULL,NULL,'Lavação'),(315,2,15,14,15,'2017-07-31',NULL,NULL,'Troca dos pneus dianteiros'),(316,5,14,7,16,'2017-08-01',NULL,NULL,'troca de lâmpadas'),(317,5,15,44,13,'2017-08-01',NULL,NULL,'Balanceamento e geometria'),(318,5,17,27,13,'2017-08-03',NULL,NULL,'Verificar luz da placa e luz interna'),(319,5,14,27,14,'2017-08-08',NULL,NULL,'Arrumar as lâmpada'),(320,5,15,19,18,'2017-08-09',NULL,NULL,'Rodízio de pneus'),(321,4,9,19,18,'2017-08-09',NULL,NULL,'Lavação'),(322,4,9,29,25,'2017-08-11',NULL,NULL,'Lavação'),(323,4,9,22,29,'2017-08-11',NULL,NULL,'Lavação'),(324,4,9,8,9,'2017-08-12',NULL,NULL,'Lavação'),(325,4,9,14,15,'2017-08-12',NULL,NULL,'Lavação'),(326,4,9,7,16,'2017-08-12',NULL,NULL,NULL),(327,2,15,4,12,'2017-08-14',NULL,NULL,'Montagem de 2 pneus dianteiros, balanceamento e alinhamento'),(328,1,12,29,24,'2017-08-23',NULL,NULL,'Troca de Oleo'),(330,5,13,50,2,'2017-08-23',NULL,NULL,'Colocar suporte'),(331,5,22,44,2,'2017-08-23',NULL,NULL,'Verificar vazamento de água.'),(332,1,22,27,13,'2017-08-25',NULL,NULL,'Troca de óleo'),(333,5,17,27,13,'2017-08-25',NULL,NULL,'Troca de lâmpada'),(334,4,9,4,12,'2017-08-26',NULL,NULL,'Lavação'),(335,5,1,12,19,'2017-08-28',NULL,NULL,NULL),(336,5,34,13,1,'2017-08-28',NULL,973,'Verificar vazamento de óleo,'),(337,5,14,19,18,'2017-08-30',NULL,NULL,'TROCAR LÂMPADA DO FAROL'),(338,4,9,18,10,'2017-09-01',47400,20,'Lavação'),(339,4,9,22,29,'2017-09-01',NULL,NULL,'LAVAÇÃO'),(340,1,12,15,7,'2017-09-11',62335,197,'Troca de óleo'),(341,5,15,18,10,'2017-09-11',48038,60,'Revisão do alinhamento e balanceamento'),(342,4,9,22,29,'2017-09-11',NULL,NULL,NULL),(343,1,12,19,18,'2017-09-12',NULL,NULL,'Troca de oleo'),(345,1,12,12,19,'2017-09-15',55871,116,'Troca de óleo'),(346,5,34,19,18,'2017-09-18',NULL,72,'Trocar vareta do óleo'),(347,2,15,17,11,'2017-09-18',46876,0,'conserto de pneu / notinha veio valor 0,00'),(348,3,21,8,9,'2017-09-18',66681,45,'Conserto de pneu'),(349,5,34,52,1,'2017-09-18',0,121,'Conserto do reservatório de água'),(351,4,9,6,1,'2017-09-19',NULL,NULL,'Lavação Ranger do Plínio'),(352,5,34,12,19,'2017-09-19',55956,NULL,'Manutenção da luz da injeção'),(353,4,9,7,16,'2017-09-19',NULL,20,'Lavação'),(354,5,13,52,18,'2017-09-21',NULL,NULL,'Instalar suporte para escadas'),(355,4,9,22,29,'2017-09-22',NULL,NULL,'Lavação'),(357,5,34,44,1,'2017-09-23',NULL,381,'Troca de óleo'),(358,5,34,17,1,'2017-09-23',NULL,388,'Verificar Freios Dianteiros'),(359,5,34,4,1,'2017-09-23',NULL,40,'Verificar freios traseiros, buchas e pivôs'),(360,5,34,25,1,'2017-09-25',NULL,10,'Verificar embreagem.'),(361,5,34,53,32,'2017-09-25',0,197,'Revisão'),(362,4,9,25,8,'2017-09-25',62144,20,'Lavação'),(363,4,9,13,8,'2017-09-25',125149,20,'Lavação'),(364,4,9,22,1,'2017-09-25',NULL,NULL,'Lavação carro Cartney'),(365,5,15,53,32,'2017-09-25',29434,20,'Geometria e balanceamento'),(366,5,14,52,18,'2017-09-25',NULL,150,'Iluminação da Fiorino'),(367,2,15,18,32,'2017-09-26',49359,380,'Troca de 2 pneus'),(368,5,34,19,32,'2017-09-26',NULL,20,'problema no retrovisor'),(369,1,12,17,11,'2017-09-26',NULL,NULL,'Troca de Oleo'),(370,2,15,7,16,'2017-09-20',49900,196,'Troca de Terminal e Barra da suspensão dianteira'),(371,5,14,25,1,'2017-09-27',NULL,NULL,'Troca das lâmpadas'),(372,5,34,15,32,'2017-09-28',NULL,2156,'Conserto de cabeçote e correia dentada'),(373,4,9,12,19,'2017-09-30',56354,20,'lavação'),(374,5,34,17,11,'2017-10-02',47294,452,'Troca da correia dentada; troca de oleo e filtro'),(375,3,21,15,7,'2017-10-02',62799,15,'Conserto de pneu'),(376,4,9,22,29,'2017-10-02',NULL,NULL,'Lavação'),(377,5,34,54,32,'2017-10-03',NULL,474,'REVISÃO'),(378,2,15,50,14,'2017-10-04',62561,60,'Alinhamento, Balancemaneto, Geometria'),(379,5,18,14,15,'2017-10-06',97909,NULL,'Troca de palhetas'),(380,3,15,14,15,'2017-10-06',97904,0,'Conserto de pneu'),(381,5,34,4,32,'2017-10-10',NULL,220,'Revisao'),(382,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(383,4,9,22,29,'2017-10-10',NULL,NULL,NULL),(384,4,9,14,21,'2017-10-14',98134,20,'lavação'),(385,5,34,17,11,'2017-10-16',NULL,NULL,'Verificar Cubo.'),(386,4,9,8,9,'2017-10-17',NULL,20,'lavação'),(387,4,9,50,14,'2017-10-18',NULL,NULL,'lavação'),(389,5,14,44,2,'2017-10-19',NULL,NULL,'CONSERTO DE VIDRO ELETRICO'),(392,2,15,12,19,'2017-10-21',57214,380,'Troca dos 2 pneus traseiros'),(393,4,9,17,20,'2017-10-21',49076,20,'Lavação'),(394,2,15,18,10,'2017-10-21',51552,380,'Troca dos 2 pneus dianteiros'),(395,2,15,34,32,'2017-10-23',81120,400,'trocado 2 pneus e feito geometria'),(396,5,34,34,32,'2017-10-23',NULL,2.991,'Manutenção do carro. '),(397,1,12,18,10,'2017-10-25',51850,116,'Troca de óleo'),(398,4,9,15,7,'2017-10-26',63615,20,'Lavação'),(399,3,21,14,15,'2017-10-27',NULL,45,'Conserto de pneu'),(400,4,9,12,19,'2017-10-28',57613,20,'lavação'),(401,4,9,52,18,'2017-11-01',66811,20,NULL),(402,4,9,22,29,'2017-11-03',NULL,NULL,'lavação'),(403,5,17,18,10,'2017-11-06',NULL,NULL,NULL),(404,5,17,18,10,'2017-11-06',53159,45,'Troca de lampada do farol'),(405,2,15,15,7,'2017-11-09',64189,490,'Troca de 2 Pneus'),(406,3,15,18,10,'2017-11-13',53853,50,'Vulcanização de pneu'),(407,2,15,17,11,'2017-11-13',50969,380,'troca de 2 pneus'),(408,2,15,17,11,'2017-11-14',51202,400,'Trocar dois pneus dianteiros.'),(409,4,9,50,13,'2017-11-14',NULL,NULL,NULL),(410,3,15,17,11,'2017-11-20',51909,50,'Conserto de pneu'),(411,2,15,50,14,'2017-11-22',NULL,NULL,'Trocar pneus'),(412,5,17,17,11,'2017-11-23',NULL,NULL,'Trocar 1 lampada farol'),(414,5,34,34,13,'2017-11-24',81814,261,'VAZAMENTO DE OLEO, MAQUINA DE VIDRO, LIMPADOR DE VIDRO.'),(416,5,34,34,13,'2017-11-24',NULL,NULL,'VAZAMENTO DE OLEO, MAQUINA DE VIDRO, LIMPADOR DE VIDRO.'),(417,4,9,12,9,'2017-11-25',58550,NULL,'lavagem de carro'),(418,5,34,17,11,'2017-11-25',52255,779,'VERIFICAR SUSPENSAO TRASEIRA E ROLAMENTO DIANTEIRO'),(419,5,34,44,2,'2017-11-28',NULL,767,'Troca de disco e pastilhas de freio.'),(420,5,34,29,24,'2017-11-28',NULL,20,'Trocar Retrovisor e Farol'),(421,2,15,20,1,'2017-11-29',NULL,NULL,'Troca dos pneus da carretinha'),(422,4,9,22,29,'2017-11-29',NULL,NULL,'Lavação'),(423,4,9,13,1,'2017-11-29',NULL,NULL,'Lavação'),(424,1,12,7,16,'2017-11-30',52459,171.5,'Troca de óleo'),(425,5,34,18,10,'2017-11-30',55482,80,'Arrumar junta do escapamento'),(426,4,9,17,11,'2017-12-01',NULL,NULL,NULL),(427,4,9,44,6,'2017-12-02',NULL,NULL,'Lavação'),(428,3,15,7,16,'2017-12-05',NULL,0,'Conserto de pneu'),(429,4,9,7,16,NULL,NULL,NULL,'Lavação'),(430,4,9,7,16,'2017-12-05',52754,NULL,'Lavação'),(431,3,21,8,9,NULL,NULL,NULL,'Conserto de pneu'),(432,3,21,8,9,'2017-12-05',68925,15,'conserto de pneu'),(433,5,34,15,7,'2017-12-07',65700,132,'Troca de lâmpada e verificação do Alternador'),(434,5,14,50,14,'2017-12-08',NULL,NULL,'Conserto de lâmpada'),(436,4,9,14,15,'2017-12-09',NULL,NULL,'LAVAÇÃO'),(437,4,9,18,10,'2017-12-09',56275,25,'Lavação'),(438,5,34,17,11,'2017-12-11',NULL,202,'Verificar caixa de marcha.'),(439,2,15,25,8,'2017-12-12',66791,590,'Troca de 2 pneus dianteiros'),(440,5,34,44,1,'2017-12-12',NULL,2137,'Problema com embreagem (kit emgreagem, rolamento)'),(441,4,9,19,18,NULL,NULL,NULL,NULL),(442,4,9,19,18,'2017-12-16',NULL,25,'Lavação'),(443,4,9,8,9,'2017-12-16',69310,25,'Lavação'),(444,4,9,22,29,'2017-12-15',NULL,NULL,'Lavação'),(445,5,34,17,11,'2017-12-18',54165,36,'Verificar filtro de combustível'),(446,5,14,44,6,'2017-12-18',NULL,NULL,'Arrumar farol e pisca'),(447,2,15,19,18,'2017-12-19',100746,520,'Troca de dois pneus'),(448,3,15,17,20,'2017-12-20',54377,NULL,'Conserto de pneu'),(449,4,9,29,25,'2017-12-20',63615,20,'Lavação'),(450,2,15,50,3,'2017-12-22',73251,380,'Troca de 2 pneus'),(451,4,9,17,20,'2017-12-23',NULL,25,'Lavação'),(452,5,34,14,15,'2017-12-22',NULL,906,'Manutenção na embreagem'),(453,3,21,25,15,'2017-12-22',NULL,NULL,'Conserto de pneu'),(454,5,34,50,32,'2017-12-26',NULL,1651,'Conserto'),(455,3,15,50,32,'2017-12-26',73501,20,'Geometria'),(456,5,34,19,32,'2017-12-26',101039,1475,'Revisão e troca da correia dentada'),(457,4,9,19,9,'2017-12-30',69831,25,'lavagem de carro'),(458,4,9,7,9,'2018-01-02',53869,25,'Lavação'),(459,5,24,8,9,'2018-01-02',69833,0,'Arrumar banco'),(460,5,13,53,1,'2018-01-02',NULL,NULL,'Suporte para fixação de cadeado'),(461,5,34,12,19,'2018-01-02',59940,157,'Verificar injeção e catalizador'),(462,5,34,7,16,'2018-01-03',NULL,774,'Revisão'),(463,1,34,44,1,'2018-01-04',NULL,1198,'Troca de óleo'),(464,5,34,25,1,'2018-01-04',NULL,397,'Troca de óleo; Verificar água do radiador que parece estar suja'),(465,1,12,8,9,'2018-01-08',70030,209,'Troca de óleo'),(467,4,NULL,18,10,'2018-01-05',NULL,NULL,NULL),(468,4,9,17,20,'2018-01-06',NULL,NULL,NULL),(469,2,15,44,32,'2018-01-08',NULL,NULL,'Troca de pneus'),(470,5,34,34,32,'2018-01-08',NULL,537,'Conserto'),(471,4,9,50,3,'2018-01-08',NULL,NULL,'Lavação'),(472,2,15,17,11,'2018-01-09',NULL,NULL,'Troca de 2 pneus '),(473,4,9,44,6,'2018-01-11',NULL,NULL,'Lavação'),(475,5,34,17,32,'2018-01-12',56410,630,'Trocar parachoque'),(476,5,31,44,6,'2018-01-13',NULL,NULL,'Vidros não sobem'),(477,3,15,17,11,'2018-01-18',NULL,NULL,'Geometria'),(480,5,17,15,8,'2018-01-19',NULL,15,'Trocar bateria'),(481,4,9,19,18,'2018-01-20',NULL,25,NULL),(482,5,17,19,18,'2018-01-22',NULL,210,'Troca de bateria'),(483,4,9,15,7,'2018-01-22',67936,20,'Lavação'),(484,5,17,15,7,'2018-01-22',NULL,40,'Troca de lâmpada'),(486,3,15,18,10,'2018-01-26',59423,50,'Vulcanização'),(487,4,9,22,29,'2018-01-26',NULL,NULL,NULL),(488,5,17,18,10,'2018-01-26',59430,40,'TROCAR LAMPADA'),(489,4,9,7,16,'2018-01-27',NULL,25,'Lavação'),(490,4,9,18,10,'2018-01-29',59509,20,'LAVAGEM DO CARRO'),(491,1,34,14,15,'2018-01-29',NULL,357,'TROCA DE ÓLEO'),(492,2,15,50,3,'2018-01-30',NULL,NULL,NULL),(493,5,17,12,19,'2018-01-31',NULL,NULL,'Trocar lâmpada do farol'),(494,5,15,19,18,'2018-02-02',NULL,NULL,NULL),(495,5,15,19,18,'2018-02-02',NULL,NULL,NULL),(496,2,15,7,16,'2018-02-08',56663,560,'Troca de 2 pneus'),(497,1,12,17,11,'2018-02-09',NULL,NULL,'Efetuar troca de oleo'),(498,5,34,17,11,'2018-02-09',NULL,748,'Verificar Suspensao Dianteira'),(499,3,21,15,7,'2018-02-09',69180,45,'VULCANIZAÇAO DE PNEU'),(500,4,9,7,16,'2018-02-10',NULL,NULL,'25,00'),(501,3,21,13,37,'2018-02-10',NULL,45,'CONCERTO DE PNEU'),(502,4,9,50,1,'2018-02-12',NULL,NULL,NULL),(503,4,9,18,1,'2018-02-12',NULL,NULL,NULL),(504,4,9,25,1,'2018-02-12',NULL,NULL,NULL),(505,2,15,8,9,'2018-02-19',71763,NULL,'Troca de pneus'),(506,4,9,8,9,'2018-02-17',NULL,NULL,'25,00'),(507,4,9,22,9,'2018-02-19',NULL,NULL,'25,00'),(508,5,17,12,19,'2018-02-23',NULL,40,'Trocar a lampada '),(509,5,34,12,19,'2018-02-23',NULL,137,'Verificar freio'),(510,1,12,17,11,'2018-02-24',NULL,156,'Troca de Óleo'),(511,2,15,17,11,'2018-02-24',NULL,420,'Troca de dois pneus'),(512,4,9,17,11,'2018-02-24',NULL,NULL,'Lavagem do carro!'),(513,4,9,22,29,'2018-02-24',NULL,25,NULL),(514,5,34,18,20,'2018-02-26',NULL,150,'Troca de tanque de combustível '),(515,5,14,44,2,'2018-02-27',98915,78.9,'troca de palhetas e orbi aditivado - posto bertamoni (TAISON esta pra nao dar erro)'),(516,2,15,12,19,'2018-03-01',NULL,420,'trocado 2 pneus '),(517,4,9,13,37,'2018-03-03',NULL,25,NULL),(518,4,9,14,21,'2018-03-03',102896,25,NULL),(519,4,9,8,9,'2018-03-03',NULL,NULL,NULL),(520,5,17,44,2,'2018-03-05',NULL,184,'CONCERTO DE LANTERNAS DA CARRETINHA '),(521,3,15,19,18,'2018-03-05',105603,0,'CONCERTO DE RODA'),(522,5,34,50,13,'2018-03-05',NULL,616,'Verificar Caixa de Marcha'),(523,5,34,13,37,'2018-03-06',NULL,662,'Verificar calço do motor.'),(524,2,15,19,18,'2018-03-08',NULL,NULL,'Troca de dois pneus!'),(525,5,34,17,11,'2018-03-07',60901,20,'Troca de Pastilhas de freio!'),(526,4,9,22,29,'2018-03-09',NULL,NULL,NULL),(527,4,9,12,19,'2018-03-09',NULL,NULL,NULL),(528,4,9,44,6,'2018-03-10',NULL,NULL,NULL),(529,5,34,14,21,'2018-03-12',NULL,25,'Repor o Óleo'),(530,5,14,14,21,'2018-03-13',NULL,40,'conserto de pneu'),(531,1,12,18,10,'2018-03-14',62355,160,'troca de oleo motor'),(532,1,12,15,7,'2018-03-14',71185,252,'trocado oleo do motor'),(533,1,12,19,18,'2018-03-14',106276,240,'trocado oleo do motor'),(534,5,17,15,7,'2018-03-14',71200,210,'Efetuar a troca da bateria'),(535,5,18,51,15,'2018-03-14',NULL,NULL,'Trocar Lampada Dianteira Esquerda e borrachas da porta.'),(536,4,9,51,15,'2018-03-17',NULL,NULL,NULL),(537,5,34,50,15,'2018-03-20',NULL,45,'serviço coxim do motor'),(538,2,15,14,21,'2018-03-21',103825,NULL,'590,00'),(539,3,21,7,13,'2018-03-21',NULL,NULL,'Conserto de 2 pneus'),(540,4,9,7,12,'2018-03-24',NULL,NULL,NULL),(541,4,9,19,7,'2018-03-24',NULL,NULL,NULL),(542,2,15,51,15,'2018-03-26',NULL,768,'GEOMETRIA /motor de partida / coxim etc'),(543,4,9,18,10,'2018-03-26',63099,25,'lavação'),(544,5,34,50,15,'2018-03-26',NULL,370,'Trocado bateria e ajustado marcha'),(545,5,15,50,15,'2018-03-28',81980,60,'GEOMETRIA E BALANCEAMENTO'),(546,5,34,15,7,'2018-03-28',NULL,480,'verificar calço de motor e terminal.'),(547,4,9,7,13,'2018-04-05',NULL,NULL,NULL),(548,5,17,18,10,'2018-04-07',68132,3,'3 lampadas'),(549,4,9,12,19,'2018-04-07',NULL,NULL,NULL),(550,5,15,13,37,'2018-04-12',NULL,290,NULL),(551,4,9,50,15,'2018-04-14',NULL,NULL,NULL),(552,3,34,8,9,'2018-04-14',NULL,240,'coxim + sv'),(553,3,15,18,10,'2018-04-16',NULL,90,'troca do tanque de combustivel + mdo'),(554,5,34,7,16,'2018-04-16',NULL,374.76,'Verificar embreagem'),(555,5,34,18,10,'2018-04-16',64579,840,'Verificar Tanque e levantar Suspensao! trocado 4 pneus / feito geometria'),(556,5,17,29,36,'2018-04-16',NULL,NULL,NULL),(557,4,9,18,10,'2018-04-20',54143,25,'lavagem de carro'),(558,5,34,14,21,'2018-04-23',105298,100,'maquina de vidro'),(559,5,34,44,16,'2018-04-25',NULL,NULL,'Troca de Oleo e verificar cardâ.'),(560,2,15,44,16,'2018-04-25',NULL,NULL,'Rodizio'),(561,4,9,22,29,'2018-04-26',NULL,NULL,NULL),(562,4,9,44,16,'2018-04-26',NULL,NULL,NULL),(563,4,9,15,7,'2018-04-27',74108,NULL,NULL),(564,4,9,14,21,'2018-04-28',105424,NULL,NULL),(565,3,21,19,18,'2018-04-30',NULL,45,'vulcanização'),(566,5,34,13,37,'2018-04-30',NULL,173,'Verificar falha no motor'),(567,5,34,7,37,'2018-05-04',NULL,NULL,'Verificar pane Eletrica'),(568,4,9,50,15,'2018-05-05',NULL,NULL,NULL),(569,4,9,8,9,'2018-05-05',74689,NULL,NULL),(570,3,21,12,19,'2018-05-07',NULL,NULL,NULL),(571,5,34,58,1,'2018-05-07',NULL,486,NULL),(572,3,15,14,21,'2018-05-07',105770,337,NULL),(573,5,34,50,15,'2018-05-08',NULL,555,'Verificar proteção de motor; Manivela do vidro lateral;  '),(574,5,12,50,15,NULL,NULL,NULL,'Troca de Óleo'),(575,5,12,50,15,'2018-05-08',NULL,NULL,'Troca de Óleo'),(576,5,15,50,15,'2018-05-08',85470,NULL,'Trocar pneus, balanceamento e geometria'),(577,3,21,7,15,'2018-05-09',NULL,NULL,NULL),(578,3,15,15,7,'2018-05-10',NULL,NULL,'Geometria e Balanceamento, e Concerto de Pneus'),(579,5,17,54,12,'2018-05-11',NULL,210,'TROCA DE BATERIA '),(580,5,34,15,7,'2018-05-11',NULL,NULL,NULL),(581,5,15,15,7,'2018-05-12',NULL,NULL,NULL),(582,4,9,19,18,'2018-05-14',NULL,NULL,NULL),(583,3,21,18,10,'2018-05-15',69055,167.9,NULL),(584,5,34,44,13,'2018-05-21',NULL,597,'Manutenção na tração 4x4'),(585,5,17,14,21,'2018-05-21',106395,210,NULL),(586,5,15,44,1,'2018-05-24',108631,50,'balanceamento e geometria'),(587,5,34,44,1,'2018-05-23',NULL,NULL,'Verificar tração'),(588,5,34,15,1,'2018-05-23',NULL,NULL,'Verificar suspensão e direção'),(589,4,9,13,37,'2018-05-25',NULL,NULL,NULL),(590,4,9,25,2,'2018-05-26',NULL,NULL,NULL),(591,1,12,12,19,'2018-05-26',65629,193,NULL),(592,1,12,14,21,'2018-05-28',106811,29,'Troca de óleo'),(593,2,15,44,16,NULL,NULL,NULL,NULL),(594,2,15,44,16,'2018-06-05',NULL,NULL,NULL),(595,2,15,17,11,'2018-06-05',65580,460,NULL),(596,5,12,25,1,'2018-06-08',80326,141,NULL),(597,3,21,12,19,'2018-06-11',NULL,45,'vulcanização'),(598,5,34,12,19,'2018-06-11',NULL,NULL,NULL),(599,5,34,19,18,'2018-06-13',111424,50,'manutenção'),(600,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(601,5,14,7,17,'2018-06-14',NULL,NULL,NULL),(602,4,9,50,15,'2018-06-16',NULL,NULL,NULL),(603,4,9,18,10,'2018-06-19',NULL,NULL,NULL);

--
-- Table structure for table `tipofornecedor`
--

CREATE TABLE `tipofornecedor` (
  `id_tipofornecedor` int(10) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_tipofornecedor`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipofornecedor`
--

INSERT INTO `tipofornecedor` VALUES (1,'Combustível'),(2,'Peças'),(3,'Serviços'),(4,'Outros');

--
-- Table structure for table `tiposervico`
--

CREATE TABLE `tiposervico` (
  `id_tiposervico` int(10) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_tiposervico`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiposervico`
--

INSERT INTO `tiposervico` VALUES (1,'Lubrificação'),(2,'Troca de Pneus'),(3,'Conserto Pneus'),(4,'Lavagem'),(5,'Mecânica');

--
-- Table structure for table `veiculo`
--

CREATE TABLE `veiculo` (
  `id_veiculo` int(10) NOT NULL AUTO_INCREMENT,
  `marca` varchar(30) DEFAULT NULL,
  `modelo` varchar(30) DEFAULT NULL,
  `motor` varchar(30) DEFAULT NULL,
  `ano_modelo` char(9) DEFAULT NULL,
  `placa` varchar(30) DEFAULT NULL,
  `cidade` varchar(50) DEFAULT NULL,
  `renavam` varchar(255) DEFAULT NULL,
  `kminicial` int(10) DEFAULT NULL,
  PRIMARY KEY (`id_veiculo`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `veiculo`
--

INSERT INTO `veiculo` VALUES (4,'FIAT','UNO','1.0','2014/2014','MMF 4412','SÃO MIGUEL DO OESTE','996293671',3548),(6,'CERAÇÁ','GERADOR',NULL,NULL,NULL,'SÃO MIGUEL DO OESTE',NULL,NULL),(7,'CHEVROLET','MONTANA','1.4','2014/2014','MKU 2053','SÃO MIGUEL DO OESTE','999806904',18941),(8,'FIAT ','UNO','1.0','2014/2014','AYQ 4064','SÃO MIGUEL DO OESTE','01195130012',57096),(9,'FIAT','UNO','1.0','2014/2014','AYT 7703','SÃO MIGUEL DO OESTE','01017836555',21450),(10,'FIAT','UNO','1.0','2013/2013','MLB 3664','SÃO MIGUEL DO OESTE','548951039',144894),(12,'FIAT','PALIO','1.0','2014/2015','MLZ 6416','SÃO MIGUEL DO OESTE','1045038986',6741),(13,'VOLKSWAGEN','GOL','1.6','2012/2013','AVH 7276','SÃO MIGUEL DO OESTE','463341899',58154),(14,'FIAT','STRADA','1.4','2012/2013','MKZ 2938','SÃO MIGUEL DO OESTE','504015010',5176),(15,'RENAULT','KANGOO','1.6','2013/2014','MLG 2760','SÃO MIGUEL DO OESTE','599774703',5478),(16,'CHEVROLET','MONTANA','1.4','2012/2012','MIM 5378','SÃO MIGUEL DO OESTE','370470176',5792),(17,'FIAT','UNO','1.0','2013/2013','AXO 6128','SAO MIGUEL DO OESTE','587540346',30),(18,'FIAT','PALIO','1.0','2014/2015','OKF 4159','SÃO MIGUEL DO OESTE','1031724971',5479),(19,'RENAULT','KANGOO','1.6','2012/2013','MJZ 8255','SÃO MIGUEL DO OESTE','479580529',35885),(20,'VINCENZI','CARRETINHA',NULL,'2012/2012',NULL,'SÃO MIGUEL DO OESTE',NULL,94879),(22,'FIAT','STRADA','1.4',NULL,'VANDOIR','SÃO MIGUEL DO OESTE',NULL,5782),(23,'TOYOTA','SW4',NULL,NULL,'MAGNOS','SÃO MIGUEL DO OESTE',NULL,3571),(24,'HONDA','BIZ 100','100','2015/2015','QHS 7953','SÃO MIGUEL DO OESTE','1052912742',357),(25,'FIAT','STRADA','1.4','2015/2016','PWN 2588','SAO MIGUEL DOESTE','01060048148',7359),(26,'FIAT','UNO','1.0',NULL,'AYT 9415','IJUI','01018228095',3571),(27,'FORD','RANGER XL','3.0','2011/2011','HCR 6125','SÃO MIGUEL DO OESTE','00345225066',3695),(28,'FIAT','UNO','1.0','2014/2015','FKN 5559','IJUI','01034331881',6597),(29,'FIAT','PALIO','1.6','2013/2014','AXV 8962','SAO MIGUEL DO OESTE','00599605596',3568),(30,'FIAT','UNO','1.0',NULL,'AYS 4034','IJUI','341972',305),(31,'FIAT','UNO','1.0','2013/2013','AXW 2628','SÃO JOSÉ DO CEDRO',NULL,368),(32,'FIAT','UNO','1.0','2013/2013','AWV 1371','SÃO JOSÉ DO CEDRO',NULL,4825),(33,'VOLKSWAGEN','GOL','1.0','2013/2014','MKG 1764','SÃO JOSÉ DO CEDRO',NULL,15789),(34,'FIAT','UNO','1.0','2012/2012','AVW 3567','DIONÍSIO CERQUEIRA',NULL,8513),(35,'FIAT','UNO','1.0','2014/2014','MCU 8912 ','DIONÍSIO CERQUEIRA',NULL,5349),(36,'CHEVROLET','MONTANA','1.4','2014/2014','MLY 9397','DIONÍSIO CERQUEIRA',NULL,1967),(37,'CHEVROLET','MONTANA','1.4','2014/2015','OKH 4227','IJUI',NULL,2687),(38,'FIAT','FIORINO','1.4','2014/2015','MLP 2519','IJUI',NULL,3259),(39,'FIAT','UNO','1.0','2012/2013','AVW 4057','IJUI',NULL,4127),(40,'FORD','FIESTA','1.0','2013/2014','MKS 0074','IJUI',NULL,84952),(41,'FIAT','UNO','1.0','2015/2016','QHF 0245','IJUI',NULL,92038),(42,'YAMAHA','YBR',NULL,NULL,'MKS 9302','IJUI',NULL,3497),(43,'FIAT','FIORINO','1.4','2013/2013','AXT 4370','SANTO ANGELO',NULL,35971),(44,'FORD','RANGER XL','3.0','2011/2011','HBN 6126','SÃO MIGUEL DO OESTE','00343632349',1843),(45,'FIAT','FIORINO','1.4','2014/2014','AYD 7034','SÃO MIGUEL DO OESTE','00998977829\'',NULL),(46,NULL,'MOTOSSERRA',NULL,NULL,NULL,NULL,NULL,NULL),(47,'LG REBOQUES','REBOQUE',NULL,'2017','QIJ5114','IJUI','1118186947',NULL),(48,'VOLKSWAGEN','SAVEIRO','1.6','2014/2015','FSL 9347','IJUI','01027057613',56663),(49,'FIAT','FIORINO','1.4','2014/2014','OXJ 6167','IJUI','01007458566',NULL),(50,'FIAT','UNO','1.0','2014/2014','AYL 3829','IJUI','01011344332',NULL),(51,'FIAT','UNO','1.0','2014/2014','AYL 0695','IJUI','01011373278',NULL),(52,'FIAT','FIORINO','1.4 FLEX','2014/2015','PUV 7706','SAO MIGUEL DO OESTE','01022220745',32842),(53,'FIAT','STRADA WORKING','1.4','2013/2013','FLO 6050','SAO MIGUEL DO OESTE','00569129664',NULL),(54,'VOLKSWAGEN','SAVEIRO ','1.6','2014/2015','PVA 9454','SAO MIGUEL DO OESTE','01026464029',6482),(56,'FIAT','FIORINO',NULL,NULL,'MIK 7953','SÃO MIGUEL DO OESTE',NULL,NULL),(57,'VOLKSWAGEN','POLO','1.6','2011','ATI 3986 (DIEGO)','CHAPECO','266394256',124600),(58,'VOLKSWAGEN','SAVEIRO',NULL,NULL,'PVA 1201',NULL,NULL,NULL);


