0

Please login or register to vote for this query.

(click on this box to dismiss)

Will count the amount of badges a user has (Gold, Silver, Bronze) and rank them by it.

Q&A for Ubuntu users and developers

SELECT DisplayName AS Name,COUNT(badges.id) AS Badges, CONCAT('https://askubuntu.com/users/',badges.UserId) AS Link FROM users,badges 
 WHERE users.id = badges.UserId 
  GROUP BY DisplayName, badges.UserId 
   HAVING count(badges.id) > 100 
    ORDER BY Badges DESC

fork query

edited jun 7 19 anonymous

created dec 16 12 Luis Alvarado