private function createLoadContentInfoQueryBuilder(bool $joinMainLocation = true): DoctrineQueryBuilder
    {
        $queryBuilder = $this->connection->createQueryBuilder();
        $expr = $queryBuilder->expr();

        $joinCondition = $expr->eq('c.id', 't.contentobject_id');
        if ($joinMainLocation) {
            // wrap join condition with AND operator and join by a Main Location
            $joinCondition = $expr->andX(
                $joinCondition,
                $expr->eq('t.node_id', 't.main_node_id')
            );
        }

        $queryBuilder
            ->select('c.*', 't.main_node_id AS ezcontentobject_tree_main_node_id')
            ->from('ezcontentobject', 'c')
            ->leftJoin(
                'c',
                'ezcontentobject_tree',
                't',
                $joinCondition
            );

        return $queryBuilder;
    }
private function createLoadContentInfoQueryBuilder(bool $joinMainLocation = true): DoctrineQueryBuilder
    {
        $queryBuilder = $this->connection->createQueryBuilder();
        $expr = $queryBuilder->expr();

        $joinCondition = $expr->eq('c.id', 't.contentobject_id');
        if ($joinMainLocation) {
            // wrap join condition with AND operator and join by a Main Location
            $joinCondition = $expr->andX(
                $joinCondition,
                $expr->eq('t.node_id', 't.main_node_id')
            );
        }

        $queryBuilder
            ->select('c.*', 't.main_node_id AS ezcontentobject_tree_main_node_id')
            ->from('ezcontentobject', 'c')
            ->leftJoin(
                'c',
                'ezcontentobject_tree',
                't',
                $joinCondition
            );

        return $queryBuilder;
    }
private function createLoadContentInfoQueryBuilder ( bool $ joinMainLocation = true ) : DoctrineQueryBuilder { $ queryBuilder = $ this -> connection -> createQueryBuilder ( ) ; $ expr = $ queryBuilder -> expr ( ) ; $ joinCondition = $ expr -> eq ( 'c.id' , 't.contentobject_id' ) ; if ( $ joinMainLocation ) { // wrap join condition with AND operator and join by a Main Location $ joinCondition = $ expr -> andX ( $ joinCondition , $ expr -> eq ( 't.node_id' , 't.main_node_id' ) ) ; } $ queryBuilder -> select ( 'c.*' , 't.main_node_id AS ezcontentobject_tree_main_node_id' ) -> from ( 'ezcontentobject' , 'c' ) -> leftJoin ( 'c' , 'ezcontentobject_tree' , 't' , $ joinCondition ) ; return $ queryBuilder ; }
Get query builder to load Content Info data.

@see loadContentInfo(), loadContentInfoByRemoteId(), loadContentInfoList(), loadContentInfoByLocationId()

@param bool $joinMainLocation

@return \Doctrine\DBAL\Query\QueryBuilder
Get query builder to load Content Info data .