A strange ship is headed towards Earth, and the SGC suspects that Martin Lloyd and his companions may have something to do with it. O'Neill is sent to speak to Martin and is assigned as a military consultant on Martin's new show, "Wormhole X-Treme!", which uncannily resembles SG-1 despite Martin once again losing his memory. His former shipmates stall Carter and Daniel by throwing them off the trail and into the hands of the NID.

On a routine mission, SG-1 encounters a civilization desperate to be freed from the clutches of a Goa'uld. While on the planet, Jonas falls ill and is suspended from active duty. His mysterious illness is diagnosed as a brain tumor but gives him the unbelievable ability to glimpse the future, a future where O'Neill and SG-1 are walking into a trap!

Agent Barrett of the NID calls SG-1 to Los Angeles for a consult on a mass murdering of a rogue sleeper cell by a young woman. There they find many Goa'uld artifacts relating to Sekhmet, a subordinate of Ra. But how this operation is related to the Goa'uld eludes SG-1.

A man breaks into Jack's house and hold him at gunpoint claiming that Jack ruined his life. Seven years ago he came upon an Ancient artifact at a garage sale that allows him to see all of SG-1's missions.

Based on the information Vala gave them, SG-1 travels to the planet where Merlin may have hidden his secret weapon to defeat ascended beings. There they find an appropriately medieval village and learn that Merlin kept a library there. The locals have never been inside owing to a curse on anyone who dares enter, but SG-1 finds a way in. Once inside, they find a secret chamber that may reveal the location of the weapon. The SGC, meanwhile, has located the Ori's Supergate. Sam's attempt to get control of it is too late, and four Ori ships make their way through. In the ensuing battle, much of Earth's fleet is destroyed, and the future of several SGC members is left in doubt.

General Landry accompanies SG-1 on a mission to collect the knowledge of the Asgard. When the Ori show up, however, Sam is forced to evacuate the crew. Landry and SG-1 stay aboard, but are stuck helpless in a time dilation field for decades.