0

Please login or register to vote for this query.

(click on this box to dismiss)

See http://data.stackexchange.com/stackoverflow/qe/375/bounties-won

Q&A for anime and manga fans

-- Bounty winners with few votes
-- See http://data.stackexchange.com/stackoverflow/qe/375/bounties-won

SELECT 
  Posts.Id As [Post Link], Posts.Score, v.BountyAmount, Posts.OwnerUserId As [User Link]
FROM 
  Votes v 
  INNER JOIN Posts ON v.PostId = Posts.Id 
WHERE
  v.VoteTypeId=9 AND Posts.Score < 1 AND v.BountyAmount > 0
ORDER BY
  Posts.Score 

fork query

created may 3 11 cas