From 1fbe7c340201ddff5232c7931a265136943ffd59 Mon Sep 17 00:00:00 2001
From: multiple creatures <dev@multiple-creature.party>
Date: Mon, 13 Jan 2020 21:06:09 -0600
Subject: remove duplicates from media gallery mode, attempt 2
---
app/models/status.rb | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/app/models/status.rb b/app/models/status.rb
index ccc7755be..001437795 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.*').distinct(:id) }
+ scope :with_media, -> { joins(:media_attachments).select('statuses.*').distinct(:status_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) }
--
cgit