Changeset 4822 for temp/trunk/html/admin/batch
- Timestamp:
- 2006/09/16 21:15:41 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/admin/batch/daily.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/batch/daily.php
r4821 r4822 104 104 $sql = "SELECT "; 105 105 $sql.= "COUNT(*) AS total_order, "; 106 $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND customer_id = 0) AS nonmember ) AS nonmember, ";106 $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.customer_id = 0) AS nonmember ) AS nonmember, "; 107 107 /* $sql.= "SUM((SELECT COUNT(*) WHERE customer_id <> 0 GROUP BY customer_id)) AS member, "; 108 108 $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1)) AS men, ";
Note: See TracChangeset
for help on using the changeset viewer.
