Posts closed since 01/2012 by month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 50 posts.id, posts.score, posts.viewcount, posts.closeddate, posthistory.comment 
from posthistory
join posts on posts.id = posthistory.postid
where posts.closeddate > '2012-09-01' and posts.closeddate < '2012-12-01'
and posthistorytypeid = 10

Enter Parameters

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