Query for recently uploaded / attached files

Yes. Here is a data-explorer query for that:

SELECT posts.id AS post_id,
       uploads.url
FROM post_uploads
JOIN uploads ON uploads.id = post_uploads.upload_id
JOIN posts ON posts.id = post_uploads.post_id
ORDER BY posts.created_at DESC

@Miro Install discourse-data-explorer plugin and import this query:

post-with-uploads.dcquery.json (312 Bytes)

5 Likes