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

[JammyDodger]

@Shirly_Nowak

Thank you @nolo , I think what we’ll have to figure out now is if we could specify in the query of a badge conditions that are similar to the ones in trust levels, such as: time spent in the community, likes given or received,… which I think might be complicated

@ganncamp polished up a query in a similar area, which may give you something to work from?

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 …