aboutsummaryrefslogtreecommitdiffstats
path: root/pydis_site/apps/api
diff options
context:
space:
mode:
authorGravatar ChrisJL <[email protected]>2024-03-10 12:22:33 +0000
committerGravatar GitHub <[email protected]>2024-03-10 12:22:33 +0000
commit4099c02932479a38a23d59a6080b7f0f26116897 (patch)
treed0f04bce1179cc7f4fdc15f1660208317294a299 /pydis_site/apps/api
parentResources: Add guidelines on YAML files (diff)
parentMerge pull request #1251 from python-discord/dependabot/pip/sentry-sdk-1.41.0 (diff)
Merge branch 'main' into docs/suggest-resources
Diffstat (limited to 'pydis_site/apps/api')
-rw-r--r--pydis_site/apps/api/models/bot/metricity.py6
1 files changed, 3 insertions, 3 deletions
diff --git a/pydis_site/apps/api/models/bot/metricity.py b/pydis_site/apps/api/models/bot/metricity.py
index f1277b21..7d5d5f0b 100644
--- a/pydis_site/apps/api/models/bot/metricity.py
+++ b/pydis_site/apps/api/models/bot/metricity.py
@@ -49,7 +49,7 @@ class Metricity:
WHERE
author_id = '%s'
AND NOT is_deleted
- AND channel_id != ANY(%s)
+ AND channel_id != ALL(%s)
""",
[user_id, EXCLUDE_CHANNELS]
)
@@ -77,7 +77,7 @@ class Metricity:
WHERE
author_id='%s'
AND NOT is_deleted
- AND channel_id != ANY(%s)
+ AND channel_id != ALL(%s)
GROUP BY interval
) block_query;
""",
@@ -147,7 +147,7 @@ class Metricity:
WHERE
author_id = ANY(%s)
AND NOT is_deleted
- AND channel_id != ANY(%s)
+ AND channel_id != ALL(%s)
AND created_at > now() - interval '%s days'
GROUP BY author_id
""",