private function getAllUrlAliasesQuery(): string
    {
        $existingAliasesQueryBuilder = $this->connection->createQueryBuilder();
        $innerQueryBuilder = $this->connection->createQueryBuilder();

        return $existingAliasesQueryBuilder
            ->select('tmp.id')
            ->from(
                // nest subquery to avoid same-table update error
                '(' . $innerQueryBuilder->select('id')->from($this->table)->getSQL() . ')',
                'tmp'
            )
            ->getSQL();
    }
private function getAllUrlAliasesQuery(): string
    {
        $existingAliasesQueryBuilder = $this->connection->createQueryBuilder();
        $innerQueryBuilder = $this->connection->createQueryBuilder();

        return $existingAliasesQueryBuilder
            ->select('tmp.id')
            ->from(
                // nest subquery to avoid same-table update error
                '(' . $innerQueryBuilder->select('id')->from($this->table)->getSQL() . ')',
                'tmp'
            )
            ->getSQL();
    }
private function getAllUrlAliasesQuery ( ) : string { $ existingAliasesQueryBuilder = $ this -> connection -> createQueryBuilder ( ) ; $ innerQueryBuilder = $ this -> connection -> createQueryBuilder ( ) ; return $ existingAliasesQueryBuilder -> select ( 'tmp.id' ) -> from ( // nest subquery to avoid same-table update error '(' . $ innerQueryBuilder -> select ( 'id' ) -> from ( $ this -> table ) -> getSQL ( ) . ')' , 'tmp' ) -> getSQL ( ) ; }
Get subquery for IDs of all URL aliases.

@return string Query
Get subquery for IDs of all URL aliases .