summaryrefslogtreecommitdiffstats
path: root/src
diff options
context:
space:
mode:
authorOmar Roth <omarroth@hotmail.com>2018-10-09 18:39:19 -0500
committerOmar Roth <omarroth@hotmail.com>2018-10-09 18:39:19 -0500
commitccc423f6826b5c1ff25457484b02c716d97ca8b4 (patch)
tree8740dfa5422790dd24300dca3c5dc2cab923130c /src
parent02335f33904c8baeace874d89fde315df3f38d5a (diff)
downloadinvidious-ccc423f6826b5c1ff25457484b02c716d97ca8b4.tar.gz
invidious-ccc423f6826b5c1ff25457484b02c716d97ca8b4.tar.bz2
invidious-ccc423f6826b5c1ff25457484b02c716d97ca8b4.zip
Fix 'latest only' feed
Diffstat (limited to 'src')
-rw-r--r--src/invidious.cr3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/invidious.cr b/src/invidious.cr
index 5f7cec7a..5d929996 100644
--- a/src/invidious.cr
+++ b/src/invidious.cr
@@ -1419,7 +1419,8 @@ get "/feed/subscriptions" do |env|
id NOT IN (#{watched}) ORDER BY ucid, published DESC",
user.watched, as: ChannelVideo)
else
- videos = PG_DB.query_all("SELECT DISTINCT ON (ucid) * FROM #{view_name}", as: ChannelVideo)
+ videos = PG_DB.query_all("SELECT DISTINCT ON (ucid) * FROM #{view_name} \
+ ORDER BY ucid, published DESC", as: ChannelVideo)
end
videos.sort_by! { |video| video.published }.reverse!