| | |
| | | ,goods.present_price |
| | | ,goods.is_sale |
| | | from mall_member_collection collection |
| | | inner join mall_goods goods on collection.goods_id=goods.ID and goods.is_sales = 1 |
| | | inner join mall_goods goods on collection.goods_id=goods.ID and goods.is_sale = 1 |
| | | <where> |
| | | <if test="record != null"> |
| | | <if test="record.memberId != null"> |
| | |
| | | ,goods.present_price |
| | | ,goods.is_sale |
| | | from mall_member_footprint footprint |
| | | inner join mall_goods goods on footprint.goods_id=goods.ID and goods.is_sales = 1 |
| | | inner join mall_goods goods on footprint.goods_id=goods.ID and goods.is_sale = 1 |
| | | <where> |
| | | <if test="record != null"> |
| | | <if test="record.memberId != null"> |