Does anyone answer I Downvoted it

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

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%downvot%'
      or wdv.text like '%downvot%expla%')
      
      and
      
      (a.text like '%I%downvot%'
      or
      a.text like '%I%downvot%'
      or
      a.text like '-1%')

Enter Parameters

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