Running YAF 220.127.116.11 final at: http://thecarversite.com
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.
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.