SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=30707&title=camo-vinyl-seat-cover-set-club-car-precedent-04-up'