bug修改

101captain

2022-06-06 e7feb44cde84b4899c7b5d5e2afe27cf95fea8e5

bug修改

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActIntegralUserDOMapper.xml

@@ -48,7 +48,7 @@
            (
            SELECT
                t1.user_id,
                rank() over(ORDER BY integral_sum DESC) as 'rank'
                    @rank := @rank + 1 AS rank
            FROM
                (
                SELECT
@@ -58,7 +58,7 @@
                    com_act_integral_user as caiu
                    left join sys_user as su on su.user_id = caiu.user_id
                WHERE
                    caiu.community_id = ${communityId}
                    caiu.community_id = #{communityId}
                ORDER BY
                    caiu.integral_sum DESC,su.create_at asc
                 ) AS t1,