Q&A about the site for administrators, end users, developers and designers for Craft CMS
select 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'