http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660I just migrated to SubText yesterday and a I used your query to learn a little bit about the SubText database. Because my blog is not as popular as yours, I found a small "bug" (maybe designed that way) in the query. Posts that don't have comments (as I said, I'm not that popular) doesn't show in the results. I did a small change in the query to fix it: WHERE FeedbackType = 1 OR FeedbackType IS NULL Now it's working for me http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment9http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment9Mon, 07 May 2007 12:48:34 GMTTechnorati recently released their latest State of The Blogosphere report (renamed to something about http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment8http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment8Sat, 07 Apr 2007 00:50:56 GMTState Of The Blog Report http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment7http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment7Fri, 06 Apr 2007 23:36:53 GMTMy 15 Most Popular Posts, via Steve, via Ayende http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment6http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment6Tue, 13 Mar 2007 22:53:09 GMTMy 15 Most Popular Posts, via Ayende http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment5http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment5Tue, 13 Mar 2007 02:40:56 GMT*sniff, sniff* I think I smell a the start of a really cool Plug-in for Subtext v2.0! This query, and some of the ones from your previous "Blog Stats: SQL" post would be a solid basis around with to build a plugin/skin control for showing off some of the less obvious (but very interesting) stats that your blog has to offer. http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment4http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment4Tue, 13 Mar 2007 01:57:53 GMTYou could pass parameters for the different types, so that wouldn't be a problem http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment3http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment3Sat, 10 Mar 2007 19:49:46 GMTThis is great ! I was looking to do something like this, just like Community Server has "Most Popular" sections... Do you think it could be made even more configurable, by passing the points for each type from web.config or somewhere, so that individual bloggers can configure their "most popular" post without recompiling the SP ? -Shiva http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment2http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment2Sat, 10 Mar 2007 18:49:49 GMTSorry, that counts only those that have at least one comment. http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment1http://ayende.com/2198/calculating-most-popular-posts-with-subtext#comment1Fri, 09 Mar 2007 20:48:39 GMT