SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=29303&title=club-car-ds-sheepskin-green-seat-cover-(fits-2000-up)'