# Query for recently uploaded / attached files

**URL:** https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452
**Category:** Support
**Created:** [2017年四月5日 01:30 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452 "2017-04-05T01:30:37Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Miro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/miro/32/66156_2.png) [@Miro](https://meta.discourse.org/u/Miro)
#### Post date: [2017年四月5日 01:30 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/1 "2017-04-05T01:30:37Z")

</div>

I am wondering if there is possibility to view posts with uploaded / attached files.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [2017年四月5日 02:21 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/2 "2017-04-05T02:21:24Z")

</div>

This might be possible with a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query @techAPJ?

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [2017年四月5日 13:23 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/3 "2017-04-05T13:23:00Z")

</div>

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

```sql
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](https://github.com/discourse/discourse-data-explorer) plugin and import this query:

[post-with-uploads.dcquery.json](https://global.discourse-cdn.com/meta/original/3X/0/3/035854c9c39ab83cfdfddf3020f493d4b77a241e.json) (312 Bytes)

---

<div class="post-metadata">

### Author: ![Miro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/miro/32/66156_2.png) [@Miro](https://meta.discourse.org/u/Miro)
#### Post date: [2017年四月5日 14:46 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/4 "2017-04-05T14:46:19Z")

</div>

Thanks,  
That looks as for the admin. I thought more for forum users so they can check what are the latest uploaded files.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [2017年四月5日 21:22 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/5 "2017-04-05T21:22:13Z")

</div>

No such feature exists or is planned.

---

<div class="post-metadata">

### Author: ![Miro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/miro/32/66156_2.png) [@Miro](https://meta.discourse.org/u/Miro)
#### Post date: [2017年四月8日 02:01 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/6 "2017-04-08T02:01:05Z")

</div>

Ok, thanks, I can do it other way.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [2019年五月23日 03:55 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/7 "2019-05-23T03:55:26Z")

</div>



---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [2022年十月9日 10:21 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/8 "2022-10-09T10:21:17Z")

</div>



---

<div class="post-metadata">

### Author: ![Stephen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stephen/32/95011_2.png) [@Stephen](https://meta.discourse.org/u/Stephen)
#### Post date: [2022年十月9日 10:25 UTC](https://meta.discourse.org/t/query-for-recently-uploaded-attached-files/60452/9 "2022-10-09T10:25:56Z")

</div>