Index: trunk/core/kernel/db/dblist.php =================================================================== diff -u -N -r2737 -r2761 --- trunk/core/kernel/db/dblist.php (.../dblist.php) (revision 2737) +++ trunk/core/kernel/db/dblist.php (.../dblist.php) (revision 2761) @@ -337,8 +337,14 @@ $totals = getArrayValue($field_options, 'totals'); if(!$totals) continue; - $field_expression = isset($this->CalculatedFields[$field_name]) ? $this->CalculatedFields[$field_name] : '`'.$this->TableName.'`.`'.$field_name.'`'; - $fields[$field_name] = $totals.'('.$field_expression.') AS '.$field_name.'_'.$totals; + $calculated_field = isset($this->CalculatedFields[$field_name]) && isset($this->VirtualFields[$field_name]); + $db_field = !isset($this->VirtualFields[$field_name]); + + if($calculated_field || $db_field) + { + $field_expression = $calculated_field ? $this->CalculatedFields[$field_name] : '`'.$this->TableName.'`.`'.$field_name.'`'; + $fields[$field_name] = $totals.'('.$field_expression.') AS '.$field_name.'_'.$totals; + } } if(!$fields) return false;