# Latest uploads

**URL:** https://meta.discourse.org/t/latest-uploads/275144
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [October 10, 2018, 11:16pm UTC](https://meta.discourse.org/t/latest-uploads/275144 "2018-10-10T23:16:06Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![AstonJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/astonj/32/215041_2.png) [@AstonJ](https://meta.discourse.org/u/AstonJ)
#### Post date: [October 10, 2018, 11:16pm UTC](https://meta.discourse.org/t/latest-uploads/275144/1 "2018-10-10T23:16:06Z")

</div>

**Latest uploads**

```sql
SELECT 
    id, 
    user_id, 
    original_filename,
    created_at,
    url,
    extension
FROM uploads
order by created_at desc
LIMIT 50

```

Though it would be nice if they show in the results rather than just the urls…
