summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorOmar Roth <omarroth@hotmail.com>2018-11-17 13:37:27 -0600
committerOmar Roth <omarroth@hotmail.com>2018-11-17 13:37:27 -0600
commit879586d7f5a42c754c4d373849d12d60d4869ca2 (patch)
treeac9324594a7ece96c4e1959effa7a4b9f4225f58
parentcd482cfd8930b11d04329c91f46ee2a1b5f08ca8 (diff)
downloadinvidious-879586d7f5a42c754c4d373849d12d60d4869ca2.tar.gz
invidious-879586d7f5a42c754c4d373849d12d60d4869ca2.tar.bz2
invidious-879586d7f5a42c754c4d373849d12d60d4869ca2.zip
Fix subscription feed for latest unseen videos
-rw-r--r--src/invidious.cr2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/invidious.cr b/src/invidious.cr
index 37bb6d43..7cb1cfe4 100644
--- a/src/invidious.cr
+++ b/src/invidious.cr
@@ -1620,7 +1620,7 @@ get "/feed/subscriptions" do |env|
end
videos = PG_DB.query_all("SELECT DISTINCT ON (ucid) * FROM #{view_name} WHERE \
- id NOT IN (#{watched}) ORDER BY published, ucid #{sort}",
+ id NOT IN (#{watched}) ORDER BY ucid, published #{sort}",
user.watched, as: ChannelVideo)
else
videos = PG_DB.query_all("SELECT DISTINCT ON (ucid) * FROM #{view_name} \