0

Please login or register to vote for this query.

(click on this box to dismiss)

Really old, low views, low votes and even unanswered questions. http://chat.stackexchange.com/transcript/message/409809#409809

Q&A about the site for serious players and enthusiasts of chess

-- Abandoned Questions with inactive owners
-- Really old, low views, low votes and even unanswered questions.
-- http://chat.stackexchange.com/transcript/message/409809#409809

SELECT TOP 1000
  p.Score,
  p.Id AS [Post Link],
  p.ViewCount,
  p.Tags,
  CONVERT(varchar(4),Year(p.LastActivityDate)) + '-' + CONVERT(varchar(2),Month(p.LastActivityDate)) AS QLastUpdate,
  u.Id as [User Link],
  CONVERT(varchar(4),Year(u.LastAccessDate)) + '-' + CONVERT(varchar(2),Month(u.LastAccessDate)) AS ULastAcc

FROM Posts p
LEFT JOIN Posts a ON a.ParentId = p.Id AND a.Score = 0
LEFT JOIN Users u on p.OwnerUserId = u.Id

WHERE p.PostTypeId = 1
  AND p.ViewCount < 200
  AND p.Score < 4
  AND p.AcceptedAnswerId IS NULL
  AND a.Id IS NULL
  AND p.LastActivityDate < dateadd(month,-6,getdate())
  AND u.LastAccessDate <dateadd(month,-3,getdate())

ORDER BY
  Year(p.LastActivityDate),
  Month(p.LastActivityDate),
  p.Score,
  p.ViewCount

fork query

created jan 25 11 DMA57361