YAFLogo

Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2011-04-26T09:24:24Z
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.
Dimi

UserPostedImage

Sponsor
RichP714
  • RichP714
  • 100% (Exalted)
  • YAF All-the-Time
2011-04-26T21:10:02Z
Also, 'most thanked' would be a great feature to show the forum's 'best posts'
Enjoy!

Running YAF 1.9.5.5 final at: http://thecarversite.com 

Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2011-05-06T05:43:16Z
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 *

FROM [HappyAnkle].[dbo].[yaf_Topic]

ORDER BY [Views] DESC

So it looks like we need a way to exclude some topics from this rating.


Dimi

UserPostedImage

Zero2Cool
2012-10-23T12:53:42Z
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' 
FROM [yaf_Thanks] 
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.