@ThomasMarkov yeah, either use postlinks with linktypeid = 3 (from the top of my head) and the posthistory has the Originalqustionid burried in the json that is in the text field for typeid=10 and comment = 101 (duplicate closure): data.stackexchange.com/stackoverflow/query/1442543
I've been looking at the tables suggestededits and users because I'd like to find suggested edits made by deleted users. Not anonymous users. For anonymous users, I can just do an outer join on the users table and have users.id is null.
I'm almost sure that I've seen a suggested edit by a deleted user, as in a grayed out name with the userX (where X is the user id). But I'm not entirely sure that I have.
Is there a way for me to go about finding one such edit? Other than trying to get a moderator to let me know if there's an edit from a user that they're "now" deleting? ;)
Not that I imagine a moderator would be forthcoming with such a strange request.
Hmm.. but I'm interested in the editor only. I can find posts that have deleted users as authors. Which I've used as test cases for another part of my script.
At present I'm checking every suggested edit for the past week that doesn't have an OwnerUserId.. in the hope that I will find one. Which would settle my mind, since the absence of an example doesn't mean there isn't any :(
Basically, sure. I can find the post that has had suggested edits to them. But then I'm back as looking at a suggested edit and not knowing how to can determine the difference between those being were made by anonymous or a deleted user..
It may be so that Stack doesn't ever include the information about this difference. Neither in SEDE, but more importantly also never on suggested edit reviews. Perhaps they all just come out as being made "by an anonymous user". If this is the case, that's all good with me. Expect how do I find out if that is the case?
Okay, I still have some false positives but this looks like it is close enough to find that kind of suggested edits: data.stackexchange.com/stackoverflow/query/1442692 @Scratte All is based on the suggestion from @MartinSleziak to look at typeid = 24
I'd ask you to load the review and tell me if you see the same, but.. unfortunately for lots of us, you forgot to nominate for moderator on Stack Overflow.
SEDE - Stack Exchange Data Explorer