From 6c686b8b3cd9e5769156321a8d05f737196ee375 Mon Sep 17 00:00:00 2001 From: Nathan Perry Date: Sat, 17 Aug 2024 03:02:31 -0400 Subject: fix stats and playback queue --- src/db/mod.rs | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/db/mod.rs') diff --git a/src/db/mod.rs b/src/db/mod.rs index 3362e33..a8d66e5 100644 --- a/src/db/mod.rs +++ b/src/db/mod.rs @@ -758,7 +758,7 @@ pub async fn memers(guild: u64) -> Result> { user_meme_counts AS ( SELECT user_id, meme_id, COUNT(meme_id) as meme_count FROM invocation_records - WHERE EXISTS (SELECT id FROM memes WHERE id = invocation_records.meme_id) AND guild = $1 + WHERE guild = $1 AND EXISTS (SELECT id FROM memes WHERE id = invocation_records.meme_id) GROUP BY user_id, meme_id ORDER BY user_id, meme_count DESC ), -- cgit v1.3.1