Posts that allow you to get the sportsmanship badge by voting on them. This gives you an idea if you can even get this badge. It is not possible to show your progress toward the badge because the data is cleansed of any upvote information tied to a userId. This gives you a list of answers you can upvote (if you like them). If there is not 100 items in this list, you can't get the badge.
Q&A for Ubuntu users and developers
-- How close am I to the Sportsmanship Badge -- Posts that allow you to get the sportsmanship badge by voting on them. This gives you an idea if you can even get this badge. It is not possible to show your progress toward the badge because the data is cleansed of any upvote information tied to a userId. This gives you a list of answers you can upvote (if you like them). If there is not 100 items in this list, you can't get the badge. WITH CandidatePosts AS ( select ParentId postId from posts p where p.OwnerUserId = ##UserId## and p.postTypeId = 2 ) select distinct p1.parentId as [Post Link] from posts p1 join CandidatePosts cp on cp.postId = p1.parentId where p1.ownerUserId <> ##UserId##