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