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 administrators and users of the CiviCRM Constituent Relationship Management software
-- Enter Query Title
-- Enter Query Description
select top 100
id as [User Link],
round((100.0 * (Reputation/10)) / (Upvotes+1), 2) as [Ratio %],
Reputation as Rep,
UpVotes as [+ Votes],
DownVotes [- Votes]
where Reputation > ##MinRep##
and Upvotes > ##MinUpvotes##
order by [Ratio %] desc