Closed questions that won't be auto-deleted within a month, excluding duplicates


Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

FROM   Posts p
        LEFT JOIN PostHistory h
        ON h.PostId = p.Id
              AND h.CreationDate = p.ClosedDate
              AND PostHistoryTypeId = 10
              AND Comment = '1'
       AND p.ClosedDate IS NOT NULL -- closed
       AND ( p.Score >= 0 OR  p.AnswerCount > 0) -- either not downvoted, or has answers

       p.Id                                                                AS [Post Link],
       CASE WHEN p.AnswerCount = 0 THEN NULL ELSE p.AnswerCount END          AS Answers,
       CASE WHEN p.AcceptedAnswerId   IS NOT NULL THEN 'Yes' ELSE NULL END AS Accepted,
       CASE WHEN p.CommunityOwnedDate IS NOT NULL THEN 'Yes' ELSE NULL END AS Wiki,
       p.CommentCount                                                      AS Comments,
       p.ViewCount                                                         AS Views,
       p.OwnerUserId  AS [User Link]

ORDER  BY  p.Score ASC,  p.CreationDate DESC*/

Enter Parameters

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