Candidate questions for deletion

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 CAST(PostHistory.Comment AS int) AS CloseReasonId, Posts.Id [Post Link], Posts.Score
FROM PostHistory
JOIN Posts
ON Posts.Id = PostHistory.PostId
WHERE PostHistory.PostHistoryTypeId = 10
AND CAST(PostHistory.Comment AS int) IN (2,4,7,10)
ORDER BY Posts.Score ASC

Enter Parameters

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