79320356

Date: 2024-12-31 16:04:10
Score: 4
Natty:
Report link

Many thanks to @rene for his ideas in the comments to the question.

Here is the query that calculates the user's reputation for posts no older than 365 days.

select posts.owneruserid [User Link]
     , sum( case votes.votetypeid
            when 1 then 15
            when 2 then 10
            when 3 then -2
            else 0
            end
        ) [estimated rep.]
from posts
inner join votes on votes.postid = posts.id
where posts.creationdate > dateadd(dd, -365, getdate())
and posts.owneruserid = ##userId##
group by posts.owneruserid
Reasons:
  • Blacklisted phrase (0.5): thanks
  • RegEx Blacklisted phrase (1.5): reputation
  • Probably link only (1):
  • Has code block (-0.5):
  • User mentioned (1): @rene
  • Self-answer (0.5):
Posted by: nik0x1