SELECT
          array_agg(DISTINCT("bundleId")) AS combo_bundle_id,
          array_agg(bundle_platforms ORDER BY "bundleId") AS combo_bundle_platforms,
          legacy_name[1],
          combo_sequence_id,
          combo_sequence,
          combo_sequence_slug,
          array_agg(DISTINCT("actionId")) AS combo_action_id,
          array_agg(DISTINCT(action)) AS combo_action,
          array_agg(DISTINCT(action_slug)) AS combo_action_slug,
          array_agg(action_official ORDER BY "bundleId") AS combo_action_official,
          "categoryId",
          category,
          category_slug,
          string_agg(combo_key_name, '_') AS combo_key_name,
          array_agg(is_favorite ORDER BY "bundleId") AS combo_is_favorite
        FROM (
          SELECT
            UNNEST(array_agg("bundleId")) AS "bundleId",
            UNNEST(array_agg(bundle_platforms)) AS bundle_platforms,
            array_agg(legacy_name ORDER BY "bundleId") AS legacy_name,
            array_agg("sequenceId" ORDER BY "bundleId") AS combo_sequence_id,
            array_agg(sequence ORDER BY "bundleId") AS combo_sequence,
            array_agg(sequence_slug ORDER BY "bundleId") AS combo_sequence_slug,
            "actionId",
            action,
            action_slug,
            UNNEST(array_agg(action_official)) AS action_official,
            "categoryId",
            category,
            category_slug,
            string_agg(combo_key_name, '_') AS combo_key_name,
            UNNEST(array_agg(is_favorite)) AS is_favorite
          FROM (
            SELECT
              bundle.id AS "bundleId",
              CONCAT(bundle.windows, bundle.mac, bundle.linux, bundle.web) AS bundle_platforms,
              sequence.legacy_name,
              bundle."sequenceId",
              sequence.legacy_name AS sequence,
              -- sequence.hold AS sequence_hold,
              sequence.slug AS sequence_slug,
              bundle."actionId",
              action.name AS action,
              action.slug AS action_slug,
              official_action.name AS action_official,
              bundle."categoryId",
              category.name AS category,
              category.slug AS category_slug,
              string_agg(key.name, '_') AS combo_key_name,
              COUNT(user_favorite_bundles_bundle)>0 AS is_favorite
            FROM bundle
              JOIN action ON action.id = bundle."actionId"
              JOIN sapp ON sapp.id = bundle."sappId"
              JOIN sequence ON sequence.id = bundle."sequenceId"
              JOIN sequence_shortcut ON sequence_shortcut."sequenceId" = sequence.id
              JOIN shortcut ON shortcut.id = sequence_shortcut."shortcutId"
              JOIN shortcut_key ON shortcut_key."shortcutId" = shortcut.id
              JOIN key ON key.id = shortcut_key."keyId"
              JOIN category ON bundle."categoryId" = category.id
              LEFT JOIN official_action ON official_action.id = bundle."officialActionId"
              LEFT JOIN user_favorite_bundles_bundle ON user_favorite_bundles_bundle."bundleId" = bundle.id
                AND user_favorite_bundles_bundle."userId" = $2
            WHERE sapp.slug = $1
              AND bundle.status = 1
              AND bundle.locale = 'en'
              ${os_query}
            GROUP BY
              bundle.id,
              sequence.legacy_name,
              sequence_slug,
              -- sequence_hold,
              action,
              action_slug,
              action_official,
              category,
              category_slug
          ) AS LEVEL_1
          GROUP BY
            "actionId",
            action,
            action_slug,
            "categoryId",
            category,
            category_slug
        ) AS LEVEL_2
        GROUP BY
          legacy_name,
          combo_sequence_id,
          combo_sequence,
          combo_sequence_slug,
          "categoryId",
          category,
          category_slug`,
      [slug, user?.id ?? null],