diff options
| author |  ChrisJL <[email protected]> | 2024-03-10 12:24:10 +0000 |
|---|---|---|
| committer |  GitHub <[email protected]> | 2024-03-10 12:24:10 +0000 |
| commit | 9c58bae4dec38864a02b2c7670cf5c7118a4a7f4 (patch) | |
| tree | b749fa2590078a69b1abcf5e95019e156f6f04f7 /pydis_site/apps/api | |
| parent | Fix pydis_site/README.md reference to static directory structure (diff) | |
| parent | Merge pull request #1226 from python-discord/docs/suggest-resources (diff) | |
Merge branch 'main' into docs/dark-theme-dev
Diffstat (limited to 'pydis_site/apps/api')
| -rw-r--r-- | pydis_site/apps/api/models/bot/metricity.py | 6 |
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 """, |