Where to Find a Reliable Stargate Sg1 Episode List (And Why Most Lists You Find Are Wrong)
I spent three hours last week trying to rebuild a clean episode guide because every list I found on the internet either had wrong episode numbers, mismatched titles between US and international broadcasts, or just plain made up air dates. It's a stupidly common problem. If you're looking for a Stargate Sg1 Episode List that actually holds up to scrutiny, here's what you need to know before you waste your time. The show ran 214 episodes over ten seasons, from 1997 to 2007. That's straightforward enough. The problem starts the second you try to compile it yourself or download someone else's version. Season numbering gets messy around the DVD release because some regions treat the Stargate SG-1 pilot as a season one episode and others don't. Production codes shift between seasons too. You think you've got a clean list, then you realize episode 213 and 214 have their order flipped on several tracking sites. I hit this exact issue when I was trying to map episode filenames to a naming convention for a personal media library. The files used production codes and the IMDb list used network broadcast order. Two episodes in season nine — "Fire and Water" and "Fragile Balance" — have identical air dates but opposite production codes. A simple alphabetical sort breaks them. The workaround was cross-referencing the Sci-Fi Channel's original broadcast logs against the MGM production documentation. It took about forty minutes instead of four, but you can't skip that step if you want accuracy.
The most reliable source I found is the official MGM/Studio distribution database that feeds into the Stargate wiki. Even that has occasional errors from early wiki vandalism that never got fully cleaned. The best approach is to start there, verify any suspicious entries against the TV.com broadcast records, and then double-check episode titles against the actual subtitles that appear in the broadcast credits. Some episodes have alternate titles that confuse automated scrapers. "Children of the Gods" is listed as the pilot in some databases but as a separate movie in others, which throws off the entire count if you're not watching for it. If you just want a downloadable list, there are a few CSV exports floating around on GitHub and fan sites, but they vary wildly in quality. The one I end up recommending is the one maintained by the Stargate community that includes production codes, original air dates, and episode summaries. It's not perfect but it's auditable. You can verify each entry yourself. That's more than you can say for most of the pre-packaged lists you find on torrent sites and random fan blogs. Don't bother trying to scrape these from major streaming platforms. Their internal episode ordering is inconsistent and some services split or combine episodes differently than the original broadcast run. That's where I lost most of my initial time. Just go straight to the primary sources and build it yourself. The whole process takes about two hours if you work through it carefully, and you end up with something that's actually trustworthy instead of copying someone else's errors.
