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
Tropes:
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."
McKay: It's a selection of fruits from various worlds we trade with. I thought it would be thoughtful.
Sheppard: Try lame. then later, when the fruit basket turns up in Carter's quarters
Carter: Oh Colonel Sheppard dropped that off. Apparently it's a sampling of fruit from the home worlds of our various trading partners. I thought it was a really thoughtful gesture.
McKay: Son of a...
Kleptomaniac Hero: McKay. At the end of the episode, Teyla brings Ronon back his Satedan painting that Rodney apparently "appropriated" when he thought he was leaving for good.
Real Life Writes the Plot: Between episodes Jason Momoa got a tattoo on his left forearm...without informing the producers first. So for a few episodes they had to hide it from the audience. This episode includes a brief scene where Ronon gets tattooed so they wouldn't have to hide it anymore.
Required Spinoff Crossover: Teal'c's cameo makes him the last of the original SG-1 Main Cast to do an obligatory appearance on their spinoff show (and sets up a full crossover apperance for "Midway").
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.