| | |
| | | |
| | | @Select("<script> " + "SELECT\n" + " distinct COUNT( u.id ) readingVolume,\n" |
| | | + " d.community_id, d.content, d.cover, d.cover_mode, d.create_at, d.create_by, d.dyn_type, d.id, d.publish_at, d.status, d.title, d.type, \n" |
| | | + " act.name as createByName " + "FROM\n" |
| | | + " act.name as createByName,d.jump_type,d.jump_url " + "FROM\n" |
| | | + "com_pb_dyn d LEFT JOIN com_act act ON d.community_id = act.community_id \n" |
| | | + "LEFT JOIN com_pb_dyn_user u ON d.id = u.dyn_id " + "where d.id = #{id} " + " group by d.id " + "</script>") |
| | | PartyBuildingComPbDynVO selectVoById(@Param("id") Long id); |