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