0

Please login or register to vote for this query.

(click on this box to dismiss)

not including deleted questions, or community wiki questions

Q&A for participants in team and individual sport activities

-- Users with more than 400 upvotes on their questions
-- not including deleted questions, or community wiki questions

select p.OwnerUserId as [User Link], u.Reputation, COUNT(*) as "Question upvotes"
from Votes p2v
join Posts p on p2v.PostId = p.Id
join Users u on p.OwnerUserId = u.Id
where 
p.PostTypeId = 1 and
p2v.VoteTypeId = 2 and 
p.CommunityOwnedDate is null and
p.OwnerUserId is not null 
group by p.OwnerUserId, u.reputation
having COUNT(*) > 400
order by reputation desc

fork query

created mar 28 11 badp