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