Changeset 5411 for temp/trunk

Timestamp:

2006/09/22 12:32:38 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/conf/conf.php (modified) (1 diff)

temp/trunk/data/conf/conf.php

@@ -847 +847 @@
         T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2,
         stock, price01, price02, stock_unlimited, product_code
-        FROM ( SELECT * FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2
+        FROM ( SELECT 
+                T1.product_class_id,
+                T1.product_id,
+                classcategory_id1,
+                classcategory_id2,
+                T2.rank,
+                T2.class_id,
+                stock,
+                price01,
+                price02,
+                stock_unlimited,
+                product_code        
+         FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2
         ON T1.classcategory_id1 = T2.classcategory_id))
         AS T3 LEFT JOIN dtb_classcategory AS T4