val messageIdsInAgoraQuery = quote {
      query[ClientMessages]
        .leftJoin(query[Comments])
        .on {
          case (messages, comments) => messages.messageId == comments.commentId
        }
        .map {
          case (messages, maybeComments) => (messages.messageId, maybeComments.map(_.commentId))
        }
        .groupBy {
          case (messageId, _) => messageId
        }
        .map {
          case (messageId, rows) => (messageId, rows.map(_._2).size)
        }
    }