Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences
DECLARE @Tag VARCHAR(25) = '##Tag##' SELECT TOP 50 Q.Id AS [Post Link], Q.Tags, Q.AnswerCount, Q.ViewCount FROM Posts AS Q INNER JOIN PostTags AS P ON P.PostId = Q.Id INNER JOIN Tags AS T ON T.Id = P.TagId WHERE T.TagName = @Tag ORDER BY Q.ViewCount DESC