Changeset 18441


Ignore:
Timestamp:
2009/12/21 10:46:13 (11 years ago)
Author:
Seasoft
Message:

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

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

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/html/user_data/plugins/recommend/classes/LC_Page_FrontParts_Bloc_Recommend.php

    r18371 r18441  
    8282 
    8383        $objQuery = new SC_Query(); 
    84         $cols = '*, (SELECT COUNT(*) FROM dtb_order_detail WHERE product_id = allcls.product_id) AS cnt'; 
    85         $from = 'vw_products_allclass AS allcls'; 
     84        $cols = '*, (SELECT COUNT(*) FROM dtb_order_detail WHERE product_id = alldtl.product_id) AS cnt'; 
     85        $from = 'vw_products_allclass_detail AS alldtl'; 
    8686        $where = <<< __EOS__ 
    8787            del_flg = 0 
Note: See TracChangeset for help on using the changeset viewer.