Closed questions on which you COMMENTED (and whether they were edited after close)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select 
  id as [Post Link],
  Score,
  viewcount as [Views],
  owneruserid as [Asker],
  creationdate as [Asked],
  closeddate as [Closed],
  lasteditdate as [Edited],
  case when lasteditdate>closeddate then 'yes' else 'no' end as [Edited After Close?]
from posts
where 
  closeddate is not null
  and id in
   (select distinct postid from comments where userid=##UserID##) --my comments
order by creationdate desc

--UserID: Enter a numeric User ID:"You can find your UserID within the URL for your profile link."

Enter Parameters

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