Ecto query order for preload

I have tried something like this guy do: Preload with order_by from another table with Ecto

but the order is fucked and some data is missing. so i am very confused