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