Number of User's Posts Downvoted per Day per User

1

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

SELECT Users.Id as [User Link], Votes.CreationDate, COUNT(*) Downvotes
   FROM (
      SELECT DISTINCT Votes.PostId, Votes.CreationDate FROM Votes 
         WHERE Votes.VoteTypeId = 3
   ) Votes
   INNER JOIN Posts ON Votes.PostId = Posts.Id
   INNER JOIN Users ON Posts.OwnerUserId = Users.Id
   GROUP BY Users.Id, Votes.CreationDate
   ORDER BY Downvotes DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results