List my downvoted posts that were edited

Question

Consider the following situation:

• I downvote a question / answer with a comment
• The answerer / asker edits the question and improves it

In that case, I think the downvote should be removed.

I know it's possible to find my downvotes by going to:

http://stackoverflow.com/users/1438393/?tab=votes&sort=downvote

but that requires me going to each and every post, check if it was edited etc. I was wondering if it can be done with the StackExchange Data Explorer.

I've looked at the existing queries searched for a similar one but couldn't find anything except this and this.

(I've seen this answer by Jeff and this is just a personal view)

So, my question is: how can I list the posts that I downvoted that were edited later?

Answer 1

As explained who voted is not contained within the Data Explorer as that would involve making downvotes public.

What you're suggesting would be a nice to have for the good citizens who go back¹. If you are a good citizen, and always explain how the post could be improved, you could look for posts that were edited by the OP after your comment and where there was a downvote prior to the OPs edit. You can't know who downvoted but you can check if one occurred.

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

Here's the Data.SE query.

_{1. I probably wouldn't use it much as if I've commented I check back to see if the OP has replied but not thought to tell me about it.}