Bumped by Community User (more than 5 times)

1

Please login or register to vote for this query.

(click on this box to dismiss)

TODO: add Answer count

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT P.ID as [Post Link] , B.BumpCount, P.Score, P.CreationDate, P.AnswerCount
  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
     WHERE acceptedanswerid IS NULL
  ORDER BY B.BumpCount DESC, P.ID

Enter Parameters

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