0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

SELECT 
  PostHistory.PostId
FROM
  PostHistory,
  PostHistoryTypes
WHERE
  PostHistory.PostHistoryTypeId = PostHistoryTypes.Id AND
  PostHistoryTypes.Name = 'CommunityBump' AND
  PostHistory.CreationDate > '2021-01-01' AND
  PostHistory.CreationDate < '2021-12-01'
GROUP BY
  PostHistory.PostId

fork query

created nov 30 anonymous