سكربت معطل لأكبر 50 تحميلًا

JammyDodger · 31 أكتوبر 2023، 3:16م

نعم. تم إيقاف استخدام جدول post_uploads. أعتقد أنه يجب استخدام جدولي uploads و upload_references الآن؟

شكراً على التقرير.

github.com/discourse/discourse-data-explorer

lib/discourse_data_explorer/queries.rb

main


      
              COALESCE(likes_received, 0) AS likes_received
          FROM pr
          LEFT JOIN tv USING (user_id)
          LEFT JOIN pc USING (user_id)
          LEFT JOIN tc USING (user_id)
          LEFT JOIN twr USING (user_id)
          LEFT JOIN lg USING (user_id)
          LEFT JOIN lr USING (user_id)
          LEFT JOIN e USING (user_id)
          LEFT JOIN users ON pr.user_id = users.id
          ORDER BY
              visits DESC,
              posts_read DESC,
              posts_created DESC
          SQL
          
          queries["largest-uploads"]["sql"] = <<~SQL
          SELECT posts.id AS post_id,
              uploads.original_filename,
              ROUND(uploads.filesize / 1000000.0, 2) AS size_in_mb,
              uploads.extension,

أعتقد أن هذه هي النسخة المحدثة إذا كنت بحاجة إليها يا @Ivan_Rapekas:

SELECT posts.id AS post_id,
    uploads.original_filename,
    ROUND(uploads.filesize / 1000000.0, 2) AS size_in_mb,
    uploads.extension,
    uploads.created_at,
    uploads.url
FROM upload_references
JOIN uploads ON uploads.id = upload_references.upload_id
JOIN posts ON posts.id = upload_references.target_id AND upload_references.target_type = 'Post'
ORDER BY uploads.filesize DESC
LIMIT 50

الموضوع		الردود	مرات العرض
Top 50 Largest Uploads misses some uploads Bug data-explorer	0	339	15 أبريل 2023
Post_uploads database table Support	1	275	24 نوفمبر 2023
Query for recently uploaded / attached files Support	5	1165	8 أبريل 2017
Latest uploads Data & reporting sql-query	0	155	10 أكتوبر 2018
List of all uploaded files Feature planned	15	4950	20 فبراير 2023

سكربت معطل لأكبر 50 تحميلًا

الموضوعات ذات الصلة