0

Please login or register to vote for this query.

(click on this box to dismiss)

Closed questions that either have answers or haven't been downvoted. These won't go away unless you make them. (This only checks for the 30-days rule; see http://meta.stackoverflow.com/a/92006 for the full criteria.)

Q&A for professional and enthusiast programmers

SELECT Score,
       Id                                                                AS [Post Link],
       CASE WHEN AnswerCount = 0 THEN NULL ELSE AnswerCount END          AS Answers,
       CASE WHEN AcceptedAnswerId   IS NOT NULL THEN 'Yes' ELSE NULL END AS Accepted,
       CASE WHEN CommunityOwnedDate IS NOT NULL THEN 'Yes' ELSE NULL END AS Wiki,
       CommentCount                                                      AS Comments,
       ViewCount                                                         AS Views,
       OwnerUserId                                                       AS [User Link]
FROM   Posts
WHERE  ClosedDate IS NOT NULL -- closed
AND ClosedDate <= DATEADD(mm, -1, GETDATE())
AND (Score >= 0  OR (AnswerCount IS NOT NULL AND AnswerCount > 0)) -- either not downvoted, or has answers
AND Score < 20
ORDER BY ClosedDate, Score ASC

fork query

edited mar 14 12 jon.doe6850

created feb 27 12 e