about summary refs log tree commit diff
path: root/app
diff options
context:
space:
mode:
authormultiple creatures <dev@multiple-creature.party>2020-01-11 17:07:08 -0600
committermultiple creatures <dev@multiple-creature.party>2020-01-11 17:07:08 -0600
commitf2e9f4303e5e91bc05be771506027c0eb1850ccf (patch)
treec236e0e6d0b48598a104e045fe24ce6728eee426 /app
parent5d558b845e3d92059e42fb1013578c167a0575e2 (diff)
remove duplicate posts in gallery mode
Diffstat (limited to 'app')
-rw-r--r--app/models/status.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/app/models/status.rb b/app/models/status.rb
index 5d257ba6c..ccc7755be 100644
--- a/app/models/status.rb
+++ b/app/models/status.rb
@@ -122,7 +122,7 @@ class Status < ApplicationRecord
   scope :search_filtered_by_account, ->(account_id) { where("tsv @@ (SELECT tsquery_union(websearch_to_tsquery('fedi', phrase)) FROM custom_filters WHERE account_id = ? AND is_enabled)", account_id) }
   scope :search_not_filtered_by_account, ->(account_id) { where.not("tsv @@ (SELECT tsquery_union(websearch_to_tsquery('fedi', phrase)) FROM custom_filters WHERE account_id = ? AND is_enabled)", account_id) }
 
-  scope :with_media, -> { joins(:media_attachments).select('statuses.*') }
+  scope :with_media, -> { joins(:media_attachments).select('statuses.*').distinct(:id) }
   scope :not_missing_media_desc, -> { left_outer_joins(:media_attachments).select('statuses.*').where('media_attachments.id IS NULL OR media_attachments.description IS NOT NULL') }
 
   scope :only_followers_of, ->(account) { where(account: [account] + account.following) }