Q&A about the site for administrators, end users, developers and designers for Craft CMS
With UserBadges AS (Select UserId, Count(*) As NumBadges From Badges Where Name In (Select TagName from Tags) Group By UserId, Name) Select Top 10 1 As [Order], 'Gold' As Label, UserId As [User Link], Count(*) As Num From (Select UserId From UserBadges Where NumBadges>=3) d Group By UserId union all Select Top 10 2, 'Silver' As Label, UserId As [User Link], Count(*) As Num From (Select UserId From UserBadges Where NumBadges>=2) d Group By UserId union all Select Top 10 3, 'Bronze' As Label, UserId As [User Link], Count(*) As Num From (Select UserId From UserBadges Where NumBadges>=1) d Group By UserId Order By [Order], Num Desc