Changeset 18441

Timestamp:

2009/12/21 10:46:13 (14 years ago)

Author:

Seasoft

Message:

複数カテゴリへの割り当てている商品が、複数表示される不具合を修正。

• 利用者様からメールにて不具合報告。

File:

• branches/comu-ver2/html/user_data/plugins/recommend/classes/LC_Page_FrontParts_Bloc_Recommend.php (modified) (1 diff)

branches/comu-ver2/html/user_data/plugins/recommend/classes/LC_Page_FrontParts_Bloc_Recommend.php

@@ -82 +82 @@
 
         $objQuery = new SC_Query();
-        $cols = '*, (SELECT COUNT(*) FROM dtb_order_detail WHERE product_id = allcls.product_id) AS cnt';
-        $from = 'vw_products_allclass AS allcls';
+        $cols = '*, (SELECT COUNT(*) FROM dtb_order_detail WHERE product_id = alldtl.product_id) AS cnt';
+        $from = 'vw_products_allclass_detail AS alldtl';
         $where = <<< __EOS__
             del_flg = 0