Active Users with Low Participation in Voting

0

Please login or register to vote for this query.

(click on this box to dismiss)

All users active in the last three months who.

Skeptics

Q&A for scientific skepticism

-- Active Users with Low Participation in Voting
-- All users active in the last three months who.

select top 1000
  id as [User Link],
  Round(((((UpVotes + DownVotes) / (Reputation/10.0)) * 100.0) - 100), 0) as [Index Rank],
  Reputation as Rep, 
  UpVotes as "+ Votes",
  DownVotes as "- Votes",
  LastAccessDate as "Last Seen"
from Users
where Reputation > 200
  and datediff(day,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) < 1
order by LastAccessDate desc 

Enter Parameters

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