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

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select p.id 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 = p.id
   and c.userid <> p.owneruserid
   and p.lasteditdate > c.creationdate
  join posthistory ph
    on p.id = ph.postid
   and p.owneruserid = ph.userid
   and ph.creationdate > c.creationdate
  join votes v
    on p.id = 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 p.id
 order by max(ph.creationdate) desc

Enter Parameters

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