Changeset 17819
- Timestamp:
- 2009/02/20 20:01:33 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_4/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
r17526 r17819 71 71 return $sql; 72 72 } 73 73 74 74 /** 75 75 * 文字コード情報を取得する 76 * 76 * 77 77 * @return array 文字コード情報 78 78 */ 79 79 function getCharSet() { 80 81 82 80 $objQuery = new SC_Query(); 81 $arrRet = $objQuery->getAll("SHOW VARIABLES LIKE 'char%'"); 82 return $arrRet; 83 83 } 84 84 85 85 /** 86 86 * テーブルの存在チェックを行う SQL 文を返す. … … 246 246 return $changesql; 247 247 } 248 248 249 249 /** 250 250 * WHERE 句置換用の配列を返す. … … 341 341 T1.create_date, 342 342 T1.update_date, 343 T1.note, 343 344 T1.deliv_date_id, 344 345 T2.product_id_sub, … … 396 397 FROM dtb_category AS T4 397 398 WHERE T1.category_id = T4.category_id) as category_rank 398 ,(SELECT category_id AS sub_category_id 399 FROM dtb_category T4 399 ,(SELECT category_id AS sub_category_id 400 FROM dtb_category T4 400 401 WHERE T1.category_id = T4.category_id) as category_id 401 402 FROM (SELECT T0.product_id, … … 420 421 FROM dtb_products AS T0 421 422 LEFT JOIN dtb_product_categories AS T00 422 USING (product_id)) AS T1 423 USING (product_id)) AS T1 423 424 RIGHT JOIN (SELECT product_id as product_id_sub, 424 425 MIN(product_code) AS product_code_min, … … 432 433 MIN(stock_unlimited) AS stock_unlimited_min, 433 434 MAX(stock_unlimited) AS stock_unlimited_max 434 FROM dtb_products_class GROUP BY product_id) AS T2 435 FROM dtb_products_class GROUP BY product_id) AS T2 435 436 ON T1.product_id = T2.product_id_sub 436 437 ) ',
Note: See TracChangeset
for help on using the changeset viewer.