latest first
Q&A about the site for professional and enthusiast programmers
SELECT Posts.Score, Posts.Id AS [Post Link], Posts.CreationDate, Posts.LastEditDate FROM PostHistory JOIN Posts ON PostHistory.PostId = Posts.Id WHERE PostHistory.PostHistoryTypeId = 6 AND PostHistory.Text LIKE '%<featured>%' GROUP BY Posts.Score, Posts.Id, Posts.CreationDate, Posts.LastEditDate ORDER BY Posts.LastEditDate DESC