Index: /branches/dev/html/admin/total/index.php
===================================================================
--- /branches/dev/html/admin/total/index.php (revision 12024)
+++ /branches/dev/html/admin/total/index.php (revision 12025)
@@ -624,5 +624,5 @@
$sql.= "(price * sum(quantity)) AS total ";
$sql.= "FROM dtb_order_detail WHERE order_id IN (SELECT order_id FROM dtb_order WHERE $where ) ";
- $sql.= "GROUP BY product_id, product_code, price ";
+ $sql.= "GROUP BY product_id, product_name, product_code, price ";
$sql.= ") AS T1 ";
$sql.= "ORDER BY T1.total DESC ";