diff options
| author | Nathan Perry <np@nathanperry.dev> | 2024-08-17 05:15:07 -0400 |
|---|---|---|
| committer | Nathan Perry <np@nathanperry.dev> | 2024-08-17 05:15:07 -0400 |
| commit | 61e94a8474fd3b05205450899bdd185447ac7c28 (patch) | |
| tree | 21d719f592aa715bb9a5dbe55e84288cf813348d /src/db | |
| parent | 961b17dabce58ea780d9ff82629d82c8cb87bfc4 (diff) | |
fix rarememe, quiet playback gc logs
Diffstat (limited to 'src/db')
| -rw-r--r-- | src/db/mod.rs | 4 |
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 |
