Changeset 13449 for branches/rel


Ignore:
Timestamp:
2007/05/25 14:28:47 (15 years ago)
Author:
kakinaka
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/rel/html/admin/total/index.php

    r13426 r13449  
    654654    $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average "; 
    655655    $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; 
    656     $sql.= "GROUP BY job ORDER BY total DESC"; 
     656    $sql.= " GROUP BY job ORDER BY total DESC"; 
    657657     
    658658    $objQuery = new SC_Query(); 
Note: See TracChangeset for help on using the changeset viewer.