Changeset 13450

Timestamp:

2007/05/25 15:07:57 (17 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/html/admin/total/index.php (modified) (1 diff)

branches/dev/html/admin/total/index.php

@@ -661 +661 @@
     $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average ";
     $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 and T2.status <> " . ORDER_CANCEL;
-    $sql.= "GROUP BY job ORDER BY total DESC";
+    $sql.= " GROUP BY job ORDER BY total DESC";
     
     $objQuery = new SC_Query();