Electorate Badge progress

0

Please login or register to vote for this query.

(click on this box to dismiss)

Show total votes and Total vote on question (need 600 for Electorate) (There appears to be a problem with the database, since it claims I've only votes 17 times)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

-- Electorate Badge progress
-- Show total votes and Total vote on question (need 600 for Electorate)
-- (There appears to be a problem with the database, since it claims
-- I've only votes 17 times)

SELECT
       count(*) as TotalVotes,
       SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) AS QuestionVotes
FROM    Votes v JOIN Posts p ON v.PostId=p.Id
WHERE  p.OwnerUserId =  ##UserId##;

Enter Parameters

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