Questions you commented on with downvotes that were edited by the OP afterwards


Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select as [Post Link]
     , max(c.creationdate) as [Last Commented]
     , max(ph.creationdate) as [Last OP Edit]
     , max(p.closeddate) as [Closed]
  from comments c
  join posts p
    on c.postid =
   and c.userid <> p.owneruserid
   and p.lasteditdate > c.creationdate
  join posthistory ph
    on = ph.postid
   and p.owneruserid = ph.userid
   and ph.creationdate > c.creationdate
  join votes v
    on = v.postid
   and v.creationdate < ph.creationdate
 where c.userid = ##userid##
   and p.posttypeid = 1
   and ph.posthistorytypeid = 5
   and v.votetypeid = 3
 group by
 order by max(ph.creationdate) desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results