Index: branches/dev/html/admin/total/index.php
===================================================================
--- branches/dev/html/admin/total/index.php	(revision 13414)
+++ branches/dev/html/admin/total/index.php	(revision 13415)
@@ -659,9 +659,12 @@
 	
 	$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";
+	$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";
 	
 	$objQuery = new SC_Query();
 	$objPage->arrResults = $objQuery->getall($sql, $arrval);
+    
+    
+    sfprintr($objQuery->getlastquery(false));
 			
 	$max = count($objPage->arrResults);