Select Top(@Count) site_News.NewsID, site_News.Title, count(site_Replies.ReplyID) as 'replies-count' From site_News Inner Join site_Replies on site_News.NewsID = site_Replies.NewsID Inner Join site_Categories on site_News.CategoryID = site_Categories.CategoryID Where site_news.AddDate > DATEADD (day , -7 , GETDATE() ) And site_Replies.Accept = 1 And site_Replies.Active = 1 And site_Categories.LanguageID = @LanguageID group by site_News.NewsID, site_News.Title order by 'replies-count' desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)