SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=31330&title=club-car-precedent-classic-enclosure-w-carrying-case-(fits-2004-up)'