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 subject to

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 subject to

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