public function listGlobalEntries($languageCode = null, $offset = 0, $limit = -1)
{
$limit = $limit === -1 ? self::MAX_LIMIT : $limit;
/** @var $query \eZ\Publish\Core\Persistence\Database\SelectQuery */
$query = $this->dbHandler->createSelectQuery();
$query->select($this->dbHandler->quoteColumn('action'), $this->dbHandler->quoteColumn('id'), $this->dbHandler->quoteColumn('link'), $this->dbHandler->quoteColumn('is_alias'), $this->dbHandler->quoteColumn('alias_redirects'), $this->dbHandler->quoteColumn('lang_mask'), $this->dbHandler->quoteColumn('is_original'), $this->dbHandler->quoteColumn('parent'), $this->dbHandler->quoteColumn('text_md5'))->from($this->dbHandler->quoteTable($this->table))->where($query->expr->lAnd($query->expr->eq($this->dbHandler->quoteColumn('action_type'), $query->bindValue('module', null, \PDO::PARAM_STR)), $query->expr->eq($this->dbHandler->quoteColumn('is_original'), $query->bindValue(1, null, \PDO::PARAM_INT)), $query->expr->eq($this->dbHandler->quoteColumn('is_alias'), $query->bindValue(1, null, \PDO::PARAM_INT))))->limit($limit, $offset);
if (isset($languageCode)) {
$query->where($query->expr->gt($query->expr->bitAnd($this->dbHandler->quoteColumn('lang_mask'), $query->bindValue($this->languageMaskGenerator->generateLanguageIndicator($languageCode, false), null, \PDO::PARAM_INT)), 0));
}
$statement = $query->prepare();
$statement->execute();
return $statement->fetchAll(\PDO::FETCH_ASSOC);
}