;with rep as ( select owneruserid , sum( case posttypeid ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

;with rep as (
select owneruserid
     , sum(
       case posttypeid 
       when 1 then
          score * 5   
       when 2 then
          score * 10
       else 0
       end
     ) as reputation
from posts
group by owneruserid
)
select id as [User Link]
from users u
inner join rep r on u.id = r.owneruserid
where u.reputation = 1 
and r.reputation > u.reputation
order by creationdate
, lastaccessdate desc


select *
from users
where id = 518227

Enter Parameters

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