aboutsummaryrefslogtreecommitdiff
path: root/src/db/mod.rs
diff options
context:
space:
mode:
authorNathan Perry <np@nathanperry.dev>2024-08-17 05:15:07 -0400
committerNathan Perry <np@nathanperry.dev>2024-08-17 05:15:07 -0400
commit61e94a8474fd3b05205450899bdd185447ac7c28 (patch)
tree21d719f592aa715bb9a5dbe55e84288cf813348d /src/db/mod.rs
parent961b17dabce58ea780d9ff82629d82c8cb87bfc4 (diff)
fix rarememe, quiet playback gc logs
Diffstat (limited to 'src/db/mod.rs')
-rw-r--r--src/db/mod.rs4
1 files changed, 2 insertions, 2 deletions
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