0

Please login or register to vote for this query.

(click on this box to dismiss)

This query calculates how much reputation has been cut off because you reached the limit of 200 reputation per day (through upvotes).

Q&A for anime and manga fans

DECLARE @UserId int = ##UserId:int##

SELECT * FROM
(
SELECT COUNT(*) as Upvotes,
       Votes.CreationDate AS CreationDate
FROM   Posts
INNER JOIN Votes ON
  Votes.PostId = Posts.Id AND
  VoteTypeId = 2
WHERE  Posts.OwnerUserId = @UserId
-- Technically, this should remove votes *after* the CommunityOwnedDate,
-- so let's be overinclusive
--       AND Posts.CommunityOwnedDate IS NULL
GROUP BY Votes.CreationDate
UNION
SELECT COUNT(*) as Accepts,
       CreationDate
FROM Posts
WHERE Posts.OwnerUserId = @UserId
GROUP BY CreationDate
) as BackingData
--HAVING COUNT(*) >= 20
--ORDER BY Votes.CreationDate DESC

fork query

edited may 8 jon.doe33355

created apr 15 11 halfdan