Changeset 4871 for temp/trunk

Timestamp:

2006/09/17 17:34:34 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/conf.php (modified) (1 diff)
• html/frontparts/bloc/best5.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 (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2
-        ON T1.classcategory_id1 = T2.classcategory_id)
+        FROM ( SELECT * 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
         ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6

temp/trunk/html/frontparts/bloc/best5.php

@@ -25 +25 @@
     $objQuery = new SC_Query();
     
-    $col = "A.*, B.name, B.price02_min, B.price01_min, B.main_list_image ";
-    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS B ON A.product_id = B.product_id";
+    $col = "A.*, vw_products_allclass.name, vw_products_allclass.price02_min, vw_products_allclass.price01_min, vw_products_allclass.main_list_image ";
+    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass ON A.product_id = vw_products_allclass.product_id";
     $where = "status = 1";
     $order = "rank";