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()
[<Location: Holladay>, <Location: Multnomah>, <Location: ITA>]

>>> show = Show.objects.get(slug='January_2010_Meeting')
>>> eps = Episode.objects.filter(show=show)
>>> Location.objects.filter(episode__in=eps)
[<Location: ITA>, <Location: ITA>, <Location: ITA>]
}}}

I expected
{{{
>>> Location.objects.filter(episode__in=eps)
[<Location: ITA>]
}}}

I am pretty sure this used to work as described.

hmmm...
{{{
In [15]: Location.objects.filter(id__in=[9,9,9])
Out[15]: [<Location: ITA>]
}}}

"		closed	Database layer (models, ORM)	dev		invalid			Unreviewed	0	0	0	0	0	0