lib/Persistence/Doctrine/QueryHandler/CollectionQueryHandler.php
private function getQuerySelectQuery(): QueryBuilder
    {
        $query = $this->connection->createQueryBuilder();
        $query->select('DISTINCT q.*, qt.*')
            ->from('ngbm_collection_query', 'q')
            ->innerJoin(
                'q',
                'ngbm_collection_query_translation',
                'qt',
                $query->expr()->andX(
                    $query->expr()->eq('qt.query_id', 'q.id'),
                    $query->expr()->eq('qt.status', 'q.status')
                )
            );

        return $query;
    }
private function getQuerySelectQuery(): QueryBuilder
    {
        $query = $this->connection->createQueryBuilder();
        $query->select('DISTINCT q.*, qt.*')
            ->from('ngbm_collection_query', 'q')
            ->innerJoin(
                'q',
                'ngbm_collection_query_translation',
                'qt',
                $query->expr()->andX(
                    $query->expr()->eq('qt.query_id', 'q.id'),
                    $query->expr()->eq('qt.status', 'q.status')
                )
            );

        return $query;
    }
private function getQuerySelectQuery ( ) : QueryBuilder { $ query = $ this -> connection -> createQueryBuilder ( ) ; $ query -> select ( 'DISTINCT q.*, qt.*' ) -> from ( 'ngbm_collection_query' , 'q' ) -> innerJoin ( 'q' , 'ngbm_collection_query_translation' , 'qt' , $ query -> expr ( ) -> andX ( $ query -> expr ( ) -> eq ( 'qt.query_id' , 'q.id' ) , $ query -> expr ( ) -> eq ( 'qt.status' , 'q.status' ) ) ) ; return $ query ; }
Builds and returns a block database SELECT query.
Builds and returns a block database SELECT query .