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