Recent comments containing "downvote"

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 lower(text), count(text) as num_comments
FROM Comments    
WHERE creationDate BETWEEN DATEADD(DAY,-60,GETDATE()) AND GETDATE()
  and text like '%downvote%' 
  GROUP BY lower(text)
HAVING count(text) > 3
ORDER BY num_comments desc;

Enter Parameters

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