Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
select top 100 posts.id, posts.score, posts.viewcount, posts.closeddate, posthistory.comment
join posts on posts.id = posthistory.postid
where posts.closeddate > '2012-09-01' and posts.closeddate < '2012-12-01'
and posthistorytypeid = 10
order by posts.ownerdisplayname