0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT PostId [Post Link], UserId [User Link], CreationDate, UserDisplayName, Comment
FROM 
  postHistory 
WHERE 
 posthistoryTypeid = 33
 AND UserID IS NULL
/*
   33 Post Notice Added
   34 Post Notice Removed
 */
ORDER BY CreationDate DESC

fork query

edited jan 8 22 Jeff Schaller

created mar 27 13 conradfrix