Top Trending Windows 8 Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

SELECT distinct lastactivitydate,viewcount, title, p.creationdate, p.closeddate, p.acceptedanswerid, answercount, 
'http://stackoverflow.com/questions/' + CAST(p.Id AS VARCHAR(255))
from Posts p
    join PostTags pt on pt.PostId = p.Id
    join Tags t on t.Id = pt.TagId
    where t.TagName in ('windows-8', 'microsoft-metro', 'metro-style-app', 'windows-store-apps')
AND (lastactivitydate BETWEEN dateadd(day, -30, getdate()) AND getdate()
AND closeddate IS NULL)
ORDER BY viewcount DESC, answercount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results