SuperSekritTypo

0

Please login or register to vote for this query.

(click on this box to dismiss)

Comments which perhaps suggest corrections are needed, and the comment is followed by an edit from the post owner (probably making the comment obsolete)

Stack Overflow

Q&A for professional and enthusiast programmers

Select p.Id as [Post Link],
       c.userId as [User Link],
       c.userDisplayName,
       Convert (Date, p.CreationDate) as Date,
       c.Id as [Comment Link]
from Posts p, Comments c, PostHistory ph
where c.PostId = p.Id
  and ph.postId = p.Id
  and ph.UserId = p.OwnerUserId
  and ph.postHistoryTypeId = 5 -- edit
  and c.CreationDate < ph.CreationDate
  and p.ClosedDate is null
  and p.CreationDate >= DateAdd(month, - ##History:int?6## , CURRENT_TIMESTAMP)
  and (  Lower(c.Text) like '%typo%'
      or Lower(c.Text) like '%missing%'
      or Lower(c.Text) like '%work%')

Enter Parameters

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