SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=09-077&title=2004-up-club-car-precedent-tempo-onward-buggies-unlimited-tinted-folding-windshield'