# 사용자 상태

**URL:** https://meta.discourse.org/t/user-status/240335
**Category:** Announcements
**Tags:** new-feature, user-status
**Created:** [10월 4, 2022, 10:16오전 UTC](https://meta.discourse.org/t/user-status/240335 "2022-10-04T10:16:57Z")
**Posts on this page:** 1
**Showing post:** 53

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [1월 14, 2023, 1:22오후 UTC](https://meta.discourse.org/t/user-status/240335/53 "2023-01-14T13:22:55Z")

</div>

[data-explorer](https://meta.discourse.org/t/discourse-data-explorer/32566) 플러그만 있다면 꽤 간단합니다. 👍 (단, 실행해야 한다는 것을 잊지 마세요)

가장 간단한 쿼리는 다음과 같습니다:

```sql

SELECT *
FROM user_statuses
ORDER BY set_at DESC

```

또는 사용자의 설정/계정 페이지로 바로 연결되는 쿼리를 사용할 수도 있습니다. 예:

```sql

SELECT us.user_id,
       us.emoji, 
       us.description,
       'https://meta.discourse.org/u/' || u.username || '/preferences/account' AS preferences_account_url
FROM user_statuses us
JOIN users u ON u.id = us.user_id
ORDER BY set_at DESC

```

---

_[View the full topic](https://meta.discourse.org/t/user-status/240335)._