select top 1000 c.id as [Comment Link] from comments c wh...

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 top 1000 c.id as [Comment Link]
from comments c
where text like '%downvote%' -- or text like '%down vote%'
and not exists (
  select  1 
  from  votes v 
  where v.postid = c.postid 
  and v.votetypeid = 3 -- downvote
  )

Enter Parameters

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