Index: /branches/version-2_11-dev/data/Smarty/templates/admin/products/product_select.tpl
===================================================================
--- /branches/version-2_11-dev/data/Smarty/templates/admin/products/product_select.tpl	(revision 21329)
+++ /branches/version-2_11-dev/data/Smarty/templates/admin/products/product_select.tpl	(revision 21409)
@@ -88,10 +88,5 @@
                     <img src="<!--{$smarty.const.ROOT_URLPATH}-->resize_image.php?image=<!--{$arrProducts[cnt].main_list_image|sfNoImageMainList|h}-->&amp;width=65&amp;height=65" alt="<!--{$arrRecommend[$recommend_no].name|h}-->" />
                 </td>
-                <td>
-                    <!--{$arrProducts[cnt].product_code_min|h}-->
-                    <!--{if $arrProducts[cnt].product_code_min != $arrProducts[cnt].product_code_max}-->
-                        ～ <!--{$arrProducts[cnt].product_code_max|h}-->
-                    <!--{/if}-->
-                </td>
+                <td><!--{$arrProducts[cnt].product_code|default:"-"|h}--></td>
                 <td><!--{$arrProducts[cnt].name|h}--></td>
                 <td align="center"><a href="#" onclick="return func_submit(<!--{$arrProducts[cnt].product_id|h}-->)">決定</a></td>
Index: /branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php
===================================================================
--- /branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php	(revision 21402)
+++ /branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php	(revision 21409)
@@ -657,6 +657,6 @@
         // 在庫無し商品の非表示
         if (NOSTOCK_HIDDEN) {
-            $where_products_class = '(stock >= 1 OR stock_unlimited = 1)';
-            $from = $objProduct->alldtlSQL($where_products_class);
+            $sql_where_dtl = '(stock >= 1 OR stock_unlimited = 1)';
+            $from = $objProduct->alldtlSQL($sql_where_dtl);
         }else{
             $from = 'dtb_products as alldtl';
Index: /branches/version-2_11-dev/data/class/SC_Product.php
===================================================================
--- /branches/version-2_11-dev/data/class/SC_Product.php	(revision 21405)
+++ /branches/version-2_11-dev/data/class/SC_Product.php	(revision 21409)
@@ -165,5 +165,6 @@
             ,update_date
 __EOS__;
-        $res = $objQuery->select($col, $this->alldtlSQL());
+        $where = 'dtb_products_class.del_flg = 0';
+        $res = $objQuery->select($col, $this->alldtlSQL($where));
         return $res;
     }
@@ -221,5 +222,5 @@
     function getDetail($productId) {
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $result = $objQuery->select("*", $this->alldtlSQL('product_id = ?'),
+        $result = $objQuery->select("*", $this->alldtlSQL("product_id = ? AND del_flg = 0"),
                                     "product_id = ?",
                                     array($productId, $productId));
@@ -688,5 +689,5 @@
         $where_clause = '';
         if (!SC_Utils_Ex::isBlank($where_products_class)) {
-            $where_products_class = 'AND (' . $where_products_class . ')';
+            $where_clause = 'WHERE ' . $where_products_class;
         }
         /*
@@ -773,5 +774,5 @@
                               COUNT(*) as class_count
                         FROM dtb_products_class
-                        WHERE del_flg = 0 $where_products_class
+                        $where_clause
                         GROUP BY product_id
                     ) AS T4
Index: /branches/version-2_11-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php
===================================================================
--- /branches/version-2_11-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php	(revision 21328)
+++ /branches/version-2_11-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php	(revision 21409)
@@ -383,5 +383,5 @@
         // 読み込む列とテーブルの指定
         $col = "product_id, name, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, update_date";
-        $from = $objProduct->alldtlSQL();
+        $from = $objProduct->alldtlSQL('del_flg = 0');
 
         $objQuery->setLimitOffset($limit, $offset);