SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=31298&title=19945-up-ezgo-medalist-txt-red-dot-folding-windshield-hardware'