[图片] 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.mo…

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) 2020 年10 月 26 日 11:10 4

就是这样非常感谢

话题		回复	浏览量
Finding 'Top X' users with the most badges Data & reporting badges , sql-query	5	235	2018 年12 月 23 日
Count of badges on user page? Feature	6	972	2022 年8 月 11 日
Badge multiple wording - "Yeah, but how many do _I_ have?" Feature ux , fixed	1	134	2026 年10 月 12 日
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	2023 年5 月 23 日
Badges for posting Data & reporting sql-triggered-badge	4	522	2024 年8 月 27 日

用户徽章计数，带徽章名称过滤器

相关话题