| | |
|---|
| | | </if> |
|---|
| | | ORDER BY d.is_topping DESC, d.create_at DESC |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <!-- COUNT(u.id)readNum, LEFT JOIN com_act_dyn_user u ON d.id = u.dyn_id--> |
|---|
| | | |
|---|
| | | <select id="pageDynamicByAdmin" resultType="com.panzhihua.common.model.vos.community.ComActDynVO"> |
|---|
| | | SELECT d.id, d.title,d.`status`, d.`content`, d.`cover`, d.`type`, d.`cover_mode`, |
|---|
| | | SELECT d.id, d.title,(SELECT COUNT(u.id) FROM com_act_dyn_user u WHERE d.id = u.dyn_id ) readNum, |
|---|
| | | d.`status`, d.`content`, d.`cover`, d.`type`, d.`cover_mode`, |
|---|
| | | d.is_topping, d.publish_at, d.create_at, cadt.`name` as typeName, ca.name as communityName,d.release_time |
|---|
| | | FROM com_act_dyn d |
|---|
| | | |
|---|
| | | LEFT JOIN com_act_dyn_type as cadt ON cadt.id = d.type |
|---|
| | | LEFT JOIN com_act ca ON d.community_id = ca.community_id |
|---|
| | | WHERE 1=1 |
|---|
