# 人工驱动的复制粘贴垃圾信息

**URL:** https://meta.discourse.org/t/human-driven-copy-paste-spam/97205
**Category:** Community Building
**Created:** [2018年九月14日 18:36 UTC](https://meta.discourse.org/t/human-driven-copy-paste-spam/97205 "2018-09-14T18:36:48Z")
**Posts on this page:** 1
**Showing post:** 35

<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: [2018年九月19日 07:31 UTC](https://meta.discourse.org/t/human-driven-copy-paste-spam/97205/35 "2018-09-19T07:31:19Z")

</div>

### Last 500 posts that were edited by TL0/TL1 users

```sql
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 has a trust level of 0/1.  
Shoutout to @simon for helping me finish this query!

---

_[View the full topic](https://meta.discourse.org/t/human-driven-copy-paste-spam/97205)._