0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- 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

created oct 28 19 Alex Shabanov