Hmm... I suspect that DBs can often figure out the optimal join order, so you need to make certain you need to specify the order at all.
You can also use views to simplify joined table queries. The view itself can specify join order.
Thank you for your answer!
Do you know if it is possible to map pojo's to view's (especially with hibernate)?