@Martin it doesn't look like it on SO: data.stackexchange.com/stackoverflow/query/1417397

Maybe do something with Postnotice deletion: data.stackexchange.com/stackoverflow/query/1417398

What happens if there are several bounties on the same post? data.stackexchange.com/stackoverflow/query/1417401 stackoverflow.com/posts/58030867/revisions

Oh, I see - the condition v.creationdate = convert(date,pn.deletiondate) takes care of that problem.

I hoped that fiddeling with dates would rectify

But I need pn.postid = p.parentid if I want bounties which were awarded: data.stackexchange.com/stackoverflow/query/1417402

Unless I missed something, the query you posted above returns only the bounties that weren't awarded to any answer.

@Martin yeah, correct

@Martin Yeah, I was expecting to see other users then community to be the deletionuserid but I didn't dig in to see where that is off.

I'll revisit in 6 to 8 hours

I tried this: Users whose answers received the most bounties from me

Still, there is some problem - Asaf Karagila should have more than 50 reputation points from my bounties: math.stackexchange.com/posts/145279/revisions math.stackexchange.com/posts/56471/revisions

This is list of answers I get from such query: data.stackexchange.com/math/query/1417404/…

Oh, I see, I need to include 15 as a possible PostNoticeTypeid. (15=reward existing answer)

So now I get 98 answers and 108 questions.

So perhaps I have offered 10 bounties that weren't awarded to any answer: data.stackexchange.com/math/query/1417408/…

Now those results seem more believable: Users whose answers received the most bounties from me

@Martin ah, I was too conservative on the postnotice. I should have linked to postnoticeypes and then look for Classid = 2

It seems to be from 10 to 15: data.stackexchange.com/math/query/1417428 (But it's good to know that ClassId could be used.)

Awesome idea ^

@rene I agree, it came from a discussion in the litter box where I would randomly spit out trivia, and then other users joined in, so we decided to compile a meta post! :) Very fun :D

Yeah, I'll circle back in the coming days to see what gets posted