Changeset 4873 for temp

Timestamp:

2006/09/17 17:39:21 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/frontparts/bloc/best5.php (modified) (1 diff)

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.*, name, price02_min, price01_min, main_list_image ";
+    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass using(product_id)";
     $where = "status = 1";
     $order = "rank";