<select id="selectLtygoodList" resultMap="BaseResultMap">
select t1.*,giftGoods.id as goodsId,
giftGoods.goods_type,
giftGoods.picture,
giftGoods.rech_value,
giftGoods.cpn_id
from gift_ltygoods t1 LEFT join gift_goods giftGoods on t1.goods_id = giftGoods.id
<where>
t1.act_id = #{actid} and t1.term_id = #{termid} and t1.del_flag = '0'
<if test="giftName!=null and giftName!=''">
AND t1.gift_name like concat('%','${giftName}','%')
</if>
ORDER BY t1.create_date asc limit ${limit}
</where>
/*where t1.act_id = #{actid} and t1.term_id = #{termid} and t1.del_flag = '0' and giftGoods.del_flag = '0'
ORDER BY t1.create_date asc limit #{limit}*/
</select>
下面有注释的sql,导致出了这么个异常