0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited dec 12 19 jon.doe32825

created mar 29 18 anonymous