7

I have a simple query about Pundit budge (left 10 comments with score of 5 or more).

How close am I for the Pundit badge?

8
  • Please can anybody tell me. Why this question is down voted?
    – Braj
    Commented Apr 21, 2014 at 7:31
  • First, because it's tagged wrongly. It should be tagged as support, not feature-request (you weren't requesting this feature to be implemented on the whole SE network, right?). Second, if you search more carefully, you can find this question which more or less the same as you ask. Commented Apr 21, 2014 at 7:39
  • Oh, 1 more. Because it's tagged as feature-request, where votes also mean agreement/disagreement to the request. Commented Apr 21, 2014 at 7:55
  • 2
    No worries. I will never ask any question here in future. Thanks a lot.
    – Braj
    Commented Apr 21, 2014 at 8:25
  • 2
    Possibly related: blog.codinghorror.com/the-end-of-ragequitting Commented Apr 21, 2014 at 8:26
  • 2
    @Braj: There is no need to say that. We are here to help, and useful questions are appreciated with upvotes. Questions that lack searching effort will get downvoted. That's just the way it works. Commented Apr 21, 2014 at 8:35
  • Yes I got it. I want to delete this post.
    – Braj
    Commented Apr 21, 2014 at 9:39
  • meta.stackexchange.com/a/296061/229836
    – Adam Johns
    Commented May 16, 2017 at 15:36

1 Answer 1

6

You can use a Data Explorer query (this one for example). According to it, you have one eligible comment on Stack Overflow.

In addition, by using the following query:

DECLARE @UserId int = ##UserId##

SELECT 
  SUM(Comments.Score) CommentScore, 
  COUNT(Comments.Id) CommentCount
FROM Comments
  INNER JOIN Posts ON Comments.PostId = Posts.Id
WHERE 
  UserId = @UserId

You can count the total score of your comments (in this case, 76)

8
  • I stand corrected. :-) I forget about some of the esoteric uses of SEDE.
    – Ken White
    Commented Apr 16, 2014 at 23:11
  • @KenWhite - No worries! The Data Explorer is pretty darn cool, but I did mess up my original query (I was counting all the comments). It should be right now! Commented Apr 16, 2014 at 23:17
  • Well, at least I'd only left a comment to the question and not an answer. :-) You might want to point out that the total comment vote count is meaningless after Pundit is awarded, though; the information is irrelevant, as comments are second-class citizens and meant to be transitory.
    – Ken White
    Commented Apr 16, 2014 at 23:20
  • @KenWhite - Very true, and for the case of Pundit, the total comment vote count is actually very much useless. What matters more is that first query, since that sorts the individual comment scores (so you can see which ones have at least 5 vote) Commented Apr 16, 2014 at 23:22
  • @ChrisForrence thanks a lot for this link. Now I have modified the query as per my requirement. Basically I want to know how close I am to Pundit Badge?
    – Braj
    Commented Apr 16, 2014 at 23:25
  • @Braj - On Stack Overflow, you have one comment with at least 5 votes, so you're 10% there :) Commented Apr 16, 2014 at 23:29
  • So sad...... :(
    – Braj
    Commented Apr 16, 2014 at 23:30
  • 1
    @Braj - You're still young on the site though (two months and 4k+ reputation). The badge will come in time, no worries! Commented Apr 16, 2014 at 23:31

Not the answer you're looking for? Browse other questions tagged .