feed.ex

def list_user_posts(user_id) do
  Post
  |> distinct(true)
  |> where([p], p.user_id == ^user_id)
  |> join(:left, [p], d in assoc(p, :user))
  |> join(:left, [_p, d], co in assoc(d, :country))
  |> join(:left, [_p, d], ci in assoc(d, :city))
  |> join(:left, [p, _d], ph in assoc(p, :post_photos))
  |> preload([_p, d, co, ci, ph], user: {d, country: co, city: ci}, post_photos: ph)
end