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 31401,Exclude on M2M with F-function not working.,Ron,nobody,"I have the following models: {{{ class Activity(models.Model): user = models.ForeignKey(User, related_name='activities') project = models.ForeignKey(Project, related_name='activities') class Project(models.Model): assignees = models.ManyToManyField(User, related_name='projects') }}} Now I want to query for all the activities which belog to a user which is NOT in the projects assignees. My query: Activity.objects.exclude(project__assignees=F('user')) Problem is, I always get this error: > django.db.utils.OperationalError: (1054, ""Unknown column 'U2.id' in 'on clause'"") Im working on django 2.2.11 and MySQL. I found a couple of [old django bugs][1] but they are supposed to be fixed since ages. Any ideas how I can solve my problem? My activity table is huge and I need an efficient way. And I'd be happy to not use raw queries. Thanks! [1]: https://code.djangoproject.com/ticket/28551",Bug,closed,"Database layer (models, ORM)",2.2,Normal,duplicate,,,Unreviewed,0,0,0,0,0,0