Index: temp/trunk/html/admin/products/product_rank.php
===================================================================
--- temp/trunk/html/admin/products/product_rank.php	(revision 8412)
+++ temp/trunk/html/admin/products/product_rank.php	(revision 10311)
@@ -83,7 +83,11 @@
 			
 	// ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
-	$objQuery->setlimitoffset(SEARCH_PMAX, $startno);
+	if(DB_TYPE != "mysql") $objQuery->setlimitoffset(SEARCH_PMAX, $startno);
 	
 	$objQuery->setorder("rank DESC");
+	
+	// view¤â¹Ê¹þ¤ß¤ò¤«¤±¤ë(mysqlÍÑ)
+	sfViewWhere("&&noncls_where&&", $where, array($category_id), $objQuery->order . " " .  $objQuery->setlimitoffset(SEARCH_PMAX, $startno, true));
+	
 	$arrRet = $objQuery->select($col, $table, $where, array($category_id));
 	return $arrRet;