Audi Volkswagen
A5 Limousine A6 A6 allroad quattro A6 Avant Caddy Caravelle e-tron GT Golf Golf Variant ID. Cross ID. Polo ID.3 Neo ID.7 Tourer ID.Buzz Multivan Passat Q3 Q3 Sportback Q5 Q7 Q8 R8 Spyder RS 3 Limousine RS 3 Sportback RS 5 Limuzína RS 6 Avant RS Q8 SQ5 SQ7 SQ8 T-Cross T-Roc Taigo Tayron Tiguan Touareg Transporter T7
benzín elektro hybridní - benzín nafta
automat DSG manuál S tronic Tiptronic
vyhledat
Audi SEAT Škoda Volkswagen Cupra Hyundai Mercedes-Benz MG Peugeot Renault
SELECT DISTINCT pomocny.url, pomocny.hodnota FROM
(
SELECT M.url, M.hodnota
FROM vozy V
INNER JOIN ojetiny_model M ON M.id = V.id_model
INNER JOIN ojetiny_znacka Z ON M.id_znacka = Z.id
WHERE V.skryte = 0 AND V.vymaz = 0 AND V.pujcovna = 0 AND V.kategorie = 'ojetý'
UNION ALL
SELECT M.url, M.hodnota
FROM vozy_dwa V
INNER JOIN dwa_model M ON M.id = V.id_model
INNER JOIN dwa_znacka Z ON M.id_znacka = Z.id
WHERE V.skryte = 0 AND V.vymaz = 0 AND V.pujcovna = 0 AND V.kategorie = 'ojetý'
) AS pomocny
ORDER BY pomocny.hodnota3008 A4 Avant A5 A6 A6 Allroad Quattro A6 Avant A7 Sportback Amarok Arona Arteon Arteon Shooting Brake Ateca Caddy Caddy Maxi Caravelle Crafter - skříňový vůz Enyaq Fabia GLC Golf i30 ID.3 ID.4 Kamiq Karoq Kodiaq Leon Mégane Octavia Passat Alltrack Passat Variant Q2 Q3 Q5 Q5 Sportback Q7 Q8 R8 RS3 S5 Scala Superb T-Cross Taigo Tarraco Tiguan Touareg Touran Transporter Tucson ZS
benzín diesel Elektro hybrid
automat manuál
vyhledat
