0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

select top 100 C.id as [User Link], sum(D.downvotes) as downvotes,
datediff(dd,getdate(),C.CreationDate) as age
from Users as C inner join (
  select A.id as postId, A.ownerUserId as userId, B.downvotes
  from Posts as A inner join (  
    select postId, count(*) as downvotes
    from Votes
    where voteTypeId = 3
    group by postId
  ) as B
  on A.id = B.postId
) as D
on C.id = D.userId
where C.Reputation != 1
group by C.id,age,C.CreationDate
order by downvotes desc

view current version

edited jan 3 13

created jan 3 13 Andrew Leach