0

Please login or register to vote for this query.

(click on this box to dismiss)

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%'
      or
      a.text like '%wrong%')

fork query

edited feb 22 13 Sinkhronize

created feb 22 13 conradfrix