Q&A about the site for professional and academic economists and analysts
SELECT Posts.ClosedDate, CONCAT ('http://programmers.stackexchange.com/q/', Posts.Id) as Question FROM PostHistory JOIN Posts ON Posts.Id = PostHistory.PostId WHERE Posts.ClosedDate >= '2012-01-01' --AND Posts.ClosedDate < '2012-12-01' AND PostHistoryTypeId = 10 AND PostHistory.Comment != 1 ORDER BY Posts.ClosedDate