SELECT * FROM camper_prices as cp
INNER JOIN camper_vehicle as cv
ON
cp.oid = cv.parentid
AND
cv.language=cp.language
where cv.oid = wilderness-nugget-2
AND cp.language = 'D'
AND cp.subcontainer_oid_19 = wilderness-nugget-2
ORDER BY
subcontainer_sort_19, subcontainer_sort_27, subcontainer_sort_29
SELECT cv.*, cp.* FROM camper_price_options as cp
INNER JOIN camper_vehicle as cv
ON
cp.oid = cv.parentid
AND
cv.language = cp.language
where
cv.oid = wilderness-nugget-2
AND
cp.language = 'D'
ORDER BY
subcontainer_sort_77
Camper DetailsCamper Details - | duedderreisen.de