« first day (2151 days earlier)      last day (1291 days later) » 

3:20 AM
in CURED, 4 hours ago, by amWhy
I'm curious who has answered the most closed or deleted questions? There must be ways to determine this. I have a hunch who it is, but no hard data.
in CURED, 4 hours ago, by amWhy
@MartinSleziak Is there anyway to to determine the answer to my immediately preceding question? Say the top five users in terms of number of answers they gave to questions that were closed or deleted.
I don't think it is possible to get data about users on deleted posts, since the PostsWithDeleted table does not contain data about users. (Data shown in that table are indicated here: Database schema documentation for the public data dump and SEDE.)
 
hello Martin
 
What we should be able to get from SEDE is answers on closed questions which are not deleted.
SEDE: Answers on closed questions by a specific user (with close reasons) (You can change the userid to view another user - I have added some user as an example.)
I have looked also at users who both answered and closed a question - also I am less confident about those queries since I have almost no experience with handling JSON in SQL.
 
3:58 AM
And I see that I somehow did not post here the very first query - which is the closest I can get to the question asked in SEDE:
in CURED, 19 mins ago, by Martin Sleziak
@amWhy Since the PostsWithDeleted table does not contain data about users, I don't think it is possible to get data about deleted questions from SEDE. I have tried what I'm able to get about closed questions which are not deleted - some SEDE queries are posted in my room.
BTW if somebody asked me to guess who are going to be the top users in those queries, my quess would be wrong.
 
 
3 hours later…
6:43 AM
And since I see that I posted above a link to a specific revision rather than directly to the SEDE query, I will repost this one once again: Users with most answers where they closed the question.
I should probably wake up before coming here and posting things in chat. (Although I would probably make some mistakes anyway.)
 

« first day (2151 days earlier)      last day (1291 days later) »