Top 100 questions by tags in the last year (sorted by viewcount)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100 Id,Title,CreationDate,Tags,ClosedDate,FavoriteCount,ViewCount,Score 
FROM Posts 
WHERE PostTypeId = 1 
AND Tags LIKE '%##TagName1##%' 
AND Tags LIKE '%##TagName2##%' 
AND Tags NOT LIKE '%##ExcludedTag##%'
And Posts.CreationDate > GETDATE() - 365
ORDER BY ViewCount DESC, FavoriteCount DESC, Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results