Revision comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows revision comments after removing the automated comments. Real comments, real people, really interesting. Sometimes.

Meta Stack Overflow

Q&A about Stack Overflow, Server Fault and Super User

-- Post revision comments
-- Shows revision comments after removing the automated comments.  Real comments, real people, really interesting.  Sometimes.
select Comment, PostId
from PostHistory
where LEN(Comment) > 1 
  AND NOT Comment LIKE 'edited%'
  AND NOT Comment LIKE 'added%'
  AND NOT Comment LIKE 'deleted%'
  AND NOT Comment LIKE 'merging%'
  AND NOT Comment LIKE 'insert%'
  AND NOT Comment LIKE 'Rollback%'
  AND NOT Comment LIKE 'from%'
  AND NOT Comment LIKE 'Proposed%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached