1

Please login or register to vote for this query.

(click on this box to dismiss)

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 (
      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
   WHERE Users.DisplayName = '##username##'
   GROUP BY Users.Id, CONVERT(char(7), Votes.CreationDate, 102)
   ORDER BY LeMonth, Downvotes DESC

fork query

edited sep 9 12

created sep 9 12 Izkata