Forum Discussion

waldemarhelm's avatar
waldemarhelm
Director
2 years ago

Custom Components "Most Kudos From" and "Most Kudos To"

Hi, I want to display in a custom component on a user's ViewProfilePage which three users gave him the most kudos, including avatar and number of kudos. And in a second component, I want to show, c...
VikasB's avatar
VikasB
Boss
2 years ago

waldemarhelm 

Here you go 

SELECT login,kudos_received.sum(weight) FROM users ORDER BY kudos_received.sum(weight) DESC
SELECT login,kudos_given.sum(weight) FROM users ORDER BY kudos_given.sum(weight) DESC