Changeset 21975 for branches/version-2_12-dev/data
- Timestamp:
- 2012/07/27 13:59:36 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php
r21957 r21975 452 452 // 在庫無し商品の非表示 453 453 if (NOSTOCK_HIDDEN) { 454 $searchCondition['where'] .= ' AND (stock >= 1 OR stock_unlimited = 1)';454 $searchCondition['where'] .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = alldtl.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 455 455 $searchCondition['where_for_count'] .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = alldtl.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 456 456 }
Note: See TracChangeset
for help on using the changeset viewer.