| | |
|---|
| | | com_act_act_regist caar |
|---|
| | | LEFT JOIN sys_user su ON caar.user_id = su.user_id |
|---|
| | | LEFT JOIN com_act_activity t on caar.activity_id = t.id |
|---|
| | | WHERE caar.activity_id = #{id} AND caar.user_id = #{userId} AND caar.`type` = 1 ORDER BY caar.id DESC |
|---|
| | | WHERE caar.activity_id = #{id} AND caar.user_id = #{userId} ORDER BY caar.id DESC |
|---|
| | | </select> |
|---|
| | | <select id="selectTotalAwardWithRegist" resultType="java.lang.Integer"> |
|---|
| | | SELECT SUM(award) FROM com_act_act_regist WHERE activity_id = #{activityId} AND user_id = #{userId} AND `type` = 1 |
|---|
