SELECT * FROM rentalcars_prices as cp
INNER JOIN rentalcars_vehicle as cv
ON
cp.oid = cv.parentid
AND
cv.language=cp.language
where cv.oid = kea-mietwagen-6
AND cp.language = 'D'
AND cp.subcontainer_oid_33 = kea-mietwagen-6
ORDER BY
subcontainer_sort_33, subcontainer_sort_30, subcontainer_sort_34
SELECT cv.*, cp.* FROM rentalcars_price_options as cp
INNER JOIN rentalcars_vehicle as cv
ON
cp.oid = cv.parentid
AND
cv.language = cp.language
where
cv.oid = kea-mietwagen-6
AND
cp.language = 'D'
ORDER BY
subcontainer_sort_74
MietwagenDetailsMietwagenDetails - | duedderreisen.de