I’m not well-versed in these queries but I have been using this (and others with different post requirements) query I got from the Discourse meta site to reward posting to a particular category. SELECT P.user_id, MIN(P.created_at) granted_at, MAX(P.id) post_id FROM badge_posts P JOIN topics T ON T…

[image] Bernstein: I finally realized why this code wasn’t working. I can’t award badges to categories that are limited to certain trust levels. You can do this. The problem is that the query is using the badge_posts table. The badge_posts table doesn’t include posts from protected categories…

Need help with an SQL badge query

Data & reporting

codinghorror (Jeff Atwood) October 23, 2017, 3:19am 3

It is a feature, ask @sam about it.

[PAID] Allow badges to be granted in restricted categories

Topic		Replies	Views
Uncategorized category shows up in sidebar, even when disabled Bug sidebar	6	467	September 26, 2022
Side scroll bar date missing Support	7	46	December 17, 2024
Help with sql - autoclose/repeat results/week filter Data & reporting sql-query	6	419	July 25, 2022
Users can't delete their own posts Support	5	256	January 22, 2024
New User "must read" message Support	7	471	April 9, 2021

Need help with an SQL badge query

Related topics