« first day (3250 days earlier)      last day (450 days later) » 

Martin Sleziak
Martin Sleziak
4:53 PM
in Testing Feeds, 19 hours ago, by Nike Dattani
@MartinSleziak I wonder if you know of a modification to this query which only considers bounties that are added on other people's questions? Therefore it would exclude bounties that were awarded to one's own questions.
I think it should not be that difficult to write such queries.
Top users ordered by the amount on bounties of questions by others: data.stackexchange.com/materials/query/1704217
And this query show all three - all bounties, my own questions, questions by others: data.stackexchange.com/materials/query/1704218
Oh, now I realized you don't want all offered bounties - only the awarded ones.
 
Martin Sleziak
Martin Sleziak
5:10 PM
It is interesting that I am getting different results than the query you linked.
Here is my attempt to find bounties that were awarded: data.stackexchange.com/materials/query/1704219/…
For example, for Jack I am getting 3 bounties not awarded and 11 awarded bounties.
This is what I get using this approach as all three numbers: data.stackexchange.com/materials/query/1704220/…
As I said, I am getting different results from the query that you linked - so something might be wrong here.
 
 
1 hour later…
Martin Sleziak
Martin Sleziak
6:41 PM
Perhaps the difference might be whether we're counting the amount of reputation offered by the user and the amount of reputation that was actually awarded.
Specifically, in this case the bounty was autoawarded: mattermodeling.stackexchange.com/posts/8293/revisions
So the value of BountyAmount is different for VoteTypeId=8 (BountyStart) and VoteTYpeId=9 (BountyClose).
 

« first day (3250 days earlier)      last day (450 days later) »