Audi SEAT Škoda Volkswagen Citroen Cupra Ford Hyundai Mercedes-Benz Peugeot
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ý' and Z.url in ('volkswagen')
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ý' and Z.url in ('volkswagen')
) AS pomocny
ORDER BY pomocny.hodnotaArteon Shooting Brake Caddy Caravelle Golf Golf Variant ID.3 Multivan Passat Variant Polo T-Roc Taigo Tiguan Tiguan Allspace Touareg Transporter up!
benzín diesel elektro Elektro hybrid hybridní - benzín
automat manuál
vyhledat
