High-Rep Users with only one post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
  'site://users/' + CAST(u.id as nvarchar) + '|' + CAST(u.displayname as nvarchar) AS [User], 
  u.reputation,
  count(p.id)
from users u, posts p
where u.reputation > 10000 and 
  u.id = p.owneruserid and 
  (p.posttypeid = 1 or p.posttypeid = 2)
group by u.id, u.displayname, 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