const data = await ctx.db
        .select({
          propositionId: propositionsVotes.propositionId,
          twitchSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.twitchSubscribed},false)) as int)`,
          youtubeSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.youtubeSubscribed},false)) as int)`,
          normalVotesCount: sql<number>`cast(count(${propositionsVotes.profileId}) as int)`,
          proposition: WRITE SOMETHING THAT WILL GIVE ME PROPOSITION DATA IN HERE
        })
        .from(propositionsVotes)
        .groupBy(propositionsVotes.propositionId)
        .orderBy(
          sql<number>`cast(count(${propositionsVotes.twitchSubscribed}) as int)`,
        );

      const data = await ctx.db
        .select({
          propositionId: propositionsVotes.propositionId,
          twitchSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.twitchSubscribed},false)) as int)`,
          youtubeSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.youtubeSubscribed},false)) as int)`,
          normalVotesCount: sql<number>`cast(count(${propositionsVotes.profileId}) as int)`,
          proposition: WRITE SOMETHING THAT WILL GIVE ME PROPOSITION DATA IN HERE
        })
        .from(propositionsVotes)
        .groupBy(propositionsVotes.propositionId)
        .orderBy(
          sql<number>`cast(count(${propositionsVotes.twitchSubscribed}) as int)`,
        );

      await ctx.db.transaction(async (db) => {
        const board = await db
          .insert(boards)
          .values({
            name: input.name,
            twitchUsername: input.twitchUsername,
            youtubeChannelId: input.youtubeChannelId,
            id: input.id,
            slug: input.slug,
          })
          .returning();

        console.timeLog("addNewBoard", { board });
        const newValue = board[0] || null;

        if (!newValue) {
          db.rollback();

          return "success";
        }

        await db.insert(boardOwnerships).values({
          boardId: newValue.id,
          profileId: ctx.user.id,
        });
        console.timeLog("addNewBoard", "board query done");

        return "success";
      });
        console.timeEnd("addNewBoard");

      return "success";

      await ctx.db.transaction(async (db) => {
        const board = await db
          .insert(boards)
          .values({
            name: input.name,
            twitchUsername: input.twitchUsername,
            youtubeChannelId: input.youtubeChannelId,
            id: input.id,
            slug: input.slug,
          })
          .returning();

        console.timeLog("addNewBoard", { board });
        const newValue = board[0] || null;

        if (!newValue) {
          db.rollback();

          return "success";
        }

        await db.insert(boardOwnerships).values({
          boardId: newValue.id,
          profileId: ctx.user.id,
        });
        console.timeLog("addNewBoard", "board query done");

        return "success";
      });
        console.timeEnd("addNewBoard");

      return "success";