Users with more than eight question upvotes per answer upvote (and at least 400 votes)

0

Please login or register to vote for this query.

(click on this box to dismiss)

These users would be, more or less, subject to the new question reputation cap under my proposal; the thing is more complex than this, however. Your user ID is added for comparison (if the ‰ column reads 888 or less, you should be more or less fine).

Stack Overflow

Q&A for programmers

-- Users with more than eight question upvotes per answer upvote (and at least 100 votes)
-- These users would be, more or less, subject to the new question reputation cap under my proposal;
-- the thing is more complex than this, however.
-- Your user ID is added for comparison (if the ‰ column reads 888 or less,
-- you should be more or less fine).

-- Please don't mind my SQL. It's horrible. I know.

select
  p.OwnerUserId as [User Link],
  u.Reputation as "Rep",
  SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) as "Question upvotes",
  SUM(CASE WHEN PostTypeId = 2 THEN 1 ELSE 0 END) as "Answers upvotes",
  SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END)*1000/COUNT(*) as "Question upvotes ‰"
from Votes p2v
join Posts p on p2v.PostId = p.Id
join Users u on p.OwnerUserId = u.Id
where 
p2v.VoteTypeId = 2 and 
p.CommunityOwnedDate is null and
p.OwnerUserId is not null 
group by p.OwnerUserId, u.Reputation
having p.OwnerUserId = ##UserId## or 
       COUNT(*) > 400 and
       SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE
           CASE WHEN PostTypeId = 2 THEN -8 ELSE 0 END END) > 0
order by [Question upvotes ‰]

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached