Does anyone answer I Downvoted it

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

Select 
       
       a.text,
       a.creationDate,
       a.PostID [Post Link]
from 
    comments wdv
    INNER JOIN Comments a
    ON wdv.postid = a.postid
       and wdv.creationDate < a.creationDate

where 
      (wdv.text like '%why%downvote%'
      or wdv.text like '%downvoter care%')
      
      and
      
      (a.text like '%I was %downvote%'
      or
      a.text like '%I downvote%'
      or
      a.text like '%I am %downvote%'
       or
       a.text like '-1 This is wrong%')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached