Changeset 22124 for branches/version-2_12-dev/data/class/pages/frontparts

Timestamp:

2012/12/07 17:04:44 (11 years ago)

Author:

tokuhiro

Message:

#1972 商品を削除した際に、おすすめ商品からも削除される仕様に変更

File:

• branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php (modified) (1 diff)

branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php

@@ -94 +94 @@
         $col = 'T1.best_id, T1.category_id, T1.rank, T1.product_id, T1.title, T1.comment, T1.create_date, T1.update_date';
         $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id';
-        $where = 'T1.del_flg = 0 and T2.status = 1 and T2.del_flg = 0';
+        $where = 'T1.del_flg = 0 and T2.status = 1';
         $objQuery->setOrder('T1.rank');
         $objQuery->setLimit(RECOMMEND_NUM);