`select o from Order  o
 left join fetch o.notes note   left join fetch o.orderedBy orderedBy
 left join fetch orderedBy.address addressOrdered
 left join fetch orderedBy.language orderedByLg
 left join fetch orderedByLg.translations orderedByLgTtrad
 left join fetch o.deliveredTo deliveredTo
 left join fetch deliveredTo.address addressDelivered
  left join fetch deliveredTo.language deliveredToLg
 left join fetch deliveredToLg.translations
left join fetch o.finalReceiptPlace finalReceiptPlace
  left join fetch finalReceiptPlace.address addressFinalReceiptPlace
  left join fetch finalReceiptPlace.language finalReceiptPlaceLg
  left join fetch finalReceiptPlaceLg.translations
  inner join fetch o.deliveryRoute delivery
  left join fetch delivery.translations
  inner join fetch o.type orderType
  left join fetch orderType.translations
  inner join fetch o.currency currency
  left join fetch currency.translations
  left join fetch o.attachments
  left join fetch note.origin orig
  left join fetch orig.translations
  left join fetch o.supplier sup
  left join fetch sup.department dep
   left join fetch o.stateDetail stateD
   inner join fetch stateD.state stat
   where 1=1   and   o.entryDate >= :startDate   `