I think I’ve found the file and the explanation for zogstrip with 2 posts coming before envieme with 4 posts.
in app/models/topic_featured_users.rb
There’s
def self.count
4
end
and
SELECT id, user_id, ROW_NUMBER() OVER(PARTITION BY id ORDER BY last_post_date ASC) as rank
FROM cte
WHERE rank <= #{count}
That is,
the OP is always first
then members that made more than 4 posts ordered by their number of posts descending
then chronological
last avatar always the last poster unless also the OP
Like or Trust Level are not considered.