Couldn't find a VMDVMDID for Mitsubishi ENDEAVOR Modern using SELECT vmd.ID FROM VMDVehicleModels vm, VMDVehicleModelsDates vmd WHERE vmd.VehicleModelID=vm.ID AND vm.Make LIKE 'Mitsubishi' AND vm.Model LIKE 'ENDEAVOR' AND vm.Type LIKE 'Van' ORDER BY vmd.ID DESC LIMIT 0,1