diff options
| author | Nathan Perry <np@nathanperry.dev> | 2024-08-17 03:02:31 -0400 |
|---|---|---|
| committer | Nathan Perry <np@nathanperry.dev> | 2024-08-17 03:02:47 -0400 |
| commit | 6c686b8b3cd9e5769156321a8d05f737196ee375 (patch) | |
| tree | 76f940847bef8a85dfb2065914c93709fee0cd55 /src/db | |
| parent | 584f0ebc6e33ddc2905d82f44e7b42faea122668 (diff) | |
fix stats and playback queue
Diffstat (limited to 'src/db')
| -rw-r--r-- | src/db/mod.rs | 2 |
1 files changed, 1 insertions, 1 deletions
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<Vec<MemerInfo>> { 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 ), |
