Users with more than 400 upvotes on their questions


Please login or register to vote for this query.

(click on this box to dismiss)

not including deleted questions, or community wiki questions

Server Fault

Q&A for system administrators and IT professionals

-- Enter Query Title
-- Enter Query Description
select p.OwnerUserId as [User Link], COUNT(*) 
from Votes p2v
inner join Posts p on p2v.PostId = p.Id
p.PostTypeId = 1 and
p2v.VoteTypeId = 2 and 
p.CommunityOwnedDate is null and
p.OwnerUserId is not null 
group by p.OwnerUserId
having COUNT(*) > 400
order by count(*) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results