foiovitor
Active member
Hello all,
I like to share with my community the tops of 2016:
- Top 10 - Threads started in 2016 with more replies.
- Top 10 - Absolute threads with more replies in 2016 (including all threads, started from the beginning of community).
- Top 10 - Threads started in 2016 with more views.
- Top 10 - Absolute threads with more views in 2016 (including all threads, started from the beginning of community).
- Top 10 - Threads started in 2016 with more watched.
- Top 10 - Absolute threads with more "Watch Thread" in 2016 (including all threads, started from the beginning of community).
- Top 10 - Posts with more Likes in 2016.
- Top 10 - Users with more Likes in 2016.
- Top 10 - Users with better likes/posts in 2016.
- Absolute number of threads started in 2016.
- Absolute number of posts in 2016.
- Absolute number of likes in 2016.
- Absolute number of new users in 2016.
- Absolute number of users logged in at 2016.
- Absolute number of users that interact (posts/likes) in 2016.
- (someone have more ideias?)
How to find this tops? Maybe using some MySQl queries? Love to see a collaborative way of get all this items to be shared by each of us with our members.
Best,
Vitor
I like to share with my community the tops of 2016:
- Top 10 - Threads started in 2016 with more replies.
- Top 10 - Absolute threads with more replies in 2016 (including all threads, started from the beginning of community).
- Top 10 - Threads started in 2016 with more views.
- Top 10 - Absolute threads with more views in 2016 (including all threads, started from the beginning of community).
- Top 10 - Threads started in 2016 with more watched.
- Top 10 - Absolute threads with more "Watch Thread" in 2016 (including all threads, started from the beginning of community).
- Top 10 - Posts with more Likes in 2016.
- Top 10 - Users with more Likes in 2016.
- Top 10 - Users with better likes/posts in 2016.
- Absolute number of threads started in 2016.
- Absolute number of posts in 2016.
- Absolute number of likes in 2016.
- Absolute number of new users in 2016.
- Absolute number of users logged in at 2016.
- Absolute number of users that interact (posts/likes) in 2016.
- (someone have more ideias?)
How to find this tops? Maybe using some MySQl queries? Love to see a collaborative way of get all this items to be shared by each of us with our members.
Best,
Vitor
Last edited: