src/Kunstmaan/NodeBundle/Repository/NodeTranslationRepository.php
public function getTopNodeTranslations()
    {
        $qb = $this->createQueryBuilder('b')
            ->select('b', 'v')
            ->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id')
            ->leftJoin(
                'b.publicNodeVersion',
                'v',
                'WITH',
                'b.publicNodeVersion = v.id'
            )
            ->where('n.parent IS NULL')
            ->andWhere('n.deleted != 1');

        return $qb->getQuery()->getResult();
    }
public function getTopNodeTranslations()
    {
        $qb = $this->createQueryBuilder('b')
            ->select('b', 'v')
            ->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id')
            ->leftJoin(
                'b.publicNodeVersion',
                'v',
                'WITH',
                'b.publicNodeVersion = v.id'
            )
            ->where('n.parent IS NULL')
            ->andWhere('n.deleted != 1');

        return $qb->getQuery()->getResult();
    }
public function getTopNodeTranslations ( ) { $ qb = $ this -> createQueryBuilder ( 'b' ) -> select ( 'b' , 'v' ) -> innerJoin ( 'b.node' , 'n' , 'WITH' , 'b.node = n.id' ) -> leftJoin ( 'b.publicNodeVersion' , 'v' , 'WITH' , 'b.publicNodeVersion = v.id' ) -> where ( 'n.parent IS NULL' ) -> andWhere ( 'n.deleted != 1' ) ; return $ qb -> getQuery ( ) -> getResult ( ) ; }
Get all top node translations

@return NodeTranslation[]
Get all top node translations