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