修改获取党员排名列表无数据2

lidongdong

2024-03-29 0a0fe67ade8f462c3ae0f2c82df7bf9b74c212db

修改获取党员排名列表无数据2

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewStriveForMapper.xml

@@ -39,7 +39,7 @@
                            LEFT JOIN sys_user as su on su.user_id=cpm.user_id
                            LEFT JOIN com_act as ca on ca.community_id = cpm.community_id
                            LEFT JOIN com_act_integral_user as caiu on cpm.user_id=caiu.user_id and cpm.community_id=caiu.community_id
                   WHERE cpm.check_unit_id=(SELECT check_unit_id FROM com_pb_member WHERE user_id=#{userId})
                   WHERE cpm.check_unit_id=(SELECT check_unit_id FROM com_pb_member WHERE user_id=#{userId} limit 1)
                   GROUP BY cpm.user_id
                   order by amount desc,user_id desc) as tab
                ,(SELECT @row_number:=0) AS t) tab2