PostsWithDeleted_onlyvalid

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT Id, PostTypeId, CreationDate, DeletionDate, ClosedDate
FROM dbo.PostsWithDeleted
WHERE PostTypeId=1 AND (
 (DeletionDate IS NOT NULL) OR
 (ClosedDate IS NOT NULL)) AND 
  (CreationDate >= '2013-01-01 00:00:00' AND
   Creationdate <= '2013-01-20 23:59:59')
ORDER BY  CreationDate

Enter Parameters

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