# Disattiva in blocco gli utenti con una query SQL
**URL:** https://meta.discourse.org/t/bulk-deactivate-users-with-sql-query/88818
**Category:** Support
**Created:** [31 Maggio 2018, 9:59am UTC](https://meta.discourse.org/t/bulk-deactivate-users-with-sql-query/88818 "2018-05-31T09:59:01Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@bekircem](https://meta.discourse.org/u/bekircem)
#### Post date: [31 Maggio 2018, 9:59am UTC](https://meta.discourse.org/t/bulk-deactivate-users-with-sql-query/88818/1 "2018-05-31T09:59:01Z")
I need deactivate users who has fake email.
I mentioned here:
[https://meta.discourse.org/t/i-imported-migrated-many-users-with-bad-old-invalid-email-addresses/88813](https://meta.discourse.org/t/i-imported-migrated-many-users-with-bad-old-invalid-email-addresses/88813)
```
cd /var/discourse
./launcher enter app
rails c
```
I write SQL query for that:
`User.where("user_stats.post_count = 0 AND last_seen_at <= '2017-01-01' AND active = true").update_all(active: false)`
Output:
`[1] pry(main)> User.joins(:user_stat).where("user_stats.post_count = 0 AND last_[1] pry(main)> User.joins(:user_stat).where("user_stats.post_count = 0 AND last_=> 4591 <= '2017-01-01' AND active = true").update_all(active: false)`
It seems worked. Please backup your Discourse before run that SQL.
Do you have any better suggestions?
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [31 Maggio 2018, 5:10pm UTC](https://meta.discourse.org/t/bulk-deactivate-users-with-sql-query/88818/2 "2018-05-31T17:10:22Z")
Seems fine. Here’s mine that just does pretty much everyone:
```ruby
def deactivate_all_users
User.where("active = true and admin != true").update_all(active: false)
end
```
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [29 Novembre 2020, 7:22am UTC](https://meta.discourse.org/t/bulk-deactivate-users-with-sql-query/88818/3 "2020-11-29T07:22:46Z")