Index: branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php	(revision 20541)
+++ branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php	(revision 20548)
@@ -120,5 +120,7 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $col = "product_id, name, main_list_image, product_code_min, product_code_max, status";
-        $table = "vw_products_allclass AS allcls";
+        $objProduct = new SC_Product();
+        $table = $objProduct->alldtlSQL();
+        $table.= " LEFT JOIN dtb_product_categories AS T5 USING(product_id)";
         $where = "del_flg = 0 AND category_id = ?";
 
@@ -138,5 +140,5 @@
         $objQuery->setLimitOffset(SEARCH_PMAX, $startno);
 
-        $objQuery->setOrder("product_rank DESC, product_id DESC");
+        $objQuery->setOrder("rank DESC, product_id DESC");
 
         $arrRet = $objQuery->select($col, $table, $where, array($category_id));