Questions upvoted by low rep users only

0

Please login or register to vote for this query.

(click on this box to dismiss)

To investigate CodeGray's claim in http://meta.stackoverflow.com/a/318576/794234 that LQ questions are being upvoted by a subset of low rep users.

Stack Overflow

Q&A for professional and enthusiast programmers

select
  top 10
  v.PostId as [Post Link],
  sum(case when u.Reputation < ##ReputationThreshold## then 1 else 0 end) as LowRepUpvotes

from
  Votes v
  inner join (select Id, Reputation from Users) u on u.Id = v.UserId
  
where
  v.VoteTypeId = 2
  
group by
  v.PostId
  
having
  sum(case when u.Reputation < ##ReputationThreshold## then 1 else 0 end) > ##VoteCount##
  and sum(case when u.Reputation >= ##ReputationThreshold## then 1 else 0 end) = 0

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results