Django ORM：子查询上的文本聚合器

我的头撞到了这个上面:

我有2个模型，我正在试图设计一个自定义管理器/查询集，将允许我注释到每个Series的id个链接的谜题满足格式'2,13,26'的某些条件.

简化的模型:

class Series(models.Model):
    puzzles = models.ManyToManyField(
        Puzzle, through='SeriesElement', related_name='series')
    is_public = models.BooleanField(null=False, blank=False, default=False)

class Puzzle(models.Model):
    pass

我的定制聚合器:

from django.db.models.aggregates import Aggregate
from django.db.models.functions import Coalesce
from django.db.models.fields import CharField
from django.db.models.expressions import Value

class GroupConcat(Aggregate):
    """
    according to https://stackoverflow.com/questions/10340684/group-concat-equivalent-in-django
    according to https://stackoverflow.com/a/55216659
    would be compatible with MySQL and SQLite
    """
    function = 'GROUP_CONCAT'

    def __init__(self, expression, distinct=False, ordering=None, **extra):
        super(GroupConcat, self).__init__(expression,
                                          distinct='DISTINCT ' if distinct else '',
                                          ordering=' ORDER BY %s' % ordering if ordering is not None else '',
                                          output_field=CharField(),
                                          **extra)


    def as_sqlite(self, compiler, connection, **extra):
        return super().as_sql(compiler,
                              connection, 
                              template='%(function)s(%(distinct)s%(expressions)s%(ordering)s)',
                              **extra)

一个实现我目标的试探性方法:

pzl_sub = apps.get_model('puzzles', 'Puzzle').objects.filter(series__id= OuterRef('id'))
pzl_sub = pzl_sub.filter(series_elements__isnull=False).add_nb_public_series().filter(nb_public_series=5)
pzl_ids= pzl_sub.order_by().values('id')
qs = Series.objects.annotate(id_str_pzl = GroupConcat(pzl_ids))

我只获得了一个符合指定条件的publle.id，而不是所有符合条件的publle.id的集合

有线索知道我做错了什么吗？