SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-coloradoccprestemp-p&title=madjax-colorado-front-seat-cushions-for-club-car-precedent-and-tempo'