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