Index: branches/dev/html/admin/total/index_sub.php
===================================================================
--- branches/dev/html/admin/total/index_sub.php	(revision 17)
+++ branches/dev/html/admin/total/index_sub.php	(revision 12022)
@@ -135,5 +135,5 @@
 		$arrDataCol = array(
 			'product_code',
-			'name',
+			'product_name',
 			'order_count',
 			'products_count',
Index: branches/dev/html/admin/total/index.php
===================================================================
--- branches/dev/html/admin/total/index.php	(revision 57)
+++ branches/dev/html/admin/total/index.php	(revision 12022)
@@ -617,5 +617,5 @@
 	list($where, $arrval) = lfGetWhereMember('create_date', $sdate, $edate, $type);
 	
-	$sql = "SELECT T1.product_id, T1.product_code, T2.name, T1.products_count, T1.order_count, T1.price, T1.total ";
+	$sql = "SELECT T1.product_id, T1.product_code, T1.product_name, T1.products_count, T1.order_count, T1.price, T1.total ";
 	$sql.= "FROM ( ";
 	$sql.= "SELECT product_id, product_code, price, ";
@@ -626,5 +626,5 @@
 	$sql.= "GROUP BY product_id, product_code, price ";
 	$sql.= ") ";
-	$sql.= "AS T1 LEFT JOIN dtb_products AS T2 USING (product_id) WHERE T2.name IS NOT NULL AND status = 1 ORDER BY T1.total DESC ";
+	$sql.= "ORDER BY T1.total DESC ";
 	
 	if($mode != "csv") {
Index: branches/dev/data/Smarty/templates/admin/total/page_products.tpl
===================================================================
--- branches/dev/data/Smarty/templates/admin/total/page_products.tpl	(revision 17)
+++ branches/dev/data/Smarty/templates/admin/total/page_products.tpl	(revision 12022)
@@ -31,5 +31,5 @@
 		<td align="center"><!--{*½ç°Ì*}--><!--{$smarty.section.cnt.iteration}--></td>
 		<td align="right"><!--{*¾¦ÉÊÈÖ¹æ*}--><!--{$arrResults[cnt].product_code|escape}--></td>
-		<td align="left"><!--{*¾¦ÉÊ̾*}--><!--{$arrResults[cnt].name|sfCutString:40|escape}--></td>
+		<td align="left"><!--{*¾¦ÉÊ̾*}--><!--{$arrResults[cnt].product_name|sfCutString:40|escape}--></td>
 		<td align="right"><!--{*¹ØÆþ·ï¿ô*}--><!--{$arrResults[cnt].order_count}-->·ï</td>
 		<td align="right"><!--{*ÅÀ¿ô*}--><!--{$arrResults[cnt].products_count}--></td>