# מסנן רמת אמון משתמש לא עובד עבור vote plugin?

**URL:** <https://meta.discourse.org/t/user-trust-level-filter-not-working-for-vote-plugin/233105>\
**Category:** Data & reporting\
**Tags:** topic-voting, sql-query\
**Created:** [17 ביולי,‏ 2022,‏ 2:56pm UTC](https://meta.discourse.org/t/user-trust-level-filter-not-working-for-vote-plugin/233105 "2022-07-17T14:56:17Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Matt0x01](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/matt0x01/32/264811_2.png) [@Matt0x01](https://meta.discourse.org/u/Matt0x01)\
**Post date:** [17 ביולי,‏ 2022,‏ 2:56pm UTC](https://meta.discourse.org/t/user-trust-level-filter-not-working-for-vote-plugin/233105/1 "2022-07-17T14:56:17Z")

</div>

Issue in title. Any idea how to fix?

```plaintext
SELECT 
dvc.votes_count AS vote_count,
t.id AS topic_id

FROM topics t
    INNER JOIN discourse_voting_topic_vote_count dvc ON dvc.topic_id = t.id
    INNER JOIN users u ON t.user_id = u.id
    INNER JOIN post_actions pa ON pa.user_id = u.id
    INNER JOIN users u2 ON pa.user_id = u2.id
WHERE t.category_id = 20
    AND u2.trust_level >= 1
    
GROUP BY dvc.votes_count, t.id, pa.user_id
ORDER BY vote_count DESC

```

---

_[View the full topic](https://meta.discourse.org/t/user-trust-level-filter-not-working-for-vote-plugin/233105)._