SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-295&title=red-dot-blade-red-silver-and-black-rear-seat-cover-for-gtw-mach1-mach2'