# badges for reading! [image] [image] [image] SELECT pt.user_id, count(*) c, CURRENT_DATE as granted_at FROM post_timings pt WHERE :backfill GROUP BY pt.user_id HAVING count(*) >= pow(3, 9) AND count(*) < pow(3, 10) /* Change the 9 and 10 (x and x+1) for the different badges */ ORDER BY c DESC …

[image] alefattorini: Why are you using pow? Is it faster than say just 20000 posts? No. It’s to make them self documenting, since those particular badges on our instance are based on 3^3, 3^4, 3^5, 3^6 etc, (i.e. because 9, 27, 81, 243 and higher are less readable when glancing at the query.…

[image] PJH: Do you mean badges for one single topic? Sorry, I mean check if someone has read a specific topic (like the welcoming topic). just the first post or whole discussion

[image] [Superseded] What cool badge queries have you come up with? Sorry, I mean check if someone has read a specific topic (like the welcoming topic). just the first post We’ve already sorta covered that - start reading near this post: https://meta.discourse.org/t/what-cool-badge-queries-ha…

Badges for reading [ ⚠ intensive]

Community Building Data & reporting

alefattorini (Alessio Fattorini) Août 5, 2015, 9:29 2

Why are you using pow? Is it faster than say just 20000 posts?
Can I do the same thing for whole topics?

Sujet		Réponses	Vues
Badge granted to our staff members that have read the guidelines placed in our hidden staff category Data & reporting sql-triggered-badge	11	345	Mars 3, 2015
Badges for posting Data & reporting sql-triggered-badge	4	535	Août 27, 2024
Badge for reading a topic? Data & reporting sql-triggered-badge	6	556	Octobre 9, 2023
A badge for reading time? Data & reporting sql-triggered-badge	2	683	Février 5, 2021
Badge for reading a page? Data & reporting sql-triggered-badge	0	285	Décembre 8, 2023

Badges for reading [ ⚠ intensive]

Sujets connexes