fix: duplicate usernames in emote pages

1 files changed, 2 insertions, 1 deletions

diff --git a/public/emotes/index.php b/public/emotes/index.php
index 1225bdd..e9e93cb 100644
--- a/public/emotes/index.php
+++ b/public/emotes/index.php
@@ -465,7 +465,8 @@ if (CLIENT_REQUIRES_JSON) {
                             FROM users
                             INNER JOIN emote_sets AS es ON es.owner_id = users.id
                             INNER JOIN emote_set_contents AS ec ON ec.emote_set_id = es.id
-                            WHERE ec.emote_id = ?");
+                            INNER JOIN acquired_emote_sets AS aes ON aes.emote_set_id = es.id
+                            WHERE ec.emote_id = ? AND aes.is_default = TRUE");
 
                                 $stmt->execute([$emote->get_id()]);
                                 $count = $stmt->rowCount();