0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT P.ID as [Post Link] , B.BumpCount, P.Score, P.CreationDate, P.Title
  FROM Posts AS P
  JOIN (SELECT PostID, COUNT(*) AS BumpCount
          FROM PostHistory
         WHERE PostHistoryTypeID  = 50
         GROUP BY PostID
        HAVING COUNT(*) > 5) AS B
     ON P.ID = B.PostID
  ORDER BY B.BumpCount DESC, P.ID

fork query

edited feb 22 21 Jeff Schaller

created apr 9 17 Jonathan Leffler