I have a custom manager with search, which orders return results by rank:

class MyManager(models.Manager):
    
    def search(self, query, fa, fb=None, fc=None, fd=None, qs=None):
        
        if not qs:
            qs = self.get_queryset()

        try:

            if not (1 in [c in query for c in '&|()!*:"']):
                query = " & ".join([f"{q}:*" for q in query.split()])

            vector = SearchVector(*fa, weight="A", config="english")
            if fb:
                vector += SearchVector(*fb, weight="B", config="english")
            if fc:
                vector += SearchVector(*fc, weight="C", config="english")
            if fd:
                vector += SearchVector(*fd, weight="D", config="english")
            query = SearchQuery(query, search_type="raw")
            qs = (
                qs.annotate(search=vector, rank=SearchRank(vector, query))
                .filter(search=query)
                .order_by("-rank", "-id")
                .distinct("rank", "id")
            )
            qs.count()  # Trigger exception

        except (ProgrammingError, UnboundLocalError):
            qs = qs.none()

        return qs

But when I try searching on related fields, it still returns duplicate results:

class Case(models.Model):
    machine = models.ForeignKey(Machine, on_delete=models.CASCADE)   
    user = models.ForeignKey(Profile, on_delete=models.SET_NULL)    
    hashtags = models.CharField(max_length=255) 
    closed = models.BooleanField(default=False)  

    objects = MyManager()


class CaseProgress(models.Model):
    case = models.ForeignKey(Case, on_delete=models.CASCADE)
    desc = models.TextField()


class Profile(models.Model):
    user = models.OneToOneField(User, on_delete=models.SET_NULL, null=True)

class CaseListView(ListView):
    model = Case

    def get_queryset(self):
        query = self.request.GET.get("query", None)
        show_closed = (
            True if self.request.GET.get("show_closed", False) == "true" else False
        )
        if query:
            if not show_closed:
                qs = self.model.objects.filter(closed=False)
            else:
                qs = self.model.objects.all()
            fa = (
                "id",
                "machine__serial_number",
                "machine__company__name",
                "user__user__first_name",
                "user__user__last_name",
            )
            fb = ("hashtags",)
            fc = ("caseprogress__desc",)
            qs = self.model.objects.search(
                query, fa, fb, fc, qs=qs
            )
            return qs

Now I run a search and the query can be found in different tables, than in returns both results, even though i have distinct("id"). Why is that? I’ve read Django’s manual on this subject, but it doesn’t seem to apply in my case, since I am not ordering on the ralated fields.