Changeset 4872 for temp/trunk

Timestamp:

2006/09/17 17:36:11 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/conf.php (modified) (2 diffs)
• html/frontparts/bloc/best5.php (modified) (1 diff)

temp/trunk/data/conf/conf.php

@@ -783 +783 @@
     
     "vw_products_allclass" => '
-        (SELECT
+        ((SELECT
         product_id,
         product_code_min,
@@ -816 +816 @@
     FROM
         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
-    ) vw_products_allclass ',
+    ) vw_products_allclass )',
 
     "vw_products_allclass_detail" => '

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

@@ -25 +25 @@
     $objQuery = new SC_Query();
     
-    $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";
+    $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";
     $where = "status = 1";
     $order = "rank";