# Top 50 Maiores Uploads perde alguns uploads

**URL:** https://meta.discourse.org/t/top-50-largest-uploads-misses-some-uploads/261784
**Category:** Bug
**Tags:** data-explorer
**Created:** [15 Abril , 2023 09:48 UTC](https://meta.discourse.org/t/top-50-largest-uploads-misses-some-uploads/261784 "2023-04-15T09:48:16Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Julien\_Palard](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/julien_palard/32/198784_2.png) [@Julien\_Palard](https://meta.discourse.org/u/Julien_Palard)
#### Post date: [15 Abril , 2023 09:48 UTC](https://meta.discourse.org/t/top-50-largest-uploads-misses-some-uploads/261784/1 "2023-04-15T09:48:16Z")

</div>

Executar `Top 50 Largest Uploads` informa que meu maior upload é inferior a 1 MB, sei que está errado, então explorei e os encontrei:

```sql
SELECT 
    uploads.original_filename,
    ROUND(uploads.filesize / 1000000.0, 2) AS size_in_mb,
    uploads.extension,
    post_uploads.id,
    upload_references.target_type,
    upload_references.target_id
FROM uploads
LEFT JOIN post_uploads ON uploads.id = post_uploads.upload_id
LEFT JOIN upload_references ON uploads.id = upload_references.upload_id
ORDER BY uploads.filesize DESC
LIMIT 50

```

o que encontra, por exemplo:

```plaintext
 	4.56 pdf NULL Post 4910

```

O que é estranho: ele não tem `post_uploads`, que é por isso que não é encontrado pela consulta original, mas tem uma `upload_references` para uma postagem.