Index: temp/trunk/data/conf/conf.php
===================================================================
--- temp/trunk/data/conf/conf.php	(revision 10223)
+++ temp/trunk/data/conf/conf.php	(revision 10225)
@@ -761,4 +761,16 @@
 );
 
+
+// View¤ÎWhere¶çÃÖ´¹ÍÑ
+$arrViewWhere = array(
+	"&&crscls_where&&" => "",
+	"&&crsprdcls_where&&" =>"",
+	"&&noncls_where&&" => "",
+	"&&allcls_where&&" => "",
+	"&&allclsdtl_where&&" => "",
+	"&&prdcls_where&&" => "",
+	"&&catcnt_where&&" => ""
+);
+
 // ViewÊÑ´¹ÍÑ(MySQLÂбþ)
 $arrView = array(
@@ -775,5 +787,70 @@
 
 	"vw_products_nonclass" => '
-		(SELECT * FROM dtb_products AS T1 LEFT JOIN 
+		(SELECT 
+		    T1.product_id,
+		    T1.name,
+		    T1.deliv_fee,
+		    T1.sale_limit,
+		    T1.sale_unlimited,
+		    T1.category_id,
+		    T1.rank,
+		    T1.status,
+		    T1.product_flag,
+		    T1.point_rate,
+		    T1.comment1,
+		    T1.comment2,
+		    T1.comment3,
+		    T1.comment4,
+		    T1.comment5,
+		    T1.comment6,
+		    T1.file1,
+		    T1.file2,
+		    T1.file3,
+		    T1.file4,
+		    T1.file5,
+		    T1.file6,
+		    T1.main_list_comment,
+		    T1.main_list_image,
+		    T1.main_comment,
+		    T1.main_image,
+		    T1.main_large_image,
+		    T1.sub_title1,
+		    T1.sub_comment1,
+		    T1.sub_image1,
+		    T1.sub_large_image1,
+		    T1.sub_title2,
+		    T1.sub_comment2,
+		    T1.sub_image2,
+		    T1.sub_large_image2,
+		    T1.sub_title3,
+		    T1.sub_comment3,
+		    T1.sub_image3,
+		    T1.sub_large_image3,
+		    T1.sub_title4,
+		    T1.sub_comment4,
+		    T1.sub_image4,
+		    T1.sub_large_image4,
+		    T1.sub_title5,
+		    T1.sub_comment5,
+		    T1.sub_image5,
+		    T1.sub_large_image5,
+		    T1.sub_title6,
+		    T1.sub_comment6,
+		    T1.sub_image6,
+		    T1.sub_large_image6,
+		    T1.del_flg,
+		    T1.creator_id,
+		    T1.create_date,
+		    T1.update_date,
+		    T1.deliv_date_id,
+		    T2.product_id_sub,
+		    T2.product_code,
+		    T2.price01,
+		    T2.price02,
+		    T2.stock,
+		    T2.stock_unlimited,
+		    T2.classcategory_id1,
+		    T2.classcategory_id2
+		FROM (SELECT * FROM dtb_products &&noncls_where&&) AS T1 LEFT JOIN 
 		(SELECT
 		product_id AS product_id_sub,
Index: temp/trunk/data/lib/slib.php
===================================================================
--- temp/trunk/data/lib/slib.php	(revision 10140)
+++ temp/trunk/data/lib/slib.php	(revision 10225)
@@ -2511,5 +2511,5 @@
 }
 
-// ÇÛÎó¤ÎÃæ¤Ë¥Ç¡¼¥¿¤¬Â¸ºß¤·¤Æ¤¤¤ë¤«¥Á¥§¥Ã¥¯¤ò¹Ô¤¦(Âçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤ʤ·)
+// SQL¤ÎÃæ¤Ëview¤¬Â¸ºß¤·¤Æ¤¤¤ë¤«¥Á¥§¥Ã¥¯¤ò¹Ô¤¦¡£
 function sfInArray($sql){
 	global $arrView;
@@ -2527,6 +2527,15 @@
 function sfChangeView($sql){
 	global $arrView;
-
-	$changesql = strtr($sql,$arrView);
+	global $arrViewWhere;
+	
+	$arrViewTmp = $arrView;
+
+	// view¤Îwhere¤òÊÑ´¹
+	foreach($arrViewTmp as $key => $val){
+		$arrViewTmp[$key] = strtr($arrViewTmp[$key], $arrViewWhere);
+	}
+	
+	// view¤òÊÑ´¹
+	$changesql = strtr($sql, $arrViewTmp);
 
 	return $changesql;