Changeset 4755 for temp


Ignore:
Timestamp:
2006/09/14 22:04:59 (20 years ago)
Author:
kakinaka
Message:

blank

File:
1 edited

Legend:

Unmodified
Added
Removed

  • temp/trunk/data/conf/conf.php

    r4712 r4755  
    782782     
    783783    "vw_products_allclass" => ' 
    784         (SELECT product_id,product_code_min,product_code_max,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max, 
    785         category_rank,category_id,del_flg,status,name,comment1,comment2,comment3,rank, 
    786         main_list_comment,main_image,main_list_image,product_flag,deliv_date_id,sale_limit,point_rate,sale_unlimited,create_date,deliv_fee 
    787         FROM (dtb_products AS T1 RIGHT JOIN  
    788         (SELECT  
    789         product_id AS product_id_sub, 
    790         MIN(product_code) AS product_code_min, 
    791         MAX(product_code) AS product_code_max, 
    792         MIN(price01) AS price01_min, 
    793         MAX(price01) AS price01_max, 
    794         MIN(price02) AS price02_min, 
    795         MAX(price02) AS price02_max, 
    796         MIN(stock) AS stock_min, 
    797         MAX(stock) AS stock_max, 
    798         MIN(stock_unlimited) AS stock_unlimited_min, 
    799         MAX(stock_unlimited) AS stock_unlimited_max 
    800         FROM dtb_products_class GROUP BY product_id) AS T2 
    801         ON T1.product_id = T2.product_id_sub) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4 
    802         ON T3.category_id = T4.sub_category_id) vw_products_allclass ', 
     784        (SELECT 
     785        product_id, 
     786        product_code_min, 
     787        product_code_max, 
     788        price01_min, 
     789        price01_max, 
     790        price02_min, 
     791        price02_max, 
     792        stock_min, 
     793        stock_max, 
     794        stock_unlimited_min, 
     795        stock_unlimited_max, 
     796        del_flg, 
     797        status, 
     798        name, 
     799        comment1, 
     800        comment2, 
     801        comment3, 
     802        rank, 
     803        main_list_comment, 
     804        main_image, 
     805        main_list_image, 
     806        product_flag, 
     807        deliv_date_id, 
     808        sale_limit, 
     809        point_rate, 
     810        sale_unlimited, 
     811        create_date, 
     812        deliv_fee 
     813        ,(SELECT rank AS category_rank FROM dtb_category AS T4 WHERE T1.category_id = T4.category_id) 
     814        ,(SELECT category_id AS sub_category_id FROM dtb_category T4 WHERE T1.category_id = T4.category_id) 
     815    FROM 
     816        dtb_products AS T1 RIGHT JOIN (SELECT product_id AS product_id_sub, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY product_id) AS T2 ON T1.product_id = T2.product_id_sub 
     817 
     818    ) vw_products_allclass ', 
    803819 
    804820    "vw_products_allclass_detail" => ' 
Note: See TracChangeset for help on using the changeset viewer.