0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

select top(##num?100##)
  pn.owneruserid as [User Link],
  sum(v.bountyamount) as [Total Bounties],
  count(v.Id) as [Count]
  from votes v
inner join posts p on v.postid = p.id
inner join postnotices pn on pn.postid = p.parentid
where v.votetypeid = 9 
---and pn.owneruserid=p.userid
and pn.Postnoticetypeid IN (10,11,12,13,14,15)
---and pn.creationdate < v.creationdate
and v.creationdate = convert(date,pn.deletiondate)
group by pn.owneruserid
order by sum(v.bountyamount) desc

fork query

edited aug 4 anonymous

created feb 3 23 Martin20528