SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=enc-3gray&title=club-car-ezgo-red-dot-3-sided-gray-over-the-top-soft-enclosure'