Sample generated SQL by Hibernate:

select
cargoitem1_.att_line_item as y0_,
this_.audit_logs_id as y1_,
cargoitem1_.cargo_id as y2_,
this_.created_by as y3_,
cargoitem1_.updated_by as y4_,
cargoitem1_.id as y5_,
cargoitem1_.created_date as y6_,
this_.asset_tag as y7_,
this_.updated_by as y8_,
this_.updated_by as y9_,
this_.id as y10_,
cargoitem1_.item_description as y11_,
this_.id as y12_,
cargoitem1_.att_asset_tags as y12_,
this_.is_good_condition as y13_,
this_.quantity as y14_,
cargoitem1_.quantity as y15_,
this_.created_date as y16_,
cargoitem1_.callout as y17_,
this_.audit_logs_id as y18_,
this_.updated_date as y19_,
cargoitem1_.line_id as y20_,
cargoitem1_.cargo_id as y21_,
this_.cargo_item_id as y22_,
cargoitem1_.callout_line as y23_,
this_.cargo_item_id as y24_,
cargoitem1_.created_by as y25_,
this_.created_by as y26_,
cargoitem1_.created_by as y27_,
cargoitem1_.updated_date as y28_,
cargoitem1_.updated_by as y29_,
this_.notes as y30_,
cargoitem1_.id as y31_,
cargoitem1_.mfg_item_number as y31_
from
cargo_item_audit_logs this_
left outer join
cargo_item cargoitem1_
on this_.cargo_item_id=cargoitem1_.id
where
this_.id in (
select
subquery_.id as y0_
from
cargo_item_audit_logs subquery_
where
(
subquery_.audit_logs_id=?
)
)
order by
y10_ desc