Users whose answers received the most bounties from me

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  bstart.CreationDate,
  q.owneruserid as [User Link],
  q.id as [Post Link],
  bstart.bountyamount,
  case when u.id is NULL then ''
       else FORMATMESSAGE('site://users/%d|%s', u.id, u.DisplayName) 
       end as [Recipient]
from votes as bstart
inner join posts q on bstart.postid = q.id
left join posts a on q.id = a.parentid
left join votes baward on baward.postid = a.id
left join users u on a.owneruserid = u.id
where 
    bstart.votetypeid = 8
and bstart.userid=##userid?5377037##
and bstart.userid != q.owneruserid
and (baward.votetypeid is NULL or baward.votetypeid = 9)
order by 1 desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results