I have a badge that my members can earn multiple times, it is a “Book Club” badge - they are awarded it for discussing the book of the month. Each month, a new topic is created about the next book, and everyone replying should get the badge - this is currently done manually and is a real pain. I w…

I think something like this could do it: WITH book_club_first_posts AS ( SELECT p.topic_id, p.user_id, MIN(p.id) AS post_id FROM posts p JOIN topics t ON t.id = p.topic_id WHERE t.category_id = 5 -- replace with the category_id of your book club AND p.deleted_at ISNULL AND …

Badge query for each time posting on a new topic in a category?

data & reporting

Shauny (Shaun Robinson) April 21, 2024, 8:10am 10

Works great, thank you!!

1 Like

Topic		Replies	Views
Need some help with a bit of Badge SQL please support	4	448	December 17, 2021
Reply at least once on 50+ topics? data & reporting sql-triggered-badge	0	99	December 23, 2019
A badge granted when someone posts a reply in a single specified topic data & reporting sql-triggered-badge	7	257	June 19, 2018
Some common badge queries data & reporting sql-triggered-badge	0	8286	August 7, 2015
Badge for cumulative score for different tags? data & reporting sql-triggered-badge	5	80	March 5, 2020

Badge query for each time posting on a new topic in a category?

Related Topics