High-rep Users with only one post

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- RepThreshold: Reputation Threshold "How high their rep should be to be in the list"
select 
  u.Id as [User Link], 
  u.Reputation
from Users as u, Posts as p
where u.Reputation > ##RepThreshold:int?10000## 
  and u.Id = p.OwnerUserId
  and p.PostTypeId in (1, 2) -- question, answer
group by u.Id, u.Reputation
having count(p.Id) = 1
order by u.Reputation desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results