Q&A for professional and enthusiast programmers
DECLARE @Tag VARCHAR(25) = '##Tag##' SELECT TOP 10000 Questions.Id AS [Post Link], Questions.Tags, Questions.ViewCount, Questions.CreationDate FROM Posts AS Questions INNER JOIN PostTags ON PostTags.PostId = Questions.Id INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName = @Tag AND Questions.CreationDate > '2000-01-01 00:00:00' ORDER BY ViewCount DESC