These matte paintings were commisioned for the teaser trailer cinematics of Stargate SG-1: Unleashed, a game to be released in 2013.

Concepts for the world shot:

Final matte painting:

Concepts for the destroyed world shot:

They really wanted get closer to the cities, the final matte painting was this one (it was not used in the final trailer):

Detail:

Two different views of the red planet:

Concepts for the pyramid shot:

Final matte painting: