http://meta.stackoverflow.com/questions/76485/old-unanswered-inactive-questions-with-low-views-votes
Q&A for linguists, teachers and students of the Ukrainian language
-- 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.ViewCount < 100 AND p.Score < 1 AND p.AcceptedAnswerId IS NULL AND U.LastAccessDate < DATEADD(month, -24, GETDATE()) ORDER BY Year(p.LastActivityDate), Month(p.LastActivityDate), p.Score, p.ViewCount