Q&A for gardeners and landscapers
select id into #users from users where reputation > 10000 create index #ix_users on #users(id) select u.id , sum( case v.votetypeid when 1 then 15 when 2 then 10 when 3 then -2 else 0 end ) [est. rep] from #users u inner join posts p on p.owneruserid = u.id inner join votes v on v.postid = p.id and votetypeid in (1,2,3) where v.id > 267232069 group by u.id order by 2 desc