Fix trending statuses returning more than one post by the same author (#19349)

1 files changed, 1 insertions, 1 deletions

diff --git a/app/models/status_trend.rb b/app/models/status_trend.rb
index 33fd6b004..b0f1b6942 100644
--- a/app/models/status_trend.rb
+++ b/app/models/status_trend.rb
@@ -17,5 +17,5 @@ class StatusTrend < ApplicationRecord
   belongs_to :status
   belongs_to :account
 
-  scope :allowed, -> { where(allowed: true) }
+  scope :allowed, -> { joins('INNER JOIN (SELECT account_id, MAX(score) AS max_score FROM status_trends GROUP BY account_id) AS grouped_status_trends ON status_trends.account_id = grouped_status_trends.account_id AND status_trends.score = grouped_status_trends.max_score').where(allowed: true) }
 end