djadhere/services/views.py

from django.views.generic import DetailView
from django.contrib.auth.mixins import LoginRequiredMixin

from .models import Service


class ServiceDetail(LoginRequiredMixin, DetailView):
    def get_queryset(self):
        adhesions = self.request.user.profile.adhesions.values_list('pk')
        return Service.objects.filter(adhesion__pk__in=adhesions).order_by('service_type')