SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-coloradoyamdrdr2-p&title=madjax-colorado-front-seat-cushion-yamaha-drive-drive2'