TODO: add Answer count
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