→ 2 messages moved to Sandbox/Trash Bin/Something

@cairdcoinheringaahing I've done the pivot query as well as an exercise for myself. This shows the top 10 close voters overall and the posts they voted on: data.stackexchange.com/codegolf/query/1409173

@rene Oh, wow! Is there a way to turn the ids into user links? I tried adding as [User Link] to line 5, but it didn't like that

Yeah, hold on

@cairdcoinheringaahing that is now fixed: data.stackexchange.com/codegolf/query/1409173/…

Ah nice! IIRC 45941 is Mego, who deleted their account so makes sense that doesn't show up

Oh, one close voter 45941 no longer exists

right

This having a count of 6 is interesting

yeah, race conditions are possible

There is no logic in the app or db layer to catch those

No, it got closed and reopened multiple times as a dupe of a couple of different challenges

Oh, right

I should maybe count per PostHistory.Id, not by postid

also fixed