Top 100 Users that rarely upvote in comparison to the
estimated amount of upvotes they received (doesn't account
for e.g. bounties but should give a sufficient estimation).
Useful settings (MinRep, MinUpvotes): (1000, 100), (10000, 0).
Q&A for Tridion developers and administrators
-- Enter Query Title
-- Enter Query Description
select top 100
count(*) as NumberOfUser,
UpVotes/1000 as UpvotePerK
where Reputation > ##MinRep##
group by UpVotes/1000
order by UpVotes/1000 asc