bumps&stuff

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

Q&A about the site for people studying math at any level and professionals in related fields

SELECT 
  PostHistory.PostId,
  (
    SELECT COUNT(Hist.Id)
    FROM
      PostHistory as Hist
    WHERE
      Hist.PostId = PostHistory.PostId AND
      Hist.PostHistoryTypeId = 50 AND
      Hist.CreationDate < '2021-12-01'
  ) as 'Total Bumps'
FROM
  PostHistory
WHERE
  PostHistory.PostHistoryTypeId = 50 AND
  PostHistory.CreationDate > '2021-01-01' AND
  PostHistory.CreationDate < '2021-12-01'
GROUP BY
  PostHistory.PostId
ORDER BY
  'Total Bumps' DESC

Enter Parameters

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