Q&A about the site for professional and independent game developers
SELECT 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 NEWID()