diff options
Diffstat (limited to 'src/db/mod.rs')
| -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 ), |