1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for serious players and enthusiasts of chess

select 
(select count(*)*15 from votes
where VoteTypeId = 1
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=##user##
)*100.0/Reputation as "% Rep from accepted"
,
(
(select count(*) from votes
where VoteTypeId = 2
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=##user##
)*10 - (select count(*) from votes
where VoteTypeId = 3
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=##user##
) * 2
)*100.0/Reputation as "% Rep from votes"
,
(SELECT count(*)*2 FROM  SuggestedEdits where OwnerUserId=##user## 
AND ApprovalDate is not null AND RejectionDate is null
)*100.0/Reputation as "%Rep from edits"
,
(select sum(BountyAmount) from votes 
where votetypeid=9
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=##user## 
)*100.0/Reputation as "% Rep from bounties"

FROM Users where Id=##user##
--240512

fork query

edited sep 24 18

created sep 24 18 VadimTagil