Dados da Viatura
Marca Abarth AC ACE Aggreko Aixam Alfa Romeo Alpina Alpine Aston Martin Audi Austin Austin Morris Autobianchi Autoroller Bedford Bentley Bertone Blyss BMW Buick Burstner Cadillac Can am Case Caterham Caterpillar CF Moto Challenger Champion Chevrolet Chrysler Citroën Claas Clark Corvette Cupra Dacia Daewoo DAF Daihatsu Daimler Datsun DeSoto DeTomaso Dodge DS Ducati Durkopp Dynapac Elnagh Facel Vega FAHEL Fendt Ferrari FG Wilson Fiat Fiat-Allis Fiat-Hitachi Fiori Flandria Florett Ford Freuhauf Frontier Fruehauf Gallignani Galucho Genmac Gerador GMC Halcon Hanomag Hardi Harley Davidson Haulotte Herculano Hidromek Hilman Himoinsa Hitachi Honda Hudson Hummer Hymer Hyster Hyundai Infiniti Inta-Eimar Internacional IRM Iseki Isuzu Iveco Jaguar JCB JDM Jeep Jensen Jiayuan John Deere Joint Joper Josita Jungheinrich Juscafresa Kawasaki Kia Knaus Komatsu Kongskilde Kubota Kuhn Lagarde Lamborghini Lancia Land Rover Landini Lebrero Lecitrailer Lexus Liebherr Ligier Lincoln Linde Lopez Garrido Lotus Lusiane Savana MAN Manitou Maserati Massey Ferguson Matchless Maybach Mazda Mchale Mclaren Mega Mercedes Benz Mercury Merlo Messer Schmitt Metalofabril MG Microcar MINI Mitsubishi Morgan Morris MV Agusta Nash New Holland Nissan NSU O&K Opel Pellenc Peugeot Piaggio Pilot Pilote Pontiac Porsche Radical Renault Rimor Robin Hood Rolls Royce Rover Saab Sachs Sado Same Saviem Scania Seat Secma Sgariboldi Sicma Simca Skoda Smart Sola Ssangyong Standard Stanguellini Subaru Supertino Suzuki Talbot Tata TCM Temared Terex Tesla Tiger TMC Cancela Toyota Tractomoz Tramagal Trigano Triumph TYM V.Mariotti Vanhool Vermeer Vespa Victory Voisin Volkswagen Volvo Yale Yamaha Yanmar Zago Zundapp
SELECT distinct v.titulo_idioma1 As titulo_combustivel,v.cod_combustivel FROM mod21_viaturas_combustivel v, mod21_viaturas_automoveis x WHERE v.cod_combustivel=x.cod_combustivel AND v.cod_tipo_viatura=1 Combustível: Híbrido Gasóleo GPL Híbrido Plug-In Gasolina Electrico Nenhum Híbrido Gasolina Híbrido Plug-In Gasóleo Biofuel Híbrido Gasolina Gasóleo