0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 14 19

created oct 14 19 Anton.Kahwaji