aboutsummaryrefslogtreecommitdiff
path: root/src/db/mod.rs
diff options
context:
space:
mode:
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