[이미지] Finding 'Top X' users with the most badges Test this: -- [params] -- int :posts = 100 -- int :top = 10 SELECT u.username, count(ub.id) as "Badges" FROM user_badges ub, users u, user_stats us WHERE u.id = ub.user_id AND u.id = us.user_id AND us.post_count > :posts AND (u.admin = 'f' AND u.m…

Any hint on this? I tried to add a line AND b.id = 136 But it doesn’t work

Here’s a slightly modified version of that query that adds a badge name filter. The badge name defaults to 'all badges'. When set to that value, results for all badges will be returned. If you set the badge name to the name of a specific badge, only results for that badge will be returned. -- [para…

That’s it :slight_smile: thank you so much

배지 이름 필터와 사용자 배지 수

커뮤니티 구축 데이터 및 보고

alefattorini (Alessio Fattorini) 10월 22, 2020, 2:38오후 2

이 문제에 대해 어떤 힌트가 있을까요? 다음 한 줄을 추가해 보았어요.
AND b.id = 136

하지만 작동하지 않아요.

글		댓글	조회수
Finding 'Top X' users with the most badges Data & reporting badges , sql-query	5	235	12월 23, 2018
Count of badges on user page? Feature	6	971	8월 11, 2022
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	5월 23, 2023
Badges for posting Data & reporting sql-triggered-badge	4	521	8월 27, 2024
Some common badge queries Data & reporting sql-triggered-badge	0	8971	8월 7, 2015

배지 이름 필터와 사용자 배지 수

Related topics