Bumped by Community User (more than 5 times)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT P.ID, 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

Enter Parameters

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