Meta Stack Overflow [featured] history

0

Please login or register to vote for this query.

(click on this box to dismiss)

latest first

Meta Stack Overflow

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results