0

Please login or register to vote for this query.

(click on this box to dismiss)

This query will show the posts closed as Off-Topic within the past 3 months which are tagged homework (though those two can be redefined).

Q&A for active researchers, academics and students of physics

SELECT 
  Posts.ClosedDate, 
  Posts.Tags, 
  Posts.Body, 
  PostHistory.Id, 
  PostHistory.PostHistoryTypeId, 
  PostHistory.Comment
FROM Posts
JOIN PostHistory
ON Posts.Id=PostHistory.PostId
WHERE 
  Posts.ClosedDate IS NOT NULL
AND
  Posts.ClosedDate >= Convert(datetime, '2014-01-01' )
AND
  PostHistory.PostHistoryTypeId=10

view current version

edited jan 20 14

created jan 20 14 E.P.