SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=28352&title=club-car-precedent-diamond-plate-floor-(fits-2004-up)'