# 找出更可能成为TL3的用户

**URL:** https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495
**Category:** Data & reporting
**Tags:** trust-levels, sql-query
**Created:** [2018 年7 月 3 日 16:17 UTC](https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495 "2018-07-03T16:17:14Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![robmc](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/robmc/32/125900_2.png) [@robmc](https://meta.discourse.org/u/robmc)
#### Post date: [2018 年7 月 3 日 17:07 UTC](https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495/4 "2018-07-03T17:07:05Z")

</div>

你可以这样做，编写一个查询来跟踪关键字段，并将其限制为当前的 TL2 用户。

在另一个主题中有很多关于 [Data Explorer](https://meta.discourse.org/t/32566?silent=true) 的优秀查询思路，看起来你可以创建一个带有 TL2 限制的“用户目录”版本，来回答你的问题。

> [@Recreate the Discourse user’s directory](https://meta.discourse.org/t/recreate-the-discourse-user-s-directory/275011):
>
> Recreate the Discourse user’s directory OK, here is the query to recreate the user’s directory. -- [params] -- null int :period SELECT users.username AS "Username", directory\_items.likes\_received AS "Likes Received", directory\_items.likes\_given AS "Likes Given", directory\_items.topic\_count AS "Topics Created", directory\_items.post\_count AS "Replied", directory\_items.days\_visited AS "Vists", directory\_items.topics\_entered AS "Viewed", directory\_items.posts\_read AS "Read" FROM users JOIN direct…

仍然很好奇你想通过“预测”TL3 来实现什么目标。听起来像《少数派报告》；)

---

_[View the full topic](https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495)._