On the upside, the insane mono-fever-dream thing that lasted until about noon was cool as hell, in a very confusing sort of way. Some really freaking awesome mega-plot-thing that had all sorts of Star Trek TNG and DS9 people in the Pegasus Galaxy with the Atlantis folk, and Picard in Klingon-makeup (because Klingons were... like... allied with the Wraith, or something) and there were evil Ancients with TIME MACHINES trying to DESTROY EARTH'S PAST and stuff. Kira and Teyla sort of got amalgamated into the same character, I think... which actually makes a frightening amount of sense. Way to go, my unconscious.
The Good Guys were also falling victim to some kind of biological warfare... I think. Or radiation poisoning. Or something that made everyone get sick at odd points for periods of time.
There was also time-out for John to take Lizzie flying on some sort of Ancient anti-grav hang-glider.
Last I saw, KiraTeyla had managed to escape her Evil Ancient-or-something Tormentor to crawl into a sarcophagus in an attempt to heal herself so she could Get Back To The Fight... but evil Ancient dude caught her and took her back in time a thousands of years to where their Nefarious Plot was being enacted. (And somehow, this involved humans living in modern-day skyscrapers with big televisions). AND THEN
But I am cheered by the internet. YAY. I'm going to go pass out again now. *zonks*
Edit: John Sheppard/Kira Nerys crossover OTP? No, she'd totally kick his ass and not give him the time of day... but would still be entertaining