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)

Stack Overflow

Q&A for professional and enthusiast programmers

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 sites:
loading Hold tight while we fetch your results