closed posts from 2012 by score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT top 3 p1.Id [Post Link], score
    FROM PostHistory
    JOIN Posts AS p1 ON p1.Id = PostHistory.PostId
    WHERE p1.ClosedDate >= '2012-01-01'
    AND p1.ClosedDate < '2013-02-01'
    AND PostHistoryTypeId = 10
    AND PostHistory.Comment != 1
    ORDER BY score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results