inArray

  const main = db.$with('main').as(
      db
        .select({
          id: histories.id,
          medicalHistoryNumber: histories.medicalHistoryNumber,
          date: histories.date,
          type: histories.type,
          division: histories.division,
          state: histories.state,
          provider: {
            id: provider.id,
            name: provider.name,
          },
          hospital: {
            id: hospital.id,
            name: hospital.name,
          },
        })
        .from(histories)
        .leftJoin(hospital, eq(histories.hospitalId, hospital.id))
        .leftJoin(provider, eq(histories.providerId, provider.id))
        .where(or(eq(histories.hospitalId, req.session.user?.hospitalId!), eq(histories.providerId, req.session.user?.providerId!)))
        .orderBy(desc(histories.id))
        .limit(Number(limit))
        .offset(Number(offset)),
    );

   const [selectHistories, countHistories] = await Promise.all([
      state.length ? await db.with(main).select().from(main).where(inArray(histories.state, state)) : await db.with(main).select().from(main),