You are looking at the restyled first-generation Mazda CX-7, a five-door SUV. Gasoline and diesel versions, automatic or manual gearboxes, and front- or all-wheel drive all appear in this generation.
A Mazda CX-7 engine in this restyling can be gasoline or diesel, and the powertrain changes with the version. The 2.5 AT pairs a gasoline engine with an automatic transmission and front-wheel drive. The 2.2 MT diesel and 2.3 MT gasoline manuals use an all-wheel-drive drivetrain; they are examples, not every version.
SUV 5-doors — Mazda CX-7 Engines and Transmissions