How many anonymous upvotes and downvotes are there?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

select vt.Name, 
       pt.Name, 
       count(*) 'Anonymous feedback'
from PostFeedback
     join VoteTypes vt on vt.Id = VoteTypeId
     join Posts p on p.Id = PostId
     join PostTypes pt on PostTypeId = pt.Id
group by vt.Name, pt.Name;

select vt.Name, 
       pt.Name, 
       count(*) Votes
from Votes
     join VoteTypes vt on vt.Id = VoteTypeId
     join Posts p on p.Id = PostId
     join PostTypes pt on PostTypeId = pt.Id
where vt.Id in (2,3)
and pt.Id in (1,2)
group by vt.Name, pt.Name;

Enter Parameters

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