Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
select top 100 concat ('http://stackoverflow.com/q/', posts.id) as question, posts.score, posts.viewcount, posts.closeddate, posthistory.comment as closereasonid from posthistory join posts on posts.id = posthistory.postid where posts.closeddate > '2012-09-01' and posts.closeddate < '2012-12-01' and posthistorytypeid = 10 order by newid()