[صورة] 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.…

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) 22 أكتوبر 2020، 2:38م 2

هل لديك أي تلميح بشأن هذا؟ لقد حاولت إضافة سطر
AND b.id = 136
لكنه لا يعمل

الموضوع		الردود	مرات العرض
Finding 'Top X' users with the most badges Data & reporting badges , sql-query	5	235	23 ديسمبر 2018
Count of badges on user page? Feature	6	972	11 أغسطس 2022
Badge multiple wording - "Yeah, but how many do _I_ have?" Feature ux , fixed	1	136	12 أكتوبر 2026
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	723	23 مايو 2023
Badges for posting Data & reporting sql-triggered-badge	4	522	27 أغسطس 2024

عدد شارات المستخدم مع فلتر اسم الشارة

الموضوعات ذات الصلة