SELECT
carmapping0_.Id AS Id30_1_,
carmapping0_.VehiculeId AS VehiculeId30_1_,
carmapping0_.TariffName AS TariffName30_1_,
carmapping0_.OfferReference AS OfferRef4_30_1_,
carmapping0_.CreationDate AS Creation6_30_1_,
carmapping0_.UpdateDate AS UpdateDate30_1_,
carmapping0_.Status AS Status30_1_,
m1_.Id AS Id9_0_,
m1_.VehiculeRef AS VehiculeRef9_0_,
m1_.MnoVehiculeRef AS MnoVehiculeRef9_0_,
m1_.Description AS Descript4_9_0_,
m1_.EntryCreationDate AS EntryCre5_9_0_,
m1_.LastUpdateDate AS LastUpda6_9_0_
FROM CarMapping carmapping0_ INNER JOIN Vehicule m1_ ON carmapping0_.VehiculeId = m1_.Id
WHERE (this_.OfferReference = ? AND this_.Status = ?) AND m1_.VehiculeRef = ?