Search for comments that prevent roomba deletion

2

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
    c.Id as [Comment Link] 
from
    Comments C
inner join Posts p on p.Id = c.PostId 
where p.AnswerCount=0 
  and p.Score=0 
  and p.CommentCount=2 
  and p.CreationDate < (DateAdd(d, -365, GetDate())) 
  and lower(c.Text) like lower('##search##%')  
order by len(Text) asc

Enter Parameters

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