Number of User's Posts Downvoted per Day per User


Please login or register to vote for this query.

(click on this box to dismiss)


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

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