Stargate SG-1 (1997)

S02E05 Need

Jackson becomes entranced by the powers of a Goa'uld sarcophagus, leading him to develop a dangerous dependency. His vulnerability is further complicated when he finds himself drawn to the planet's cunning princess, who knows how to exploit his weaknesses.