Still, I know I am going to miss this place and all of you.
— Col. Samantha Carter says goodbye to ten years of Stargate SG-1
All There in the Manual: Several deleted scenes explain the significance of Ronon's painting, which depicts a important historical battle on Sateda. It apparently used to hang in their War Museum and Ronon went back at some point after the events of "Sateda" and recovered it.
Berserk Button: If you thought the Wraith were this to Ronon, learning his former comrades in the Satedan military are now Wraith worshippers takes this and cranks it Up to Eleven!
Call-Back: Teal'c's "undomesticated equines" comment refers back to the SG-1 episode "Message in a Bottle." Carter hangs a lampshade on it, saying "Nice Call-Back."
Reality Subtext: It wasn't just Samantha Carter saying goodbye to SG-1, but Amanda Tapping as well. One can only imagine that Tapping's thought process was eerily similar to Carter's during that scene.
Stock Episode Titles: 197 uses, making it the single most common episode title after "Pilot," which hardly counts.
UST: Discussed. As usual, McKay is the only one who thinks this exists between him and Carter - but it's okay, because now he's seeing someone.