More strict query yields more results?
- by Mark
I've got a query that looks like this
affiliates = User.objects.annotate(referral_count=Count('referrals')).filter(referral_count__gt=0)
But when I restrict it more by adding referrals__user__date_joined__gt=start_date to the filter, I get even higher referral counts.
I'm trying to count the number of people a user has referred within a time…