SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=6580&title=club-car-gas-carburetor-assembly-(fits-2005-up)'