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; the thing is more complex than this, however. Your user ID is added for comparison (if the ‰ column reads 666 or less, you should be more or less fine).

Q&A for programmers

-- Users with more than two question upvotes per answer upvote (and at least 100 votes)
-- These users will be, more or less, subject to the new question reputation cap;
-- the thing is more complex than this, however.
-- 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 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(*) > 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 ‰]

fork query

created mar 28 11 badp