id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 12625 .filter(foo__in= duplicates CarlFK "http://docs.djangoproject.com/en/dev/ref/models/querysets/#in SELECT ... WHERE id IN (1, 3, 4); There is no JOIN, and yet: eps all have the same parent: ITA. {{{ >>> from main.models import Client, Show, Location, Episode >>> Location.objects.all() [, , ] >>> show = Show.objects.get(slug='January_2010_Meeting') >>> eps = Episode.objects.filter(show=show) >>> Location.objects.filter(episode__in=eps) [, , ] }}} I expected {{{ >>> Location.objects.filter(episode__in=eps) [] }}} I am pretty sure this used to work as described. hmmm... {{{ In [15]: Location.objects.filter(id__in=[9,9,9]) Out[15]: [] }}} " closed Database layer (models, ORM) dev invalid Unreviewed 0 0 0 0 0 0