From 61e94a8474fd3b05205450899bdd185447ac7c28 Mon Sep 17 00:00:00 2001
From: Nathan Perry <np@nathanperry.dev>
Date: Sat, 17 Aug 2024 05:15:07 -0400
Subject: fix rarememe, quiet playback gc logs

---
 src/db/mod.rs | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/db')

diff --git a/src/db/mod.rs b/src/db/mod.rs
index a8d66e5..56a8190 100644
--- a/src/db/mod.rs
+++ b/src/db/mod.rs
@@ -340,12 +340,12 @@ pub async fn rare_meme(
         FROM meme_count
             RIGHT JOIN memes ON memes.id = meme_count.meme_id
             INNER JOIN metadata ON metadata.id = memes.metadata_id
-        WHERE memes.guild = $3 AND ((memes.audio_id IS NULL) = $1 OR $2)
+        WHERE (memes.audio_id IS NULL) = $1 OR $2
     ),
     least_used AS (
         SELECT
                meme_id,
-               TRUNC(time_diff / (ct + 1)) as play_prop
+               (TRUNC(time_diff / (ct + 1))::double precision) as play_prop
         FROM aggregate
     )
     SELECT
-- 
cgit v1.3.1