Um distintivo extra baseado no número de distintivos já concedidos?

Hi. I was wondering if we could create a special badge for users already being granted with 30+ badges ( excluding system and discobot ).
So far this is the closest query I’ve found but is not for this use.

3 curtidas

Finalmente consegui, (meu primeiro distintivo criado :smile: ) se alguém estiver interessado, aqui está

SELECT user_id, current_timestamp granted_at
FROM user_badges
GROUP BY user_id
HAVING count(*) >= 30

2 curtidas