Count of Downvotes on Your Posts per Month

2

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT
      Users.Id as [User Link],
      CONVERT(char(7), Votes.CreationDate, 102) as LeMonth,
      COUNT(*) Downvotes
   FROM Votes
   INNER JOIN Posts ON Votes.PostId = Posts.Id
   INNER JOIN Users ON Posts.OwnerUserId = Users.Id
   WHERE Votes.VoteTypeId = 3
     AND Users.DisplayName = '##username##'
   GROUP BY Users.Id, CONVERT(char(7), Votes.CreationDate, 102)
   ORDER BY LeMonth, Downvotes DESC

Enter Parameters

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