Questions eligible for Archaeology

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/76485/old-unanswered-inactive-questions-with-low-views-votes

Open Data

Q&A for developers and researchers interested in open data

-- Really old questions, no upvotes, <100 views, low rep OP, not seen in last year
-- http://meta.stackoverflow.com/questions/76485/old-unanswered-inactive-questions-with-low-views-votes

SELECT TOP 1000 
   p.Id AS [Post Link]
FROM Posts p
INNER JOIN Users U on P.OwnerUserId = U.Id
WHERE p.PostTypeId = 1
   AND p.LastActivityDate < DATEADD(month, -7, GETDATE())
ORDER BY Year(p.LastActivityDate), Month(p.LastActivityDate), p.Score, p.ViewCount

Enter Parameters

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