Changeset 21390 for branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php
- Timestamp:
- 2012/01/06 19:54:03 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php
r21325 r21390 90 90 91 91 // おすすめ商品取得 92 $col = ' best_id, best_id, category_id, rank, product_id, title, comment, create_date,update_date';93 $table = 'dtb_best_products ';94 $where = ' del_flg = 0';95 $objQuery->setOrder(' rank');92 $col = 'T1.best_id, T1.category_id, T1.rank, T1.product_id, T1.title, T1.comment, T1.create_date, T1.update_date'; 93 $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id'; 94 $where = 'T1.del_flg = 0 and T2.status = 1'; 95 $objQuery->setOrder('T1.rank'); 96 96 $objQuery->setLimit(RECOMMEND_NUM); 97 97 $arrBestProducts = $objQuery->select($col, $table, $where);
Note: See TracChangeset
for help on using the changeset viewer.