从信任级别中排除某些类别

[JammyDodger]

@Shirly_Nowak

谢谢 @nolo，我认为我们现在需要弄清楚的是，我们是否可以在徽章的查询中指定一些类似于信任等级的条件，例如：在社区花费的时间、收到的或给出的点赞数…… 我认为这可能会很复杂

@ganncamp 对一个类似领域的查询进行了优化，也许能给你一些参考？

Find the users which are more likely to become TL3

This is slightly more efficient. If it still doesn’t run for you, then you can try stripping out some of the columns, with their associated joins and queries. EDIT Okay, I finally got my join types straight (it’s been a while). This updated query is much more efficient with t as ( select CURRENT_TIMESTAMP - ((0 + 100) * (INTERVAL '1 days')) as start, CURRENT_TIMESTAMP - (0 * (INTERVAL '1 days')) as end ), -- Topic count last 100 days 25% -- lesser of 25% topics created in last 100 …