User.objects.annotate( no_reports=~Exists(Reports.objects.filter(user__eq=OuterRef('pk'))) ).filter( email__startswith='a', no_reports=True )