Years ago, when Stargate: SG-1 was still in its prime (and on the air), JoWood, MGM and a Sydney studio called Perception got together to make a game based on the franchise, called Stargate SG-1: The Alliance. Sufficed to say, it never saw the light of day, the project stricken by all sorts of problems and legal shenanigans. Eventually, in 2007, JoWood tried to take the game and the rights to it from Perception. The studio won the fight but the game was never released.
The Gaming Liberty got in touch with some of the developers and managed to get their hands on a near-complete version of the game and put together this video. According to TGL, around 90 per cent of it is playable and features a good chuck of voice acting from the primary cast members.
The Gaming Liberty has posted two follow-up articles. One has an interview with the game's lead designer. The second has some 1000 screenshots of the game, if you don't mind grabbing them from MegaUpload. The site also plans to do a video play-through in the future, so watch out for that.
Cancelled Stargate SG-1: The Alliance reveal trailer [The Gaming Liberty]