SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=2042&title=2004-up-club-car-precedent-classic-accessories-4-passanger-khaki-soft-enclosure'