Changeset 4877 for temp/trunk

Timestamp:

2006/09/17 18:21:59 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/conf/conf.php (modified) (2 diffs)

temp/trunk/data/conf/conf.php

@@ -827 +827 @@
         sub_title5,sub_comment5,sub_image5,sub_large_image5,
         product_flag,deliv_date_id,sale_limit,point_rate,sale_unlimited,file1,file2,category_id
-        FROM (dtb_products AS T1 RIGHT JOIN 
+        FROM ( SELECT * FROM (dtb_products AS T1 RIGHT JOIN 
         (SELECT 
         product_id AS product_id_sub,
@@ -838 +838 @@
         MIN(stock_unlimited) AS stock_unlimited_min,
         MAX(stock_unlimited) AS stock_unlimited_max
-        FROM (SELECT * FROM (dtb_products_class GROUP BY product_id) AS T2
-        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
+        FROM dtb_products_class GROUP BY product_id) AS T2
+        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
         ON T3.category_id = T4.sub_category_id) vw_products_allclass_detail ',