SELECT
  json_build_object(
    'aggregate',
    json_build_object(
      'count',
      COUNT(*),
      'max',
      json_build_object('album_id', max("album_id"))
    ),
    'nodes',
    (
      SELECT
        coalesce(
          json_agg(
            "_11_sub_query"."nodes"
            ORDER BY
              "ob_col_1" ASC NULLS LAST,
              "ob_col_2" DESC NULLS FIRST
          ),
          '[]'
        )
      FROM
        (
          SELECT
            "_10_unnest_table"."nodes" AS "nodes",
            "_10_unnest_table"."ob_col_1" AS "ob_col_1",
            "_10_unnest_table"."ob_col_2" AS "ob_col_2"
          FROM
            UNNEST(
              array_agg("nodes"),
              array_agg("root.pg.album_id"),
              array_agg("root.ar.aggregate.order_by.count")
            ) AS "_10_unnest_table"("nodes", "ob_col_1", "ob_col_2")
          ORDER BY
              "ob_col_1" ASC NULLS LAST,
              "ob_col_2" DESC NULLS FIRST
          LIMIT
            10  -- permission limit
        ) AS "_11_sub_query"
    )
  ) AS "root"
FROM
--------------
--------------