Welcome Guest! To enable all features please
Login or Register.
How can we find a list of the most popular postings - i.e. with the most "read" numbers? If we don't have this feature it would be great to get it. I think the forum keeps this info on the database, so it's just one query to get it ordered by this number DESC and show. Although the links to these topics/postings would be helpful as well.
Also, 'most thanked' would be a great feature to show the forum's 'best posts'
One more thing - the most popular Topic on my forum is :Forum FAQ: :cheesy: The 5-th place is taken by "Forum Rules".
Here is how I got it:
SELECT TOP 25 *
ORDER BY [Views] DESC
So it looks like we need a way to exclude some topics from this rating.
You can see this SQL query (with a WHERE clause for time frame) on my site. http://packershome.com/Top10.aspx
I've renamed Thanks to Applause.
SELECT TOP 10 COUNT([MessageID]) as 'Applause', [yaf_User].[Name] as 'Member'
INNER JOIN [yaf_User]
ON [yaf_Thanks].[ThanksToUserID] = [yaf_User].[UserID]
GROUP BY [yaf_Thanks].[MessageID], [yaf_User].[Name]
ORDER BY COUNT([MessageID]) DESC
This query just shows the top 10 Thanked posts along with the member name by the amount of times it was Thanked.
Edited by user
| Reason: Not specified
- You cannot post new topics in this forum.
- You cannot reply to topics in this forum.
- You cannot delete your posts in this forum.
- You cannot edit your posts in this forum.
- You cannot create polls in this forum.
- You cannot vote in polls in this forum.