select Comments.Id as [Comment Link], Posts.ClosedDate as...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Comments.Id as [Comment Link], Posts.ClosedDate as Closed, Comments.CreationDate from Comments
  inner join Posts on Comments.PostId = Posts.Id
  where (
      lower(Text) like '%report%'
    ) and Comments.CreationDate > '2018-10-01'
  order by Comments.CreationDate DESC

Enter Parameters

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