without_preloads1.ex

  def list_plan_types_paginated(
        search,
        order_by \\ "id",
        direction \\ "desc",
        limit \\ 50,
        cursor_after \\ nil,
        cursor_before \\ nil,
        opts \\ []
      ) do
    from(p in PlanType, as: :plan_type)
    |> join(:left, [p], cp in assoc(p, :core_provider))
    |> join(:left, [p], cpt in assoc(p, :core_product_type))
    |> select_merge([p, cp, cpt], %{
      core_provider: cp,
      core_product_type: cpt
    })
    |> group_by([p, cp, cpt], [p.id, cp.id, cpt.id])
    |> Query.search(search, order_by, direction)
    |> Repo.soft_deleted(opts)
    |> Repo.paginate(
      after: cursor_after,
      before: cursor_before,
      include_total_count: true,
      cursor_fields: [
        {String.to_existing_atom(order_by), String.to_existing_atom(direction)}
      ],
      limit: limit
    )
  end