saucisse

$repository->createQueryBuilder('a')
            ->select('e.titre, e.codeMorceau, m.nomMusicien, m.prenomMusicien, a.codeAlbum')
            ->innerJoin(Disque::class, 'd', JOIN::WITH, 'a.codeAlbum = d.codeAlbum')
            ->innerJoin(CompositionDisque::class, 'c_d', JOIN::WITH, 'd.codeDisque = c_d.codeDisque')
            ->innerJoin(Enregistrement::class, 'e', JOIN::WITH, 'c_d.codeMorceau= e.codeMorceau')
            ->innerJoin(Composition::class, 'c', JOIN::WITH, 'e.codeComposition = c.codeComposition')
            ->innerJoin(CompositionOeuvre::class, 'c_o', JOIN::WITH, 'c.codeComposition = c_o.codeComposition')
            ->innerJoin(Oeuvre::class, 'o', JOIN::WITH, 'c_o.codeOeuvre= o.codeOeuvre')
            ->innerJoin(Composer::class, 'comp', JOIN::WITH, 'o.codeOeuvre = comp.codeOeuvre')
            ->innerJoin(Musicien::class, 'm', JOIN::WITH, 'comp.codeMusicien = m.codeMusicien')
            ->where('m.codeMusicien = :id')
            ->distinct()
            ->setParameter('id', $id)