SuperSekrit

2

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

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 p.PostTypeId = 1
  and c.PostId = p.Id
  and ph.postId = p.Id
  and ph.postHistoryTypeId = 11 -- reopen
  and c.CreationDate < ph.CreationDate
  and p.CreationDate >= DateAdd(month, - ##History:int?6## , CURRENT_TIMESTAMP)
  and (   Lower(c.Text) like ('%off%topic%')
      or (Lower(c.Text) like '%include%' and Lower(c.Text) like '%code%')
      or Lower(c.Text) like '%work%')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results