Count of Downvotes on Your Posts per Month

0

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
      posts.owneruserid as [User Link],
      CONVERT(char(7), Votes.CreationDate, 102) as LeMonth,
      COUNT(*) Downvotes
FROM Votes
   INNER JOIN Posts ON Votes.PostId = Posts.Id
   WHERE Votes.VoteTypeId = 3
     AND posts.ownerUserID = '##userid##'
   GROUP BY posts.owneruserid, CONVERT(char(7), Votes.CreationDate, 102)
   ORDER BY LeMonth desc, Downvotes DESC

Enter Parameters

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