diff options
| -rw-r--r-- | src/invidious.cr | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/src/invidious.cr b/src/invidious.cr index 285d4394..93f63dfe 100644 --- a/src/invidious.cr +++ b/src/invidious.cr @@ -1373,12 +1373,7 @@ get "/subscription_manager" do |env| format = env.params.query["format"]? format ||= "rss" - subscriptions = [] of InvidiousChannel - user.subscriptions.each do |ucid| - if channel = PG_DB.query_one?("SELECT * FROM channels WHERE id = $1", ucid, as: InvidiousChannel) - subscriptions << channel - end - end + subscriptions = PG_DB.query_all("SELECT * FROM channels WHERE id = ANY('{#{user.subscriptions.join(",")}}')", as: InvidiousChannel) subscriptions.sort_by! { |channel| channel.author.downcase } if action_takeout |