Index: temp/trunk/html/admin/batch/daily.php
===================================================================
--- temp/trunk/html/admin/batch/daily.php	(revision 4842)
+++ temp/trunk/html/admin/batch/daily.php	(revision 4909)
@@ -105,11 +105,11 @@
 	$sql.= "COUNT(*) AS total_order, ";
 	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.customer_id = 0) AS nonmember ) AS nonmember, ";
-/*	$sql.= "SUM((SELECT COUNT(*) WHERE customer_id <> 0 GROUP BY customer_id)) AS member, ";
-	$sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1)) AS men, ";
-	$sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2)) AS women, ";
-	$sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1 AND customer_id <> 0)) AS men_member, ";
-	$sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1 AND customer_id = 0)) AS men_nonmember, ";
-	$sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2 AND customer_id <> 0)) AS women_member, ";
-	$sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2 AND customer_id = 0)) AS women_nonmember, ";*/
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.customer_id <> 0) AS nonmember ) AS member, ";
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1) AS nonmember ) AS men, ";
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2)) AS nonmember ) AS women, ";
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1 AND customer_id <> 0)) AS nonmember ) AS men_member, ";
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1 AND customer_id = 0) AS nonmember ) AS men_nonmember, ";
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2 AND customer_id <> 0) AS nonmember ) AS women_member, ";
+	$sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2 AND customer_id = 0) AS nonmember ) AS women_nonmember, ";
 	$sql.= "SUM(total) AS total, ";
 	$sql.= "(AVG(total)) AS total_average ";
Index: temp/trunk/html/admin/products/review.php
===================================================================
--- temp/trunk/html/admin/products/review.php	(revision 4908)
+++ temp/trunk/html/admin/products/review.php	(revision 4909)
@@ -163,5 +163,4 @@
 					$where.= " AND A.create_date <= ? ";
 					$arrval[] = $date;
-					sfprintr($date);
 				}
 				break;