user reputation history


Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

with upvQ as (
  select v.creationdate
  , sum(count(*)*5)
  over (order by v.creationdate) as score
       --    when p.posttypeid = 2 then count(*)*10 -- A 
   from posts p 
  inner join votes v on v.postid =
  where v.votetypeid = 2 --UpVote
  and p.posttypeid = 1 -- Q
  and p.owneruserid = ##uid##
  group by v.creationdate
select distinct v.creationdate, upvq.score as [Upvotes]
from votes v 
inner join upvQ on upvQ.creationdate = v.creationdate
order by v.creationdate

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results