SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=2647&title=1979-89-yamaha-g1-2-cycle-stop-switch'