0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Candidate questions for deletion (older than 15 July 2012)

SELECT CAST(PostHistory.Comment AS int) AS CloseReasonId, Posts.Id [Post Link], Posts.Score, PostHistory.CreationDate
FROM PostHistory
JOIN Posts
ON Posts.Id = PostHistory.PostId
WHERE PostHistory.PostHistoryTypeId = 10
AND CAST(PostHistory.Comment AS int) IN (2,4,7,10)
AND PostHistory.CreationDate < '2011-07-15'
ORDER BY Posts.Score ASC

fork query

edited aug 15 12

created dec 4 11 waiwai933