XF 2.2 How to find the most active members in 2023?


Well-known member

I'd like to make a post on my forum to list and thank members who were the most active last year. Can anybody suggest how to find them?

It's easy for new members who registered in 2023. In ACP -> Users I can filter by the registration period and then sort them by posts number or received reactions.

But what about old(many many years) members? Can I somehow see the amount of posts/reactions they made/received in 2023?
I guess I could run some sql request in posts table, where date of post > n. That will give me total number of posts. I remember that there is "count" or something, that would give me an array with usernames as keys and post count as value.

Can you help with this please?
Top Bottom