SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-295p&title=reddot-blade-red-silver-black-carbon-fiber-gtw-and-genesis-150-rear-seat-cushions'