- Timestamp:
- 2006/09/17 13:24:38 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/admin/total/index.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/total/index.php
r4842 r4843 615 615 616 616 $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average "; 617 $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 ";617 $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 "; 618 618 $sql.= "GROUP BY job ORDER BY total DESC"; 619 619
Note: See TracChangeset
for help on using the changeset viewer.
