Index: /branches/dev/html/admin/total/index.php
===================================================================
--- /branches/dev/html/admin/total/index.php (revision 12022)
+++ /branches/dev/html/admin/total/index.php (revision 12023)
@@ -625,5 +625,5 @@
$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.= ") ";
+ $sql.= ") AS T1 ";
$sql.= "ORDER BY T1.total DESC ";