Seeing his wife, Teyla, die at the hands of a Asrak killer in the SGC John leaves the military and goes on a life changing adventure, and lands 900,000 years into the future where he sees Teyla alive and well, with no memory of him, save for a dream.