HNQ-ed, de-HNQ-ed and community bumped questions since the last week

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

DECLARE @Since DATETIME;

SELECT @Since = DATEADD(day, -7, MAX(CreationDate))
FROM Posts;

SELECT
  PostHistory.PostId AS [Post Link],
  PostHistoryTypes.Name,
  PostHistory.CreationDate
FROM PostHistory, PostHistoryTypes
WHERE
  PostHistory.PostHistoryTypeId >= 50
  AND
  PostHistoryTypes.Id = PostHistory.PostHistoryTypeId
  AND
  PostHistory.CreationDate > @Since
ORDER BY PostHistory.Id DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results