Votes in a tag per day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Show a daily breakdown of the number of upvotes (+) and downvotes (-) on questions (Q) and answers (+) in a given tag. The data is based on the question tags at the time the query is run, not on the tags at the time of the vote. The total column includes all types of votes (not just up/down but also favorite, close/reopen, etc.).

Meta Stack Exchange

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

select
  v.CreationDate as [Date],
  count(iif(v.VoteTypeId = 2 and p.PostTypeId = 1, 1, null)) as [Q+],
  count(iif(v.VoteTypeId = 3 and p.PostTypeId = 1, 1, null)) as [Q-],
  count(iif(v.VoteTypeId = 2 and p.PostTypeId = 2, 1, null)) as [A+],
  count(iif(v.VoteTypeId = 3 and p.PostTypeId = 2, 1, null)) as [A-],
  count(*) as [Total]
from Votes v
inner join Posts p on p.Id = v.PostId
inner join Posts q on q.Id = p.Id or q.Id = p.ParentId
where q.PostTypeId = 1
  and (q.Tags like '%<##Tag##>%' or q.Tags like '%é##Tag##à%')
group by v.CreationDate
order by Date asc

Enter Parameters

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