# 查找匿名帖子的原始账户

**URL:** https://meta.discourse.org/t/finding-originating-account-of-anonymous-posts/111067
**Category:** Support
**Created:** [2019年三月8日 09:24 UTC](https://meta.discourse.org/t/finding-originating-account-of-anonymous-posts/111067 "2019-03-08T09:24:19Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![gerhard](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gerhard/32/119479_2.png) [@gerhard](https://meta.discourse.org/u/gerhard)
#### Post date: [2019年三月11日 09:53 UTC](https://meta.discourse.org/t/finding-originating-account-of-anonymous-posts/111067/8 "2019-03-11T09:53:32Z")

</div>

There’s a good reason why that feature is disabled by default. You should have a _really good_ reason to enable it and you should trust them to not abuse that feature. Maybe use a higher `anonymous_posting_min_trust_level`?

You can use the following query in the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) if you really need to find out who’s who. But, if you need to use it on a regular basis you should really ask yourself if your community members are ready for the anonymous posting feature.

Choose the right query depending on your version of Discourse:

> **Query for Discourse v2.3 and newer**
>
> ```sql
> SELECT a.username AS anonymous_username, u.username AS original_username
> FROM users u
> JOIN anonymous_users au ON (u.id = au.master_user_id)
> JOIN users a ON (a.id = au.user_id)
> 
> ```

> **Query for Discourse v2.2 and below**
>
> ```sql
> SELECT a.username AS anonymous_username, u.username AS original_username
> FROM users u
> JOIN user_custom_fields ucf ON (u.id = ucf.user_id)
> JOIN users a ON (a.id = ucf.value::INT)
> WHERE ucf.name = 'shadow_id'
> ORDER BY a.username
> 
> ```

---

_[View the full topic](https://meta.discourse.org/t/finding-originating-account-of-anonymous-posts/111067)._