diff options
Diffstat (limited to 'modules-available/statistics/inc/hardwarequerycolumn.inc.php')
-rw-r--r-- | modules-available/statistics/inc/hardwarequerycolumn.inc.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/modules-available/statistics/inc/hardwarequerycolumn.inc.php b/modules-available/statistics/inc/hardwarequerycolumn.inc.php index 07e7ecec..8aab6a54 100644 --- a/modules-available/statistics/inc/hardwarequerycolumn.inc.php +++ b/modules-available/statistics/inc/hardwarequerycolumn.inc.php @@ -24,7 +24,7 @@ class HardwareQueryColumn $this->global = $global; $this->tableAlias = self::getId(); $this->virtualColumnName = $column; - $this->alias = $alias ?? $column; + $this->alias = '`' . ($alias ?? $column) . '`'; } /** @@ -54,9 +54,9 @@ class HardwareQueryColumn $type = count($this->conditions) === 1 ? 'LEFT' : 'INNER'; $joins[] = "$type JOIN $table $tid ON (" . implode(' AND ', $this->conditions) . ")"; if (!empty($groupConcat) && !in_array($this->alias, $groupConcat)) { - $columns[] = "Group_Concat(DISTINCT $tid.`value` SEPARATOR ', ') AS `{$this->alias}`"; + $columns[] = "Group_Concat(DISTINCT $tid.`value` SEPARATOR ', ') AS {$this->alias}"; } else { - $columns[] = "$tid.`value` AS `{$this->alias}`"; + $columns[] = "$tid.`value` AS {$this->alias}"; } $params += $this->params; } |