Reputation cap cut off

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).

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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,
  DATETRUNC(day, CreationDate) as CreationDate
FROM Posts
WHERE Posts.OwnerUserId = @UserId
GROUP BY DATETRUNC(day, CreationDate)
) as BackingData
--HAVING COUNT(*) >= 20
--ORDER BY Votes.CreationDate DESC

Enter Parameters

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