0

Please login or register to vote for this query.

(click on this box to dismiss)

Show the top X most viewed questions on a site

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT TOP ##ResultSize## Id as [Post Link], ViewCount, Score From Posts
WHERE CreationDate > GETDATE() - ##Days## 
AND Tags like '%##Tags##%' AND Tags NOT like '%##Tagsn##%' 
ORDER BY ViewCount DESC

fork query

edited sep 21 anonymous

created oct 16 12 Marco Ceppi