| | |
| | | resultType="com.panzhihua.common.model.vos.partybuilding.PartyBuildingActivityVO"> |
| | | SELECT |
| | | a.id, |
| | | a.NAME, |
| | | a.release_time, |
| | | a.activity_name AS name, |
| | | a.publish_at AS releaseTime, |
| | | a.cover |
| | | FROM com_pb_activity a |
| | | LEFT JOIN sys_user u ON a.create_by = u.user_id |
| | | FROM com_act_activity a |
| | | WHERE a.community_id = #{pageBaseDTO.communityId} AND a.`status` IN ( 3, 4, 5 ) |
| | | ORDER BY a.release_time desc |
| | | ORDER BY a.publish_at desc |
| | | </select> |
| | | <select id="pagePartyBuildIngDiscuss" |
| | | resultType="com.panzhihua.common.model.vos.community.ComActDiscussVO"> |