bug修改

101captain

2022-06-06 e7feb44cde84b4899c7b5d5e2afe27cf95fea8e5

bug修改

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

@@ -46,23 +46,23 @@
            *
        FROM
            (
            SELECT
                t1.user_id,
                rank() over(ORDER BY integral_sum DESC) as 'rank'
            FROM
                (
                SELECT
                    t1.user_id,
                    @rank := @rank + 1 AS rank
                FROM
                    (
                    SELECT
                    caiu.user_id,
                    caiu.integral_sum
                FROM
                    FROM
                    com_act_integral_user as caiu
                    left join sys_user as su on su.user_id = caiu.user_id
                WHERE
                    caiu.community_id = ${communityId}
                ORDER BY
                    WHERE
                    caiu.community_id = #{communityId}
                    ORDER BY
                    caiu.integral_sum DESC,su.create_at asc
                 ) AS t1,
                ( SELECT @rank := 0 ) AS t2
                    ) AS t1,
                    ( SELECT @rank := 0 ) AS t2
            ) AS m
        WHERE
            user_id = #{userId}