Changeset 22246 for branches/version-2_12-dev/data/class
- Timestamp:
- 2013/01/15 20:56:30 (11 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
r22206 r22246 95 95 $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id'; 96 96 $where = 'T1.del_flg = 0 and T2.status = 1'; 97 if (NOSTOCK_HIDDEN) { 98 $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = T1.product_id AND dtb_products_class.del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 99 } 97 100 $objQuery->setOrder('T1.rank'); 98 101 $objQuery->setLimit(RECOMMEND_NUM);
Note: See TracChangeset
for help on using the changeset viewer.