Answers that confess they should be comments

2

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

-- StartDate The starting date of the search window
-- Days The size of the search window
select
id [Post Link], body
from posts
where posttypeid = 2
and creationdate between '##StartDate?2015-01-01## 00:00:00'
and CONVERT(DATETIME, DATEADD(day, ##Days?30##, '##StartDate##')) 
and (
  body like '%my rep%'
  or
  body like '%not enough rep%'
  or
  body like '%I don''t have enough rep%'
  or
  body like '%should be a comment%'
  or
  body like '%should have been a comment%'
  )

Enter Parameters

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