SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-313&title=red-dot-blade-lime-green-charcoal-gear-and-black-sear-cover-gtw-mach1-mach2'