SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-327&title=2004-up-club-car-precedent-red-dot-mocca-convoy-and-sandbar-blade-front-seat-cover'