query.php

        $qb = $repository
            ->createQueryBuilder('f')
            ->select('f')
            ->join('f.address', 'a')
            ->join('a.locality', 'l')
            ->join('l.canton', 'c')
            ->leftJoin('f.facilities', 'fa', Join::WITH, 'fa.deleted <> 1')
            ->leftJoin('f.users', 'u', Join::WITH, 'u.deleted <> 1')
            ->leftJoin('u.roles', 'r', Join::WITH, 'r.id = :role')
            ->join('f.events', 'e')
            ->where('f.deleted <> 1');