Stargate SG-1 (1997)

S2E5 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.