fix(users): improve recently active search

[Altahrim]

• Resolves: #46777

Summary

• Remove DISTINCT clause to fix PgSQL
• Use data from users only if necessary (search)
• Don't show people who never connected in active list
• Add test
• Add hard limit on list (100 users max)

TODO

• [x] badge still count all users instead of actives ones

Checklist

• Code is properly formatted
• Sign-off message is added to all commits
• [x] Tests (unit, integration, api and/or acceptance) are included
• [x] Screenshots before/after for front-end changes
• [x] Documentation (manuals or wiki) has been updated or is not required
• [x] Backports requested where applicable (ex: critical bugfixes)

[Altahrim]

/backport to stable30