select
car0_.vin as vin1_0_0_,
owner2_.id as id1_2_1_,
car0_.manufacture_code as manufacture_code3_0_0_,
car0_.name as name2_0_0_,
car0_.owner_id as owner_id4_0_0_,
owner2_.firstName as firstName2_2_1_,
owner2_.lastName as lastName3_2_1_
from
Car car0_,
Manufacture manufactur1_,
Owner owner2_
where
car0_.manufacture_code=manufactur1_.code
and car0_.owner_id=owner2_.id(+)
order by
manufactur1_.name