select
customeror0_.id as id1_4_0_,
orderprodu1_.id as id1_5_1_,
product2_.id as id1_7_2_,
address3_.id as id1_0_3_,
customer4_.id as id1_3_4_,
address5_.id as id1_0_5_,
bankaccoun6_.id as id1_1_6_,
customeror0_.bankAccount as bankAcco6_4_0_,
customeror0_.billingAddress as billingA7_4_0_,
customeror0_.customer as customer8_4_0_,
customeror0_.orderDate as orderDat2_4_0_,
customeror0_.orderState as orderSta3_4_0_,
customeror0_.shippingAddress as shipping9_4_0_,
customeror0_.timeStamp as timeStam4_4_0_,
customeror0_.version as version5_4_0_,
orderprodu1_.amount as amount2_5_1_,
orderprodu1_.customerOrder as customer5_5_1_,
orderprodu1_.product as product6_5_1_,
orderprodu1_.timeStamp as timeStam3_5_1_,
orderprodu1_.version as version4_5_1_,
orderprodu1_.customerOrder as customer5_4_0__,
orderprodu1_.id as id1_5_0__,
product2_.amount as amount2_7_2_,
product2_.currency as currency3_7_2_,
product2_.producer as producer8_7_2_,
product2_.productName as productN4_7_2_,
product2_.productNo as productN5_7_2_,
product2_.timeStamp as timeStam6_7_2_,
product2_.version as version7_7_2_,
address3_.address as address2_0_3_,
address3_.city as city3_0_3_,
address3_.country as country4_0_3_,
address3_.firstName as firstNam5_0_3_,
address3_.housenumber as housenum6_0_3_,
address3_.lastName as lastName7_0_3_,
address3_.timeStamp as timeStam8_0_3_,
address3_.version as version9_0_3_,
address3_.zipCode as zipCode10_0_3_,
customer4_.billingAddress as billingA7_3_4_,
customer4_.email as email2_3_4_,
customer4_.firstName as firstNam3_3_4_,
customer4_.lastName as lastName4_3_4_,
customer4_.shippingAddress as shipping8_3_4_,
customer4_.shoppingCard as shopping9_3_4_,
customer4_.timeStamp as timeStam5_3_4_,
customer4_.version as version6_3_4_,
address5_.address as address2_0_5_,
address5_.city as city3_0_5_,
address5_.country as country4_0_5_,
address5_.firstName as firstNam5_0_5_,
address5_.housenumber as housenum6_0_5_,
address5_.lastName as lastName7_0_5_,
address5_.timeStamp as timeStam8_0_5_,
address5_.version as version9_0_5_,
address5_.zipCode as zipCode10_0_5_,
bankaccoun6_.accountNo as accountN2_1_6_,
bankaccoun6_.bank as bank3_1_6_,
bankaccoun6_.bic as bic4_1_6_,
bankaccoun6_.blz as blz5_1_6_,
bankaccoun6_.customer as customer9_1_6_,
bankaccoun6_.iban as iban6_1_6_,
bankaccoun6_.timeStamp as timeStam7_1_6_,
bankaccoun6_.version as version8_1_6_
from
CustomerOrder customeror0_
left outer join
Order_Product orderprodu1_
on customeror0_.id=orderprodu1_.customerOrder
left outer join
Product product2_
on orderprodu1_.product=product2_.id,
left outer join
Address address3_
on customeror0_.billingAddress=address3_.id
left outer join
Customer customer4_
on customeror0_.customer=customer4_.id
left outer join
Address address5_
on customeror0_.shippingAddress=address5_.id
left outer join
BankAccount bankaccoun6_
on customeror0_.bankAccount=bankaccoun6_.id