0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jun 22 Samuel Liew

created may 8 18 E.P.