SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-330&title=2007-up-yamaha-g29-drive-drive-2-reddot-sandbar-blade-front-seat-cover'