最大的50个上传列表遗漏了一些上传内容

错误
1

运行 Top 50 Largest Uploads 时，它显示我最大的上传文件不到 1MB，我知道这是错误的，所以我进行了探索并找到了它们：

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

这找到了，例如：

 	4.56 	pdf 	NULL 	Post 	4910

这很奇怪：它没有 post_uploads，这就是为什么它没有被原始查询找到，但它有一个指向帖子的 upload_references。

3 个赞