| | |
| | | <include refid="Base_Column_List" /> |
| | | from yeshi_ec_activity_goods_taobao limit #{start},#{count} |
| | | </select> |
| | | <select id="getTaoBaoGoodsBriefByActivityId" resultMap="TAOBAOGOODS" |
| | | parameterType="java.lang.Long">SELECT g.* FROM yeshi_ec_activity_goods_taobao t LEFT |
| | | JOIN yeshi_ec_taobao_goods g ON t.`agt_goods_id`=g.`id` WHERE |
| | | t.`agt_activity_id`=#{0} |
| | | </select> |
| | | <select id="selectByActivityId" resultMap="BaseResultMap" |
| | | parameterType="java.lang.Long">SELECT t.* FROM yeshi_ec_activity_goods_taobao t LEFT |
| | | JOIN yeshi_ec_taobao_goods g ON t.`agt_goods_id`=g.`id` WHERE |
| | | t.`agt_activity_id`=#{0} |
| | | <select id="selectByActivityId" resultMap="BaseResultMap" parameterType="java.lang.Long"> |
| | | SELECT t.* FROM yeshi_ec_activity_goods_taobao t |
| | | WHERE t.`agt_activity_id`=#{0} |
| | | </select> |
| | | |
| | | <select id="selectByAuctionId" resultMap="BaseResultMap" |