Most Bountiful Users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Sums up the bounty amounts users have given. Also ranks them based on their total bounty amounts and gives a percentage of total bounty over their current rep as well as total bounty over their supposed rep if they weren't rep-capped.

Amateur Radio

Q&A for amateur radio enthusiasts

/*SELECT
  Posts.Id,
  Posts.Title,
  Posts.ClosedDate,
  Votes.UserId,
  'http://scifi.stackexchange.com/q/' + CAST(Posts.Id AS varchar) AS Link
FROM PostFeedBack
  INNER JOIN Posts
    ON Votes.PostId = Posts.Id
WHERE Votes.VoteTypeId = 6
  AND Votes.UserId = 21267;
  
 SELECT * FROM Votes WHERE UserId = 21267;-- AND VoteTypeId = 6;
 */
 SELECT * FROM PostFeedBack WHERE VoteTypeId = 6;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results