Sulu\Bundle\MediaBundle\Entity\FileVersionMetaRepository::findLatestWithoutSecurity PHP Method

    public function findLatestWithoutSecurity()
    {
        $queryBuilder = $this->createQueryBuilder('fileVersionMeta')->addSelect('fileVersion')->addSelect('file')->addSelect('media')->addSelect('collection')->leftJoin('fileVersionMeta.fileVersion', 'fileVersion')->leftJoin('fileVersion.file', 'file')->leftJoin('file.media', 'media')->leftJoin('media.collection', 'collection')->leftJoin(AccessControl::class, 'accessControl', 'WITH', 'accessControl.entityClass = :entityClass AND accessControl.entityId = collection.id')->where('file.version = fileVersion.version')->andWhere('accessControl.id is null');
        return $queryBuilder->setParameter('entityClass', Collection::class)->getQuery()->getResult();
    }

 public function testFindLatestWithoutSecurity()
 {
     $this->createFile('Old Title 1', 'New Title 1');
     $this->createFile('Old Title 2', 'New Title 2');
     $this->em->flush();
     $titles = array_map(function (FileVersionMeta $fileVersionMeta) {
         return $fileVersionMeta->getTitle();
     }, $this->fileVersionMetaRepository->findLatestWithoutSecurity());
     $this->assertContains('New Title 1', $titles);
     $this->assertContains('New Title 2', $titles);
     $this->assertNotContains('Old Title 1', $titles);
     $this->assertNotContains('Old Title 2', $titles);
 }