# 能否添加一个编辑日志？

**URL:** https://meta.discourse.org/t/can-we-have-an-edit-log-please/86066
**Category:** Feature
**Tags:** completed
**Created:** [2018年四月24日 14:27 UTC](https://meta.discourse.org/t/can-we-have-an-edit-log-please/86066 "2018-04-24T14:27:22Z")
**Posts on this page:** 1
**Showing post:** 9

<div class="post-metadata">

### Author: ![rishabh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rishabh/32/179446_2.png) [@rishabh](https://meta.discourse.org/u/rishabh)
#### Post date: [2019年四月8日 06:19 UTC](https://meta.discourse.org/t/can-we-have-an-edit-log-please/86066/9 "2019-04-08T06:19:28Z")

</div>

Yes, we ship a query with the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) that targets recent edits made by TL0/TL1 users. It’s right here:

> [@Human-driven copy-paste spam](https://meta.discourse.org/t/human-driven-copy-paste-spam/97205/35):
>
> Last 500 posts that were edited by TL0/TL1 users SELECT p.id AS post\_id, topic\_id FROM posts p JOIN users u ON u.id = p.user\_id JOIN topics t ON t.id = p.topic\_id WHERE p.last\_editor\_id = p.user\_id AND p.self\_edits \> 0 AND (u.trust\_level = 0 OR u.trust\_level = 1) AND p.deleted\_at IS NULL AND t.deleted\_at IS NULL AND t.archetype = 'regular' ORDER BY p.updated\_at DESC LIMIT 500 This query should do it, it lists recent posts that have been edited by the OP if the the user…

---

_[View the full topic](https://meta.discourse.org/t/can-we-have-an-edit-log-please/86066)._