- Timestamp:
- 2014/10/27 11:22:40 (9 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/db/SC_DB_DBFactory.php
r23605 r23664 268 268 ,T4.point_rate 269 269 ,T4.deliv_fee 270 ,T4.class_count271 270 ,dtb_maker.name AS maker_name 272 271 FROM dtb_products 273 272 INNER JOIN ( 274 SELECT product_id, 275 MIN(product_code) AS product_code_min, 276 MAX(product_code) AS product_code_max, 277 MIN(price01) AS price01_min, 278 MAX(price01) AS price01_max, 279 MIN(price02) AS price02_min, 280 MAX(price02) AS price02_max, 281 MIN(stock) AS stock_min, 282 MAX(stock) AS stock_max, 283 MIN(stock_unlimited) AS stock_unlimited_min, 284 MAX(stock_unlimited) AS stock_unlimited_max, 285 MAX(point_rate) AS point_rate, 286 MAX(deliv_fee) AS deliv_fee, 287 COUNT(*) as class_count 273 SELECT product_id 274 ,MIN(product_code) AS product_code_min 275 ,MAX(product_code) AS product_code_max 276 ,MIN(price01) AS price01_min 277 ,MAX(price01) AS price01_max 278 ,MIN(price02) AS price02_min 279 ,MAX(price02) AS price02_max 280 ,MIN(stock) AS stock_min 281 ,MAX(stock) AS stock_max 282 ,MIN(stock_unlimited) AS stock_unlimited_min 283 ,MAX(stock_unlimited) AS stock_unlimited_max 284 ,MAX(point_rate) AS point_rate 285 ,MAX(deliv_fee) AS deliv_fee 288 286 FROM dtb_products_class 289 287 WHERE del_flg = 0 $where_products_class
Note: See TracChangeset
for help on using the changeset viewer.