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