For SG-1’s 100th episode, it’s a comedy. Picking up a year after the events of “Point of No Return”, our heroes need to find the alien who thought he was a human conspiracy nut, and learn that he’s working as the “creative consultant” on a television series that’s a lot like Stargate SG-1, only with a lower budget. We also learn that in the Stargate universe, what was, in our world, an infamously dumb unsold NBC pilot called Poochinski ran for a hundred episodes. And that Jack O’Neill really liked that show.
So this is naturally full of industry in-jokes and winks at themselves and several other sci-fi teevee shows, some of which the kid got. One of the actors is aggravated about a plot hole that befell a previous episode of this series, other actors use the pseudonym of The Six Million Dollar Man, aliens use Star Trek‘s transporter tech and its visual effect, and the reason the TV show has such a dumb name is because shows with an “X” in the title are supposed to get better ratings, which is why they’re considering adding a sexy alien woman to the program. It’s all in good fun and is winningly playful, and a hundred episodes later, we’d find out how successful Wormhole X-Treme! was.