Changeset 21678
- Timestamp:
- 2012/03/26 18:28:02 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_Detail.php
r21659 r21678 466 466 467 467 $objQuery->setOrder('rank DESC'); 468 $arrRecommendData = $objQuery->select( 'recommend_product_id, comment', 'dtb_recommend_products', 'product_id = ?', array($product_id));468 $arrRecommendData = $objQuery->select("recommend_product_id, comment", "dtb_recommend_products as t1 left join dtb_products as t2 on t1.recommend_product_id = t2.product_id", "t1.product_id = ? and t2.del_flg = 0 and t2.status = 1", array($product_id)); 469 469 470 470 $arrRecommendProductId = array();
Note: See TracChangeset
for help on using the changeset viewer.