aboutsummaryrefslogtreecommitdiffstats
path: root/pydis_site/apps
diff options
context:
space:
mode:
Diffstat (limited to 'pydis_site/apps')
-rw-r--r--pydis_site/apps/api/models/bot/metricity.py8
1 files changed, 3 insertions, 5 deletions
diff --git a/pydis_site/apps/api/models/bot/metricity.py b/pydis_site/apps/api/models/bot/metricity.py
index 901f191a..52e946ac 100644
--- a/pydis_site/apps/api/models/bot/metricity.py
+++ b/pydis_site/apps/api/models/bot/metricity.py
@@ -46,14 +46,12 @@ class Metricity:
self.cursor.execute(
"""
SELECT
- COUNT(*)
- FROM messages
+ message_count
+ FROM user_has_approx_message_count
WHERE
author_id = '%s'
- AND NOT is_deleted
- AND channel_id NOT IN %s
""",
- [user_id, EXCLUDE_CHANNELS]
+ [user_id]
)
values = self.cursor.fetchone()