Q&A about the site for biology researchers, academics, and students
DECLARE @Tag VARCHAR(25) = '##Tag##' SELECT TOP 10000 Questions.Id AS [Post Link], Questions.Title, Questions.Tags, Questions.AnswerCount, Questions.ViewCount FROM Posts AS Questions INNER JOIN PostTags ON PostTags.PostId = Questions.Id INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName = @Tag ORDER BY ViewCount DESC