6

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for cartographers, geographers and GIS professionals

-- 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
  and p.score >= 0
)
select p1.id as [Post Link], p1.ownerUserId as [User Link], body
from posts p1
join CandidatePosts cp on cp.postId = p1.parentId
where p1.ownerUserId <> ##UserId##
and p1.Score = 2
order by p1.Score DESC

fork query

edited may 10 12

created may 10 12 62921