Candidate questions for deletion (older than 15 July 2012)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology

Q&A for enthusiasts and scholars of mythology and folklore

-- 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

Enter Parameters

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