Q&A about the site for administrators, end users, developers and designers for Craft CMS
select * from posts join posthistory on posts.id = posthistory.postid where closeddate > '2012-09-01' and closeddate < '2012-12-01'