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.

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",
  datediff(day,LastAccessDate,(SELECT MAX(LastActivityDate) FROM Posts)) as "DaysAgoLastSeen"
from Users
where Reputation > 200
  and LastAccessDate > 0
order by Round(((((UpVotes + DownVotes) / (Reputation/10.0)) * 100.0) - 100), 3) desc

fork query

created apr 1 11 mattdm