| | |
|---|
| | | tag.activity_deadline endTime, |
|---|
| | | tag.activity_id activityId |
|---|
| | | FROM t_activity_goods tag |
|---|
| | | INNER JOIN t_activity ta ON ta.activity_id = tag.activity_id |
|---|
| | | INNER JOIN t_goods tg ON tg.goods_id = tag.goods_id |
|---|
| | | LEFT JOIN t_goods_file tgf ON tg.goods_id = tgf.goods_id AND tgf.del_flag = 0 AND tgf.file_type = 1 |
|---|
| | | LEFT JOIN t_shop_goods tsg ON tg.goods_id = tsg.goods_id AND tsg.shop_id = #{param.shopId} |
|---|
| | | WHERE tg.del_flag = 0 AND tg.goods_status = 1 AND tag.del_flag = 0 |
|---|
| | | WHERE ta.del_flag =0 AND ta.activity_status < 2 AND tg.del_flag = 0 AND tg.goods_status = 1 AND tag.del_flag = 0 |
|---|
| | | <if test="param.activityIdList != null and param.activityIdList.size() > 0"> |
|---|
| | | AND tag.activity_id IN |
|---|
| | | <foreach collection="param.activityIdList" item="item" open="(" separator="," close=")"> |
|---|
