Sorry to follow up on my own drivel, but I think I've found a solution in the fine django docs:
obs = Observation.objects.filter(observer=o.id,location__location_area__area_country__country_abbrev=country_code).values("bird_id").annotate(Count("bird")) seems to do the job nicely for all combinations of areas, countries and so on. The key seems to be the usage of the Count() aggregate function. Thanks for listening, Uwe -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.