Reputation history (accurate, including everything except bounties)

3

Please login or register to vote for this query.

(click on this box to dismiss)

Accurate for all up/down votes, including rep cap and even accepting answers to your own questions

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select
  cast(v.CreationDate as Date) as date,
  sum(case
    when v.VoteTypeId = 1 then 15
    when v.VoteTypeId = 2 and p.PostTypeId = 1 then 5
    when v.VoteTypeId = 2 and p.PostTypeId = 2 then 10
    when v.VoteTypeId = 3 and p.PostTypeId = 1 then -1
    when v.VoteTypeId = 3 and p.PostTypeId = 2 then -2
    end) as score
from votes v
join posts p on p.Id = v.PostId and p.posttypeid in (1,2)
where v.creationDate between dateadd(d, -14, getdate()) and getdate()
  and p.OwnerUserId = ##UserId##
  and p.CommunityOwnedDate is null
group by cast(v.CreationDate as Date)
order by 1 desc

Enter Parameters

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