Users with more than two question upvotes per answer upvote

0

Please login or register to vote for this query.

(click on this box to dismiss)

These users will be more or less subject to the new question reputation cap. Your user ID is added for comparison (if the ‰ column reads 666 or less, you should be more or less fine).

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

-- Users with more than two question upvotes per answer upvote
-- These users will be more or less subject to the new question reputation cap.
-- Your user ID is added for comparison (if the ‰ column reads 666 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,
  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(*) > 100 and
       SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE
           CASE WHEN PostTypeId = 2 THEN -2 ELSE 0 END END) > 0
order by [Question upvotes ‰]

Enter Parameters

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