Zwei Benutzer warten auf Genehmigung, sind aber nicht in RQ – wo sind sie?

[Moin]

I think this was also mentioned here:

Notification claims X users for approval, but none are found

I found this topic while searching before filing a bug report, so adding to it. TL;DR the query for the notification is wrong because it counts rejected users as well. Notification: 16 users waiting for approval, click the link, see only 2. The query used for the notification is this puts AdminUserIndexQuery.new(query: "pending", stats: false).find_users_query.to_sql SELECT "users".* FROM "users" WHERE (suspended_till IS NULL OR suspended_till <= '2023-11-13 11:05:23.225614') AND "users".…