Audi SEAT Škoda Volkswagen BMW Cupra Hyundai Land Rover Mercedes-Benz Porsche 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ý' 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.hodnotaAmarok Arteon Arteon Shooting Brake Caddy Caddy Maxi Caravelle Golf ID.3 ID.4 Multivan Passat Alltrack Passat Variant T-Cross T-Roc Taigo Tiguan Touareg Touran Transporter
benzín diesel Elektro hybrid
automat manuál
vyhledat
