发帖徽章

[AntiMetaman]

@PJH

SELECT user_id, 0 post_id, current_timestamp granted_at 
FROM badge_posts  
WHERE (:backfill OR user_id IN (:user_ids) OR 0 NOT IN (:post_ids) )
GROUP BY user_id 
HAVING count(*) > 1000

我刚刚在这里发现了这个小技巧。我想为自己的特定类别发帖数量创建自定义徽章查询。如何修改此查询以包含特定类别 ID 的条件，使得仅统计特定类别中的帖子？

Some common badge queries

Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: Enable Badge SQL Here are some common badge queries which you can use to create your own awesome badge! Grant a badge if user has created at least one topic in the “foo”* category *(“foo” is the category name, not the category slug) SELECT p.user_id, min(p.created_at) granted_at, MIN(p.id) post_id FROM badge_posts p JOIN topics t ON t.id = p.topic_id WHERE cate…

这应该是对此处第一个查询的修改，该查询基于在特定类别中创建主题来授予徽章。不同之处在于，我们基于特定类别中的帖子数量来授予徽章。