obtener la fecha mas reciente

[tokkaido]

Gracias scooby151 por responder tan pronto, pero lamentablemente no me da resultado tu modificacion, agrego un poco de datos para hacer el ejercicio a quien se tome la molestia:

Código MySQL:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for vehiculos
-- ----------------------------
DROP TABLE IF EXISTS `vehiculos`;
CREATE TABLE `vehiculos` (
  `id_interno` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `numero` varchar(3) COLLATE utf8_spanish_ci NOT NULL,
  `patente` varchar(7) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id_interno`),
  UNIQUE KEY `id_interno_idx` (`id_interno`) USING BTREE,
  UNIQUE KEY `numero_idx` (`numero`) USING BTREE,
  UNIQUE KEY `patente_idx` (`patente`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
 
-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `vehiculos` VALUES ('1', '27', 'EB95064');
INSERT INTO `vehiculos` VALUES ('2', '58', 'SU2124K');
INSERT INTO `vehiculos` VALUES ('4', '60', 'TB39596');
INSERT INTO `vehiculos` VALUES ('10', '61', 'TA45354');
INSERT INTO `vehiculos` VALUES ('11', '62', 'TJ97006');
INSERT INTO `vehiculos` VALUES ('12', '66', 'TV9895K');
INSERT INTO `vehiculos` VALUES ('95', '59', 'TB39588');
 

Código MySQL:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for neumaticos_inventario
-- ----------------------------
DROP TABLE IF EXISTS `neumaticos_inventario`;
CREATE TABLE `neumaticos_inventario` (
  `id_interno` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `codigo` smallint(11) unsigned DEFAULT NULL,
  `prof_ext_inicial` decimal(3,1) unsigned NOT NULL,
  `prof_med_inicial` decimal(3,1) unsigned NOT NULL,
  `prof_int_inicial` decimal(3,1) unsigned NOT NULL,
  `kms_inicial` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_interno`),
  UNIQUE KEY `id_interno_idx` (`id_interno`) USING BTREE,
  UNIQUE KEY `codigo_idx` (`codigo`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
 
-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `neumaticos_inventario` VALUES ('1', '3251', '15.0', '15.0', '15.0', '99120');
INSERT INTO `neumaticos_inventario` VALUES ('2', '3250', '15.0', '15.0', '15.0', '99120');
INSERT INTO `neumaticos_inventario` VALUES ('3', '3236', '15.0', '15.0', '15.0', '105438');
INSERT INTO `neumaticos_inventario` VALUES ('4', '3287', '15.0', '15.0', '15.0', '105438');
INSERT INTO `neumaticos_inventario` VALUES ('5', '3333', '15.0', '15.0', '15.0', '101000');
INSERT INTO `neumaticos_inventario` VALUES ('6', '3332', '15.0', '15.0', '15.0', '105438');
 

Código MySQL:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for neumaticos_vehiculos
-- ----------------------------
DROP TABLE IF EXISTS `neumaticos_vehiculos`;
CREATE TABLE `neumaticos_vehiculos` (
  `id_interno` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_neumatico` int(11) unsigned NOT NULL,
  `id_vehiculo` int(11) unsigned NOT NULL,
  `posicion` tinyint(6) unsigned NOT NULL,
  PRIMARY KEY (`id_interno`),
  UNIQUE KEY `id_interno` (`id_interno`) USING BTREE,
  UNIQUE KEY `id_neumatico` (`id_neumatico`),
  UNIQUE KEY `id_pos_veh` (`posicion`,`id_vehiculo`),
  KEY `id_vehiculo_idx` (`id_vehiculo`),
  CONSTRAINT `neumaticos_vehiculos_ibfk_1` FOREIGN KEY (`id_neumatico`) REFERENCES `neumaticos_inventario` (`id_interno`) ON UPDATE CASCADE,
  CONSTRAINT `id_neumatico_vehiculo_fk` FOREIGN KEY (`id_vehiculo`) REFERENCES `vehiculos` (`id_interno`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
 
-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `neumaticos_vehiculos` VALUES ('1', '1', '95', '1');
INSERT INTO `neumaticos_vehiculos` VALUES ('2', '2', '95', '2');
INSERT INTO `neumaticos_vehiculos` VALUES ('3', '3', '95', '3');
INSERT INTO `neumaticos_vehiculos` VALUES ('4', '4', '95', '4');
INSERT INTO `neumaticos_vehiculos` VALUES ('5', '5', '95', '5');
INSERT INTO `neumaticos_vehiculos` VALUES ('6', '6', '95', '6');
 

Código MySQL:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for neumaticos_historial
-- ----------------------------
DROP TABLE IF EXISTS `neumaticos_historial`;
CREATE TABLE `neumaticos_historial` (
  `id_interno` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_vehiculo` int(11) unsigned NOT NULL,
  `kms_vehiculo` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `posicion` smallint(6) NOT NULL,
  `id_neumatico` int(11) unsigned NOT NULL,
  `prof_ext` decimal(3,1) NOT NULL,
  `prof_med` decimal(3,1) NOT NULL,
  `prof_int` decimal(3,1) NOT NULL,
  `movimiento` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id_interno`),
  UNIQUE KEY `id_interno_idx` (`id_interno`),
  KEY `id_vehiculo_idx` (`id_vehiculo`),
  KEY `id_neumatico_idx` (`id_neumatico`),
  CONSTRAINT `neumaticos_historial_ibfk_1` FOREIGN KEY (`id_neumatico`) REFERENCES `neumaticos_inventario` (`id_interno`) ON UPDATE CASCADE,
  CONSTRAINT `neumaticos_historial_ibfk_2` FOREIGN KEY (`id_vehiculo`) REFERENCES `vehiculos` (`id_interno`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
 
-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `neumaticos_historial` VALUES ('1', '13', '10000', '2011-01-01', '1', '1', '15.0', '15.0', '15.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('2', '13', '20000', '2011-02-01', '1', '1', '14.0', '14.0', '14.0', 'cambio_saliente');
INSERT INTO `neumaticos_historial` VALUES ('3', '10', '40000', '2011-03-01', '3', '1', '14.0', '14.0', '14.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('4', '10', '70000', '2011-04-01', '3', '1', '10.0', '10.0', '10.0', 'cambio_saliente');
INSERT INTO `neumaticos_historial` VALUES ('5', '95', '50000', '2011-05-01', '1', '1', '10.0', '10.0', '10.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('6', '13', '12000', '2011-01-10', '2', '2', '15.0', '15.0', '15.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('7', '13', '20000', '2011-02-01', '2', '2', '14.0', '14.0', '14.0', 'cambio_saliente');
INSERT INTO `neumaticos_historial` VALUES ('8', '12', '40000', '2011-03-11', '4', '2', '14.0', '14.0', '13.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('9', '12', '50000', '2011-04-11', '4', '2', '11.0', '11.0', '12.0', 'cambio_saliente');
INSERT INTO `neumaticos_historial` VALUES ('10', '95', '50000', '2011-05-01', '2', '2', '11.0', '11.0', '12.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('11', '13', '10000', '2011-01-01', '3', '3', '15.0', '15.0', '15.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('12', '13', '20000', '2011-02-01', '3', '3', '14.0', '14.0', '14.0', 'cambio_saliente');
INSERT INTO `neumaticos_historial` VALUES ('13', '95', '50000', '2011-05-01', '3', '3', '14.0', '14.0', '14.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('14', '13', '10000', '2011-01-01', '4', '4', '15.0', '15.0', '15.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('15', '13', '20000', '2011-02-01', '4', '4', '13.0', '13.0', '13.0', 'cambio_saliente');
INSERT INTO `neumaticos_historial` VALUES ('16', '95', '50000', '2011-05-01', '4', '4', '13.0', '13.0', '13.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('17', '95', '50000', '2011-05-01', '4', '4', '15.0', '15.0', '15.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('18', '95', '50000', '2011-05-01', '5', '5', '15.0', '15.0', '15.0', 'cambio_entrante');
INSERT INTO `neumaticos_historial` VALUES ('19', '95', '50000', '2011-05-01', '6', '6', '15.0', '15.0', '15.0', 'cambio_entrante');