user: hide virtual actors from statistics queries

1 files changed, 5 insertions, 1 deletions

diff --git a/lib/pleroma/user.ex b/lib/pleroma/user.ex
index 8d8c53dfc..5e46208c3 100644
--- a/lib/pleroma/user.ex
+++ b/lib/pleroma/user.ex
@@ -578,7 +578,11 @@ defmodule Pleroma.User do
   end
 
   def local_user_query() do
-    from(u in User, where: u.local == true)
+    from(
+      u in User,
+      where: u.local == true,
+      where: not is_nil(u.nickname)
+    )
   end
 
   def deactivate(%User{} = user) do