# Gebruikersflair blijft bestaan nadat de gebruiker uit de groep is verwijderd

**URL:** <https://meta.discourse.org/t/user-flair-remains-after-user-is-removed-from-group/197293>\
**Category:** Bug\
**Created:** [15 juli 2021 om 21:10 UTC](https://meta.discourse.org/t/user-flair-remains-after-user-is-removed-from-group/197293 "2021-07-15T21:10:49Z")\
**Posts on this page:** 1\
**Showing post:** 28

<div class="post-metadata">

**Author:** ![kinetiksoft](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kinetiksoft/32/229578_2.png) [@kinetiksoft](https://meta.discourse.org/u/kinetiksoft)\
**Post date:** [23 september 2021 om 12:21 UTC](https://meta.discourse.org/t/user-flair-remains-after-user-is-removed-from-group/197293/28 "2021-09-23T12:21:28Z")

</div>

Dear @vinothkannans, we’re upgraded discourse version & ran the query you provided:

```plaintext
[1] pry(main)> User.joins("LEFT OUTER JOIN group_users ON group_users.user_id = users.id AND group_users.group_id = users.flair_group_id").where(group_users: { id: nil }).where.not(flair_group_id: nil).update_all(flair_group_id: nil)
=> 370
[2] pry(main)> 

```

I see user flairs changed according to their group status. Thank you again for prompt assistance!

---

_[View the full topic](https://meta.discourse.org/t/user-flair-remains-after-user-is-removed-from-group/197293)._
