- Timestamp:
- 2013/08/23 19:48:57 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php
r23066 r23120 117 117 $where = 'f.customer_id = ? and p.status = 1'; 118 118 if (NOSTOCK_HIDDEN) { 119 $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = dtb_customer_favorite_products.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';119 $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = f.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 120 120 } 121 121 $arrProductId = $objQuery->getCol('f.product_id', 'dtb_customer_favorite_products f inner join dtb_products p using (product_id)', $where, array($customer_id));
Note: See TracChangeset
for help on using the changeset viewer.