5

This question already has an answer here:

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?

marked as duplicate by Martijn Pieters, hims056, Azik, gnat, michaelb958 Apr 21 '14 at 11:17

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Please can anybody tell me. Why this question is down voted? – Braj Apr 21 '14 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. – Meta Andrew T. Apr 21 '14 at 7:39
  • Oh, 1 more. Because it's tagged as feature-request, where votes also mean agreement/disagreement to the request. – Meta Andrew T. Apr 21 '14 at 7:55
  • 2
    No worries. I will never ask any question here in future. Thanks a lot. – Braj Apr 21 '14 at 8:25
  • 2
    Possibly related: blog.codinghorror.com/the-end-of-ragequitting – Nick Stauner Apr 21 '14 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. – Patrick Hofman Apr 21 '14 at 8:35
  • Yes I got it. I want to delete this post. – Braj Apr 21 '14 at 9:39
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)

  • I stand corrected. :-) I forget about some of the esoteric uses of SEDE. – Ken White Apr 16 '14 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! – Chris Forrence Apr 16 '14 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 Apr 16 '14 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) – Chris Forrence Apr 16 '14 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 Apr 16 '14 at 23:25
  • @Braj - On Stack Overflow, you have one comment with at least 5 votes, so you're 10% there :) – Chris Forrence Apr 16 '14 at 23:29
  • So sad...... :( – Braj Apr 16 '14 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! – Chris Forrence Apr 16 '14 at 23:31

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