Changeset 4774 for temp/trunk/data/conf

Timestamp:

2006/09/15 12:24:02 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

temp/trunk/data/conf/conf.php

@@ -763 +763 @@
         (SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id,
         T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2
-        FROM vw_cross_class AS T1 LEFT JOIN dtb_products_class AS T2 
+        FROM 
+        (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
+        FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) vw_cross_class AS T1 LEFT JOIN dtb_products_class AS T2 
         ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) vw_cross_products_class ',