export const queryAllGroups4 = await db
  .select({
    groupId: groups.id,
    groupName: groups.name,
    attendeeTypes: sql<string>`GROUP_CONCAT(${attendeeTypes.name})`,
  })
  .from(groups)
  .leftJoin(groupsToAttendeeTypes, eq(groups.id, groupsToAttendeeTypes.groupId))
  .leftJoin(
    attendeeTypes,
    eq(attendeeTypes.id, groupsToAttendeeTypes.attendeeTypeId)
  )
  .groupBy(groups.id);

export const queryAllGroups4 = await db
  .select({
    groupId: groups.id,
    groupName: groups.name,
    attendeeTypes: sql<string>`GROUP_CONCAT(${attendeeTypes.name})`,
  })
  .from(groups)
  .leftJoin(groupsToAttendeeTypes, eq(groups.id, groupsToAttendeeTypes.groupId))
  .leftJoin(
    attendeeTypes,
    eq(attendeeTypes.id, groupsToAttendeeTypes.attendeeTypeId)
  )
  .groupBy(groups.id);

export const selectAllActiveGroups = await db
  .select()
  .from(groupsToAttendeeTypes)
  .leftJoin(groups, eq(groupsToAttendeeTypes.groupId, groups.id))
  .leftJoin(
    attendeeTypes,
    eq(groupsToAttendeeTypes.attendeeTypeId, attendeeTypes.id)
  )
  .where(
    and(
      isNull(groups.deletedAt),
      eq(groups.active, true),
      eq(attendeeTypes.active, true)
    )
  );

export const selectAllActiveGroups = await db
  .select()
  .from(groupsToAttendeeTypes)
  .leftJoin(groups, eq(groupsToAttendeeTypes.groupId, groups.id))
  .leftJoin(
    attendeeTypes,
    eq(groupsToAttendeeTypes.attendeeTypeId, attendeeTypes.id)
  )
  .where(
    and(
      isNull(groups.deletedAt),
      eq(groups.active, true),
      eq(attendeeTypes.active, true)
    )
  );