Plot hole: The CSIs catch a murder suspect putting down a drink can when reviewing security footage of a robbery, and immediately realise they didn't see it at the scene so assume one of the first cops on the scene must have removed it. Thing is though, the murderers shot out the security camera before the actual shooting occurred, meaning there was loads of time off-camera for the killers to take the can with them, but the CSIs never even consider this - they jump to the conclusion a cop took it even though there's no actual evidence for that.
Plot hole: General Hammond is promoted to 3-star general and command of the SGC is given to General O'Neill before the Atlantis gang even left earth. Why is it, that none of them find it the least bit odd that a 2-star Hammond greeted their return instead of O'Neill?
Suggested correction: The dream-state induced by the aliens had some ability to stop them from questioning their reality. (One of them takes quite a while to realise that a friend they're partying with died years before they left for Atlantis). It's not infallible or entirely consistent, but it would theoretically explain this.