# Gruppen von der Top Quality Members-Abfrage ausschließen

**URL:** <https://meta.discourse.org/t/exclude-groups-from-top-quality-members-query/156510>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [1. Juli 2020 um 18:42 UTC](https://meta.discourse.org/t/exclude-groups-from-top-quality-members-query/156510 "2020-07-01T18:42:12Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [1. Juli 2020 um 20:57 UTC](https://meta.discourse.org/t/exclude-groups-from-top-quality-members-query/156510/2 "2020-07-01T20:57:32Z")

</div>

Ich habe das nicht wirklich getestet.

```sql
-- [params]
-- int_list :exclude_groups = 12, 2, 3

SELECT 
    sum(p.score) / count(p) as "durchschnittliche Punktzahl pro Beitrag", 
    count(p.id) as anzahl_beitraege, 
    p.user_id
FROM posts p
JOIN users u ON u.id = p.user_id
LEFT JOIN group_users gu on u.id = gu.user_id
WHERE p.created_at >= CURRENT_DATE - INTERVAL '3 month'
  AND u.active
  AND (gu.group_id not IN (:exclude_groups))
GROUP by p.user_id, u.views
HAVING count(p.id) > 40
ORDER BY sum(p.score) / count(p) DESC
LIMIT 100

```

---

_[View the full topic](https://meta.discourse.org/t/exclude-groups-from-top-quality-members-query/156510)._