Post Edits report

Contribute Feature
8

If it helps this is the query I used but I am not sure it gets everything

SELECT
    p.id AS post_id,
    u2.username, 
    topic_id
FROM posts p
    JOIN users u
        ON u.id = p.user_id
    JOIN topics t
        ON t.id = p.topic_id
    JOIN users u2
        ON u2.id = p.last_editor_id
WHERE (p.last_editor_id > 1 AND p.last_editor_id <> p.user_id)
    AND p.self_edits > 0
    AND p.deleted_at IS NULL
    AND u2.trust_level > 2
    AND u2.moderator = false
    AND u2.admin = false
    AND t.deleted_at IS NULL
    AND t.archetype = 'regular'
ORDER BY p.updated_at DESC
LIMIT 500

Note that this rules out users who are staff as well as the system user, so basically the above query is just TL3 users editing around the site to tidy things up.

You could use this query as is @outofthebox in Data Explorer in the meantime…

3 Likes