Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
-- note that 'top 50' is VERY important or else it will throw an exception select top 50 p.Id as [Post Link], p.Title, p.Score, p.ViewCount, p.CreationDate, p.Tags from Posts p --join Tags t on t.TagName = 'c#' --join PostTags pt on pt.PostId = p.Id and pt.TagId = t.Id where p.PostTypeId = 1 and DatePart(Year, p.CreationDate) >= 2005 --order by p.ViewCount desc order by p.CreationDate