SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=65033&title=2013-up-ezgo-t48-red-dot-red-dot-door-max-black-soft-enclosure'