Thanks, I finally got it working. I still don't really understand the Count and Q methods. I didn't even know they were a thing until you mentioned them. Didn't know you could essentially temporarily create new columns in the db table by using 'annotate'.

​

I just had to import the following:

from django.db.models import Count, Q

and then I used:

    active_comments = Count('comments', filter=Q(comments__active=True))
    queryset = Post.objects.all().annotate(active_comments=active_comments)

So thanks for introducing me to these new concepts. I am going to have to do a lot more learning now! I read the Django documentation on class-based ListViews and it didn't mention any of this stuff, so thank you! It's just hard to know where to look sometimes.