Stargate SG-1 (1997)

S06E20 Memento

Prometheus makes an emergency landing on a foreign planet, where the only way for the crew to get back home is through the local Stargate. However, the inhabitants of this world regard the gate as nothing more than a legend.