select_preload.ex

def list_user_posts_select(user_id) do
  Post
  |> where([p], p.user_id == ^user_id)
  |> join(
      :inner,
      [post],
      user in User,
      on: user.id == post.user_id and is_nil(user.deleted_at) == true and
        is_nil(user.blocked_at) == true
    )
  |> select([:id, :content, user: [:id, :email]])
  |> preload([p, u], user: u)
  |> preload(user: [:country, :city])
end