1b16dc175d29ea8a9e525de79d94053b28358dcb

Author
TheEdgeOfRage <git@theedgeofrage.com>
Committer
TheEdgeOfRage <git@theedgeofrage.com>
Date

Message

Fix watched page duplicate entries

Diff

 1diff --git a/db/videos.go b/db/videos.go
 2index 58b7aacab8a9923684332416c64d5ac55ff548c2..f2054f71de15009e6c9d0411626a2dbce7469691 100644
 3--- a/db/videos.go
 4+++ b/db/videos.go
 5@@ -88,7 +88,7 @@ func (db *postgresDB) GetWatchedVideos(
 6 			, channels.name
 7 			, channels.id
 8 		FROM videos
 9-		LEFT JOIN channels ON videos.channel_id=videos.channel_id
10+		LEFT JOIN channels ON channels.id=videos.channel_id
11 		WHERE watch_timestamp IS NOT NULL
12 			AND videos.is_discarded = false
13 		ORDER BY watch_timestamp