Index: branches/version-2_4/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
===================================================================
--- branches/version-2_4/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php	(revision 17526)
+++ branches/version-2_4/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php	(revision 17819)
@@ -71,16 +71,16 @@
         return $sql;
     }
-    
+
     /**
      * 文字コード情報を取得する
-     * 
+     *
      * @return array 文字コード情報
      */
      function getCharSet() {
-     	$objQuery = new SC_Query();
-     	$arrRet = $objQuery->getAll("SHOW VARIABLES LIKE 'char%'");
-     	return $arrRet;
+         $objQuery = new SC_Query();
+         $arrRet = $objQuery->getAll("SHOW VARIABLES LIKE 'char%'");
+         return $arrRet;
      }
-    
+
     /**
      * テーブルの存在チェックを行う SQL 文を返す.
@@ -246,5 +246,5 @@
         return $changesql;
     }
-    
+
     /**
      * WHERE 句置換用の配列を返す.
@@ -341,4 +341,5 @@
                     T1.create_date,
                     T1.update_date,
+                    T1.note,
                     T1.deliv_date_id,
                     T2.product_id_sub,
@@ -396,6 +397,6 @@
                FROM dtb_category AS T4
               WHERE T1.category_id = T4.category_id) as category_rank
-           ,(SELECT category_id AS sub_category_id 
-               FROM dtb_category T4 
+           ,(SELECT category_id AS sub_category_id
+               FROM dtb_category T4
               WHERE T1.category_id = T4.category_id) as category_id
       FROM (SELECT T0.product_id,
@@ -420,5 +421,5 @@
               FROM dtb_products AS T0
          LEFT JOIN dtb_product_categories AS T00
-             USING (product_id)) AS T1 
+             USING (product_id)) AS T1
 RIGHT JOIN (SELECT product_id as product_id_sub,
                    MIN(product_code) AS product_code_min,
@@ -432,5 +433,5 @@
                    MIN(stock_unlimited) AS stock_unlimited_min,
                    MAX(stock_unlimited) AS stock_unlimited_max
-              FROM dtb_products_class GROUP BY product_id) AS T2 
+              FROM dtb_products_class GROUP BY product_id) AS T2
                 ON T1.product_id = T2.product_id_sub
             ) ',