0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, scientists, programmers, and computing professionals interested in quantum computing

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

fork query

created aug 23 11 waiwai933